Unique Function - Horizontal Spill

Question

Hi,I want the results of a list returned by Unique to spill horizontally along one same row - not vertically down a column.Does anyone know how to do that please?&nbsp;

riny_van_eekelen · Answer

E_C_Tony&nbsp;Use this:=TRANSPOSE(UNIQUE(..........))

oliverscheurich · Answer

E_C_Tony&nbsp;=TRANSPOSE(UNIQUE(B10:B17))You can try UNIQUE inside TRANSPOSE.&nbsp;

e_c_tony · Answer

OliverScheurich&nbsp;Hi both,Thanks for your replies.I can get Unique nested inside Transpose to work only when a fixed number of items are returned every time.The number of items returned by the workbook I am using varies.&nbsp;The spill facility handles that very well but the workbook layout means I need that to spill horizontally, not vertically.&nbsp;Does anyone know a way to do that?&nbsp;&nbsp;&nbsp;&nbsp;

oliverscheurich · Answer

E_C_Tony&nbsp;=TRANSPOSE(UNIQUE(FILTER(B3:B17,B3:B17&gt;E2)))I can only guess what you exactly want to do. For example the above formula dynamically spills the result horizontally because the original data is in vertical order in range B3:B17. The filter criteria is B3:B17&gt;E2 which means you can change the value in cell E2 and the formula automatically spills the result (a varying number of cells) horizontally.Otherwise you might want to attach a screenshot without sensitive data which shows your data and expected result.&nbsp;

e_c_tony · Answer

OliverScheurich&nbsp;&nbsp;Hi, thanks again for your reply.&nbsp;&nbsp;That looks great; I'll give it a try.&nbsp;&nbsp;

Forum Discussion

Unique Function - Horizontal Spill

5 Replies

Resources