ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 958
- Office Version
- 365
- 2010
- Platform
- Windows
Helo everyone,
I wanted to ask how to sort a range of numbers in a cell range with blanks.
I found the following formula and changed to match my cell ranges.
=SMALL($AN20:$CW20,COLUMNS($CY20:CY20))
1>Ascending order
2>Remove any duplicates
Example: cell range AN20:CW20
1,4,6,48,55,1,22,73,46,46,81,6,46
What I would like to display starting in cell CY20
1,4,6,22,46,48,55,73,81
Thank you in advance
I wanted to ask how to sort a range of numbers in a cell range with blanks.
I found the following formula and changed to match my cell ranges.
=SMALL($AN20:$CW20,COLUMNS($CY20:CY20))
1>Ascending order
2>Remove any duplicates
Example: cell range AN20:CW20
1,4,6,48,55,1,22,73,46,46,81,6,46
What I would like to display starting in cell CY20
1,4,6,22,46,48,55,73,81
Thank you in advance