the summary is the example for paul
see attached excel file
if i filtered date, i want the summary result for the paul should change as well.. please help
the summary is the example for paul
see attached excel file
if i filtered date, i want the summary result for the paul should change as well.. please help
any solution to my post.. i can see more than 100 viewers on my post.
the problem is i want to sort filter for date. so if the date sorted then result for summary should change.
example if i sort filter by date between 17th july to 19th july then the result of the value in summary for hours/minutes/time sign in/sign out for paul should appear or display.
currently the summary display can't change even you sort filter
the summary will consists of each person name but i only leave paul there as example
please help me and re-attach your solution excel file
thanks and hear from you soon
We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. Since bumped threads have replies, they will no longer appear in the "Zero Reply Posts" listing, which many members use to look for unanswered questions. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.
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
i think you remove this post now...
why, because you dont have much patience?
As per your sample data
In "F18" =IFERROR(HOUR(C18-B18),"0")
"G18" =IFERROR(MINUTE(C18-B18),"0")
"B3" =SUMIF(A:A,A3,F:F)
"C3" =COUNTIFS(A:A,Table14[[#This Row],[NAME]],F:F,">=1")
"D3" =COUNTIFS(A:A,Table14[[#This Row],[NAME]],F:F,"0")
file attach for your ref.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Change formula to avoid error:
F18 =IFERROR(HOUR(C18-B18),"0")
G18 =IFERROR(MINUTE(C18-B18),"0")
To update the date fiter, in B3:
C3:Please Login or Register to view this content.
E3:Please Login or Register to view this content.
Please Login or Register to view this content.
Quang PT
bebo021999.......
Can you send answer in excel please
Thanks for feedback avk...
Pls see attachment along with formula in #7
bebo021999
Thank you too much for your big help.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks