Solved - How To Get Results based on Duplicate Lookup Value in VLOOKUP - Excel
Solved - How To Get Results based on Duplicate Lookup Value in VLOOKUP - Excel Basement
Жүктеу.....
Пікірлер: 51
@zed52a Жыл бұрын
I do not have any words, how much you have helped me to get out of the worst situation. May God bless you.
@shriefallam88663 жыл бұрын
I swear to Allah if I wasn't in a hardship currently, I would have donated money for this particular video, Barakallahu feek.
@maarten41323 жыл бұрын
Thank you, huge time saver!
@shubhamsabale29483 жыл бұрын
Your video really helped me... Big thanks to you
@manu4teju Жыл бұрын
My purpose was different but with this method i could able to solve my issue, Thanks a Lot
@CCAFO2 жыл бұрын
This is great, thank you very much!
@travelwithtariq2 жыл бұрын
Thanks a lot for saving my time
@jerlaaad93417 ай бұрын
Thank you so much!
@AnkitYadav-qh9vn4 жыл бұрын
THANK YOU SO MUCH SIR FOR THIS VIDEO .. I DON'T NO Y SUCH A HANDFUL OF LIKES FOR SUCH A GREAT CONTENT .. I GUESS ALL MUST BE BUSY MAKING TIKTOK.
@civilworks35914 жыл бұрын
could you interface the results(reg No) in the dropdown list? so that we can chose 1 only in 1 cell?
@muhammadahsansiddiqui93925 жыл бұрын
Thank You for making such a useful video
@harrisali9034
4 жыл бұрын
What I dont understand why you have created combo column. Its not doing anything
@sourabhmaurya62253 ай бұрын
Thank you so much❤ it helps a lot
@mohitverma24743 ай бұрын
When I do the same in Excel. The sequence of duplicate numbers are shooting in reverse order. Means the last duplicate value number show first and the first in Excel sheet shows the last number. Why is this so?
@dilshadahmed59182 жыл бұрын
Thanks for this video. I need more helps here. For my loading program with multiple container sheet. I have article like ( white twin fitted sheet) 1000 cartons. This 1000 cartons are in four container like 250. Each . now problem is that how can put 900 in hand cartons with formula in four to share cargo status.
@riyasrahman30839 ай бұрын
Thank you very much. This video has really helped me a lot. Thank you again
@ExcelBasement
5 ай бұрын
Welcome
@Mrgasman197810 ай бұрын
Great video!! Saved me so much time. Btw, that customer named Anus, i feel for him
@edenewsa20868 ай бұрын
Thank you soo much
@ExcelBasement
5 ай бұрын
Welcome
@nicasmwandu47063 жыл бұрын
noma sana
@trileshnaik55402 ай бұрын
I have 2 sheets one is IMEI activeted and other one is mixed So, How to check which not activated. Many numbers I have. Please guide me
@sougatabiswas8384 Жыл бұрын
THANK YOU!!
@ExcelBasement
Жыл бұрын
Welcome!
@gunasekar7517 Жыл бұрын
Hi, My doub is how you r get the repeating data latest value in next sheet while using vlookup Eg: I have the data in sheet no1 I need to get data from sheet no1 to Sheet no2 based on some X number In sheet 1 having double data My requirement was in duplicate value last data shown come in sheet no2 during Vlook up using Pls suggest the idea or if any videos
@muhammadadnan220711 ай бұрын
i need your help to arrange a large amount of data with the repeating codes , and i don't know how to do it
@noushadpatan88603 жыл бұрын
Hi can plz make vide o by using xlookup as same data
@informationunboxed43665 ай бұрын
Agar humey sirf name ke saamne alag alag reg no chahiye ho vlookup se, to kya karenge?
@kashif2day Жыл бұрын
I have a list having same bar codes repeated 3,4 times...i want to get/pick which having highest cost/price
@NiftyBullseye3 жыл бұрын
9:50 how to show 8579-5 once only...i dont want it get repeat....(dont use vlookup as i need 2nd value of same..)
@shrikantchaurasiya73883 жыл бұрын
Thank you so much sir
@ExcelBasement
3 жыл бұрын
Most welcome
@alekhyaaalu4183
3 жыл бұрын
@@ExcelBasement unable to get the result..please upload that excel
@michaelsmith10762 жыл бұрын
Can the countif function work the same way if the column had numbers instead of text?
@cyclingmc
10 ай бұрын
Should work the same. Give it a try..
@satyasrinivas20873 жыл бұрын
If employees got 2 increments in a year, if we want to copY this data with highest increment results into another sheet, how can we do that.
@payamehussain2052 Жыл бұрын
WHAT if i have 3 dates simillar and i want result of last at row suppose 22,march=1000, +22march=500 +22march=100....( i want to show the last 22march=100 in my results )
@sufiyantahir69783 ай бұрын
By using employee id how to get multiple rows from other report including duplicates-some emp id has two records in another report and we we want both how we can fix this
@ExcelBasement
3 ай бұрын
If you are using Excel 365 version, You can apply FILTER function based on your scenario.
@rajendrabajpai35653 жыл бұрын
Good
@ExcelBasement
3 жыл бұрын
Thanks
@rogermathew3783 жыл бұрын
My countif gives me result as ..total numbers of items repeated
@nawazshaikh00193 жыл бұрын
Bro u can provide file for exercise 🙄
@syedhidayathquadri90283 жыл бұрын
the formula you gave is not working out in my sheet, tried enough times....
@johnnysarma3503
3 жыл бұрын
same
@alekhyaaalu4183
3 жыл бұрын
Same..not working
@cyclingmc
10 ай бұрын
Same not working. I do not have duplicates in my list. I added a few and still did not work. Copied formula exactly and all steps.. I did not do the Data Validation which should not matter..
Пікірлер: 51
I do not have any words, how much you have helped me to get out of the worst situation. May God bless you.
I swear to Allah if I wasn't in a hardship currently, I would have donated money for this particular video, Barakallahu feek.
Thank you, huge time saver!
Your video really helped me... Big thanks to you
My purpose was different but with this method i could able to solve my issue, Thanks a Lot
This is great, thank you very much!
Thanks a lot for saving my time
Thank you so much!
THANK YOU SO MUCH SIR FOR THIS VIDEO .. I DON'T NO Y SUCH A HANDFUL OF LIKES FOR SUCH A GREAT CONTENT .. I GUESS ALL MUST BE BUSY MAKING TIKTOK.
could you interface the results(reg No) in the dropdown list? so that we can chose 1 only in 1 cell?
Thank You for making such a useful video
@harrisali9034
4 жыл бұрын
What I dont understand why you have created combo column. Its not doing anything
Thank you so much❤ it helps a lot
When I do the same in Excel. The sequence of duplicate numbers are shooting in reverse order. Means the last duplicate value number show first and the first in Excel sheet shows the last number. Why is this so?
Thanks for this video. I need more helps here. For my loading program with multiple container sheet. I have article like ( white twin fitted sheet) 1000 cartons. This 1000 cartons are in four container like 250. Each . now problem is that how can put 900 in hand cartons with formula in four to share cargo status.
Thank you very much. This video has really helped me a lot. Thank you again
@ExcelBasement
5 ай бұрын
Welcome
Great video!! Saved me so much time. Btw, that customer named Anus, i feel for him
Thank you soo much
@ExcelBasement
5 ай бұрын
Welcome
noma sana
I have 2 sheets one is IMEI activeted and other one is mixed So, How to check which not activated. Many numbers I have. Please guide me
THANK YOU!!
@ExcelBasement
Жыл бұрын
Welcome!
Hi, My doub is how you r get the repeating data latest value in next sheet while using vlookup Eg: I have the data in sheet no1 I need to get data from sheet no1 to Sheet no2 based on some X number In sheet 1 having double data My requirement was in duplicate value last data shown come in sheet no2 during Vlook up using Pls suggest the idea or if any videos
i need your help to arrange a large amount of data with the repeating codes , and i don't know how to do it
Hi can plz make vide o by using xlookup as same data
Agar humey sirf name ke saamne alag alag reg no chahiye ho vlookup se, to kya karenge?
I have a list having same bar codes repeated 3,4 times...i want to get/pick which having highest cost/price
9:50 how to show 8579-5 once only...i dont want it get repeat....(dont use vlookup as i need 2nd value of same..)
Thank you so much sir
@ExcelBasement
3 жыл бұрын
Most welcome
@alekhyaaalu4183
3 жыл бұрын
@@ExcelBasement unable to get the result..please upload that excel
Can the countif function work the same way if the column had numbers instead of text?
@cyclingmc
10 ай бұрын
Should work the same. Give it a try..
If employees got 2 increments in a year, if we want to copY this data with highest increment results into another sheet, how can we do that.
WHAT if i have 3 dates simillar and i want result of last at row suppose 22,march=1000, +22march=500 +22march=100....( i want to show the last 22march=100 in my results )
By using employee id how to get multiple rows from other report including duplicates-some emp id has two records in another report and we we want both how we can fix this
@ExcelBasement
3 ай бұрын
If you are using Excel 365 version, You can apply FILTER function based on your scenario.
Good
@ExcelBasement
3 жыл бұрын
Thanks
My countif gives me result as ..total numbers of items repeated
Bro u can provide file for exercise 🙄
the formula you gave is not working out in my sheet, tried enough times....
@johnnysarma3503
3 жыл бұрын
same
@alekhyaaalu4183
3 жыл бұрын
Same..not working
@cyclingmc
10 ай бұрын
Same not working. I do not have duplicates in my list. I added a few and still did not work. Copied formula exactly and all steps.. I did not do the Data Validation which should not matter..
@cyclingmc
10 ай бұрын
Maybe add demo excel file so we can follow along…