Hi all,
my ask is simple, I have list of Fruit code along with various time entry.
all that i need is against fruit code i need to find maximum time or greatest time spent.
Below is the list of Fruit code :
R3001
R4000
S5000
you can see simple data in attached file
Thank you
If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.
Put in K5 and copied down
=IFERROR(IF(COUNTIFS($B$2:$B$17,J5,$D$2:$D$17,"")=0,AGGREGATE(14,6,$D$2:$D$17/($B$2:$B$17=J5),1),""),"")
Another way. Is the COUNTIFS required?Formula:
Please Login or Register to view this content.
Last edited by FlameRetired; 02-12-2019 at 12:47 AM.
Dave
If by chance your profile is not up to date this works in Office 365.Formula:Please Login or Register to view this content.
works for greater time.
This creates further curiousness, then what is the formula to get the least time ?
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks