ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 960
- Office Version
- 365
- 2010
- Platform
- Windows
The following formula will sort a range of cells from small to large removing duplicates.
Is there a way to change the formula to sort from the largest value to the smallest?
=IFERROR(AGGREGATE(15,6,$A2:$O2/($A2:$O2<>"")/(ISNA(MATCH($A2:$O2,$P2:P2,0))),1),"")
Thank you
Is there a way to change the formula to sort from the largest value to the smallest?
=IFERROR(AGGREGATE(15,6,$A2:$O2/($A2:$O2<>"")/(ISNA(MATCH($A2:$O2,$P2:P2,0))),1),"")
Thank you