Extracting unique values across Columns & Rows

Hi,

I have tried to extract the unique values across columns & rows without additional helper column & not able to avoid helper columns.

Please help me out to extract unique values without helper columns (Using worksheet functions only)

Alternative forums
http://www.mrexcel.com/forum/excel-q...umns-rows.html

hi ramanahrm. try this array formula:

Formula:

Please Login or Register  to view this content.

http://www.get-digital-help.com/2009...rray-formulas/

Edit: this might be faster in calculations:

Formula:

Please Login or Register  to view this content.