Hi attached is the excel sheet,in this sheet I have one table and its output. what formula I can use to get this output.
Hi attached is the excel sheet,in this sheet I have one table and its output. what formula I can use to get this output.
Enter this formula in F5 and pull it to G5 and then down for list A
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$5:$B$19)/(($B$5:$B$19<>0)),ROWS(A$5:A5))),"")
For list B
J5 and copy down
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($C$5:$C$19)/(($C$5:$C$19<>0)),ROWS(A$5:A5))),"")
in K5 and copy down
=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($C$5:$C$19)/(($C$5:$C$19<>0)),ROWS(B$5:B5))),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks a lot, It worked.
What if I have to make list A & List B into a one list without the zero values.
Means "List" of unique A and unique B in a one column and unique A & unique B values into second column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks