Hello
I need sort automatic my data when they reach value
please look at my attached file : when "P" reach value as "6" then gets to top of the list automatically.
thank you in advance
https://www.excelforum.com/attachmen...1&d=1658577176
Hello
I need sort automatic my data when they reach value
please look at my attached file : when "P" reach value as "6" then gets to top of the list automatically.
thank you in advance
https://www.excelforum.com/attachmen...1&d=1658577176
Last edited by soubasa; 07-23-2022 at 09:55 AM.
E1:
=IFERROR(LARGE($A$1:$A$25,ROWS(E$1:E1)),"")
F1:
=INDEX(B:B,AGGREGATE(15,6,ROW($A$1:$A$20)/($A$1:$A$20=E1),COUNTIF($E$1:$E1,E1)))
The white on black drove me mad...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks