Dear Experts
In attached sample sheet, for each person I would like to know how many times the IN is greater than 10:05. How can i do this please
Dear Experts
In attached sample sheet, for each person I would like to know how many times the IN is greater than 10:05. How can i do this please
Your "in" times are text, not real time
Use this in a helper column (I used G)...
G2=TIMEVALUE(F2)
copied down
Then create a list of unique names. I did a quick list by copying all the names into I, then removing duplicates.
For your list...
=COUNTIFS($G$2:$G$1000,">10:05",$C$2:$C$1000,I2)
copied down
I J 1Full Name 2Shubham Mishra 13 3Dhanalakshmi 0 4Sumalatha 0 5Nayana 2 6Lavanya N 2 7Shivaranjini 6 8Pallavi S 3 9Shashank Singh 2 10Shubha K 6 11Chaya Kumar Swamy P 4 12Pooja J 4 13Bhavana C S 1 14Manjunath R 0 15Lalitha T S 7 16Nidhi Pansari 0 17Shoib Ulla Khan 2 18Riya Jain 3 19Shyam .Sundar 3 20Ravi Kumar .C 3 21Ramesh 15 22Anand R 0 23Manoj M 0 24Kavya N 0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you can you please share excel sheet how it is done please
I thought I explained pretty well, but here is your file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks