Комментарии:
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
Ответить