How To Get Unique Values From Two Columns In Excel || Excel Tips & Tricks || dptutorials

Excellent!!!! I need to do this for about 30 columns

Bhak

If the data you are extracting is on a different sheet, does the "2" that you added as the criteria range for the lookup value change?

Thanks you ❤️❤️

Ugly formula. I would just rather copy past all the values into one column and then do a unique function on that.

You have made a fan out of me. It was in issue that was unresolved for me for many many years.
Allah SubHanaho Ta'ala aapko emaan ki naimat aur duniya aur aakhirat ki tamam bhalaiyan naseeb farmaen. Allahumma Ameen

WASTE OF TIME!

I am unable to do logocell

please can you explain what is logocell

VERY HELPFUL THANKYOU

It was returning zero after reading comments i came to know that the range doesn't work with blanks... Is that a way to make it work with blanks so i can giv a bigger range so it is easy to add items later on..

Why we divide it by 1

How to extract a list of only values common between two columns? For example, if Column A consist of values 1,2,3 and Column B consist of values 2,3,4. I want the resulting list to be 2,3.

It didn't work

HOW DO I EXTRACT UNIQUE VALUES IN MULTIPLE COLUMNS IN VBA PROGRAM

I am getting one single value in all cells.. can you please tell me a solution..?

How do I get unique value in a list from more than 2 column...please advise sir...

Thank you sir.
How can I do for multi column??

Superb

I always get a pop up about using the apostrophe as soon as I enter Ctrl+Shift+Enter. Somehow I am doing something wrong.

What if rows are 10 lakh....how to select

I do this:

List 1 is in A1:A500
List 2 is in B1:B500

If it works, move List 2 to A1001:A1500. Then in C1 =UNIQUE(A:A) will do the job.

If it doesn't work to do that I can have =UNIQUE(A:A) in something like AA1 and =UNIQUE(B:B) in something like AA1001, and =UNIQUE(AA:AA) in C1 will do the job too.

No dragging down with this method. Also easy to add a SORT and/or FILTER too.

how do i extract unique values in from all multiple(three or more) columns in excel?

From Ctrl Shift Enter in the second time
I didn't get unique list from the required column
So at last my entire table got messed up

Thank you for the tips. Help me alot

I need HELP! Why do I ge a zero on the first cell of my unique list???

Sir sir can i get ur number i hav a quiry plzz ।।।।। If possible cantect me 8873783661

binod

What is the formula for this bro..?
Sheet3.dropdown=sheet 1.columA + sheet2.columnA

Can we get the same details from 5 column as well

Anyone can explain the algorithm behind it.

Thanks.. only issue i still have is that it is picking items from bottom and is it possible to lookup the values from top?

Thanks for the great video first.


How about the source columns are not adjacent to each other?
Like this


colA...colB...colC
va1... xyz...vc1
va1...xyz...vc2
va2...xyz...vc3
va2...xyz...vc3



where the 2 source columns are 'colA' and 'colC'



and the desired result to be:


unique_list
va1
va2
vc1
vc2
vc3


Many thanks.

Thank you Sir

Thank you sir hi aap great ho