Excel Query

tulsi_1940

OURS IS AN ORGANISATION OF 28 MEMBERS. WE USE biometric attendance system SYSTEM FOR CALCULATING ATTENDANCE. . IN ATTENDANCE EXCEL SHEET ONE NUMBER IS OCCURRING 25 TO 26 TIMES IN A MONTH WITH TIMINGS AND WE HAVE FIXED 9.30 IS AS OUR INCOMING TIMING AFTER 0945 WE USED TO PUT LATE MARK.
GUYS CAN YOU SUGGEST ME SOME EASY METHODS TO FIND OUT HOW MANY TIME A PARTICULAR NUMBER IS OCCURS AFTER 9:46 BY USING SOME FORMULAE

jeevarathnam

Hi Tulsi
You shall use the below formula
=COUNTIF(E2127:E2135,">9.45") (=COUNTIF(Strat cell ref no:End Cell Ref no,">9.45"))

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute