Dear all!
In the sheet, I have data in column A:J in x ammount of rows
In column A is the data that I need a unique list of, because it can be reoccuring, and in column B that are numbers. I would like to list all rows (or all cells in that row from A to J column), that has a unique value in column A that have the highest corresponding values in column B.
I hope it's clear what I'm asking.
I'm attaching an example worksheet with the result I want to get.
Thank you in advance!
See attached:
in L20
=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF($L$19:L19,$A$2:$A$15),0)),"")
Enter with Ctrl+Shift+Enter and copy down
in N20
=IFERROR(INDEX($C$2:$J$15,AGGREGATE(15,6,ROW($A$1:$A$15)/($A$2:$A$15=$A20),COUNTIF($A$2:$A$15,$A20)),COLUMN(A$1)),"")
Copy across and down
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
unique column AFormula:
Please Login or Register to view this content.
max column BFormula:Please Login or Register to view this content.
dataFormula:Please Login or Register to view this content.
Option with Power Query
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