Hi,
I have a list of data.I want to extract data that contains 'same' and then resulting figure data should be sorted in descending order as enclosed in attachment.
Hi,
I have a list of data.I want to extract data that contains 'same' and then resulting figure data should be sorted in descending order as enclosed in attachment.
For xl 2021 how aboutFormula:Please Login or Register to view this content.
for older versions
Small could be replaced by aggregate
Put header to data and try
=SORT(FILTER(FILTER(Data!A6:L9,Data!L6:L9="same"),ISNUMBER(MATCH(Data!A5:L5,A5:E5,))),4,-1)
As an alternative, this works in Google Sheets but I'm not sure if it works in MS Excel;
Please Login or Register to view this content.
Thanx all of u for your kind support
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks