Find Unique value with excel formula

[Rahul Mishra]

Sir,
How can i find unique value as it is in another column i attached file plz provide me solution.

 

[Somendra Misra]

Hi Rahul,

See attached file for formulas in Orange cells.

Regards,

 

[Rahul Mishra]

sir thank u so much but it is so long formula any short formula plz ..........

 

[Somendra Misra]

Is this a one time activity or repeated activity?

Regards,

 

[Rahul Mishra]

no sir wanna dynamic means if i change in raw data many times then output should also change.

 

[Somendra Misra]

@Rahul Mishra

More than the length of the formula, you should worry about calculation time of array formula, esp. in the case of extracting unique values. If you data grows in future than VBA will be best to get the result quickly.

Regards,

 

[Rahul Mishra]

u are right but i found one fourmula for this but i didn't get understand abut this formula is INDEX(H2:H329,MATCH(0,INDEX(COUNTIF(I1,H2:H329),0,0)))

 

[Khalid NGO]

Hi Rahul,

You will find some interesting things about comparing 2 list of data in excel.
See the link below:
http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/