Hi guys, how do I use Index match where I want to use LARGE and ">20" where the two values are in different columns?
Capture2.PNG
Hi guys, how do I use Index match where I want to use LARGE and ">20" where the two values are in different columns?
Capture2.PNG
into I3:
Formula:Please Login or Register to view this content.
accept with Ctrl+Shift+Enter and drag it down.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Try this. In E2 then drag down.
=IFERROR(INDEX($A$2:$A$6,AGGREGATE(15,6,ROW($B$2:$B$6)/($B$2:$B$6> 20),ROWS($E$2:$E2))-ROW($B$2)+1),"")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
You welcome.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
i ask one question.If i want >=20,<=30,the answer should be within i3 one cell with commos ,descending order and numbers not repeated,without#num.IE 6,2.Suppose both instead of value 2 is 6.i need one time 6.what formula need achieve this answer?.same cell with in multiple anwers with commos,without repeat the numbers.
Last edited by pok; 06-19-2019 at 10:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks