bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 701
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have the formula array formula that works great. However, I would like to modify it so it sorts from smallest to largest. Right now, it is sorting largest to smallest and not vice versa. I did trying nesting this inside the Small function but I may not have set up the Rows function properly. Or should I use the Aggregate instead? Do I have the Rows function set up properly or should I use the row function instead?
Thank you for your help,
Michael
Code:
SMALL(LOOKUP(2,1/(((COUNTIF($J$1:J2,$F$2:$F$2000)=0)*(COUNTIF($F$2:$F$2000,$F$2:$F$2000)>1))),$F$2:$F$2000),ROWS($A$1:A1))
Thank you for your help,
Michael