GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
hello everybody!
you can see here a very difficult formula that extract a unique list of items display horizzontaly
I need to convert this array formula without making CTRL+SHIF+ENTER maybe with the function AGGREGATE.
Is it possibile?
thank you very much in advance!!
{=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:C11))),"")}
you can see here a very difficult formula that extract a unique list of items display horizzontaly
I need to convert this array formula without making CTRL+SHIF+ENTER maybe with the function AGGREGATE.
Is it possibile?
thank you very much in advance!!
{=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:C11))),"")}