LinkBack URL
About LinkBacks
Hello,
i need a formula that can count the number of duplicates and look of the highest value against the duplicate and lookup another data.
Please see attached for details. thanks heaps.
Hello,
i need a formula that can count the number of duplicates and look of the highest value against the duplicate and lookup another data.
Please see attached for details. thanks heaps.
Last edited by spr2017; 01-15-2018 at 12:04 AM.
I used a pivot table in the attached.
Type it in E2 then drag down:
Please Login or Register to view this content.
Quang PT
Try this in E2:
=IF(B2=MAX(INDEX(($A$2:$A$15=A2)*$B$2:$B$15,0)),COUNTIF(Table1[Work Approval],Working!A2),"")
Hello Phuocam,
can i add that the count should work only if its under a certain date? say the date is in col I on the Data tab? i've just changed the file to add a col.
Last edited by spr2017; 01-14-2018 at 09:23 PM.
Hello,
can i add that the count should work only if its under a certain date? say the date is in col I on the Data tab? i've just changed the file to add a col.
Hello,
can i add that the count should work only if its under a certain date? say the date is in col I on the Data tab? i've just changed the file to add a col.
Can you upload the updated file again? I could not find it
oops sorry its now visible. thanks
I am not sure whether it need to be counted or added?
If count the ID (=1)
In E5
If sum (=12)Please Login or Register to view this content.
Please Login or Register to view this content.
perfect thanks. I did try countifs but i must have missed <= in quotes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks