Excel Magic Trick #187: Unique List w Dynamic Formula

[DiscoverArts]

I know the best course of magic

[varunchh]

I am not able to extract UNIQUE RECORD, not sure what is going wrong. I followed your formula but except first value for remaining value it is giving "#NUM". Can you please help me. 

[ExcelIsFun]

It is too hard to have a dialog about an Excel solution with YouTube comments. Try post a question at THE best Excel question site:

mrexcel[dot]com/forum

BUT be sure to provide a clear question, say how your data is set up, and what your expected result is.

After you post, send me the link and I can take a look, however, there are 1000s of other people that may provide an answer before me.

[ExcelIsFun]

You can also send workbook example to me at: excelisfun at gmail.

[Pelonetillo]

i like the countif trick for the unique numbers, but is there a simple way to populate the unique records cell without relying on another cell to distinguish the first instance with a 1? also if possible to count unique only if another column has a "yes" for example. thanks!

[ExcelIsFun]

I have a very long comprehensive video about Unique value formulas using the FREQUENCY. It should answer both of your questions:

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)

also check this video:

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

[Markblackburn86]

This is great! thank-you. Do you have a video that shows how to do this with formulas without using the column "c"? so the end result would be 2 lists 1=master 2=unique of Master. I look forward to your reply, thanks again.

[ExcelIsFun]

I am in an untenable situation where I am working 80+ hours a week at work and am unable to answer questions currently. Sorry. Try this site for Excel questions:

Mrexcel[dot]com/forum

[6642633]

This very helpful...

Thanks

[ExcelIsFun]

You are welcome!

[drpronk]

Thanks from Holland. Solved a problem which bothered me for a week!

[ExcelIsFun]

EXCELlent!!!!

[joycemabugay]

thanks to excells fun...its very helpful, great videos to those who wants to learn advance excel. nice....thank you so much. i will watch and download these all.

[ExcelIsFun]

You are welcome! The videos cannot be downloaded, but the workbooks can. See this video title:

excelisfun Search For Excel Videos and Playlists & Download Workbooks

[ijustretired]

Thank you I have learnt so much from your teachings

[ExcelIsFun]

You are welcome!

[soulsaver04]

thanks, i know now if my formulas had a problem...

thank you again

[ExcelIsFun]

Dear soulsaver04,

No problem.

--excelisfun

[soulsaver04]

actaully i got an inconsistent comment above the the last row

[ExcelIsFun]

Dear soulsaver04,

Besides the "inconsistent comment" error warning, did the trick work?

The "inconsistent comment" error warning is like spell check, it does not always get it right.

--excelisfun