Auto update of Unique Values

[chssundeep]

Hi Freinds,

In sheet1, I enter the IDs of different machinerys every month..... I need the unique machinery ids in second sheet automatically...

Attached the sample file.....

 

[Khalid NGO]

Hi,

Try this {array formula} in C5:

=IFERROR(INDEX(Sheet1!$B$5:$B$999,MATCH(0,COUNTIF($C$4:C4,Sheet1!$B$5:$B$999),0)),"")

{array formula needs to be entered with the key combination of
Ctrl+Shift+Enter, not just enter}

Adjust the range as required.

Another option is to use Pivot Table.

Regards,