legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,168
- Office Version
- 365
- Platform
- Windows
I have the following array formula that requires CSE, but would like to change it so I don't use CSE. I think AGGREGATE function would be a substitute?? Can someone help.
{=IF(ROWS($C$4:C4)<=$D$4,INDEX($C$4:$C$51,SMALL(IF(FREQUENCY(IF($C$4:$C$51<>"",MATCH($C$4:$C$51,$C$4:$C$51,0)),ROW($C$4:$C$51)-ROW($C$4)+1),ROW($C$4:$C$51)-ROW($C$4)+1),ROWS($C$4:C4))),"")}
{=IF(ROWS($C$4:C4)<=$D$4,INDEX($C$4:$C$51,SMALL(IF(FREQUENCY(IF($C$4:$C$51<>"",MATCH($C$4:$C$51,$C$4:$C$51,0)),ROW($C$4:$C$51)-ROW($C$4)+1),ROW($C$4:$C$51)-ROW($C$4)+1),ROWS($C$4:C4))),"")}
Last edited: