Solved - How To Get Results based on Duplicate Lookup Value in VLOOKUP - Excel

  Рет қаралды 98,458

Rahim Zulfiqar Ali

Rahim Zulfiqar Ali

Күн бұрын

Пікірлер: 51
@zed52a
@zed52a 2 жыл бұрын
I do not have any words, how much you have helped me to get out of the worst situation. May God bless you.
@shriefallam8866
@shriefallam8866 3 жыл бұрын
I swear to Allah if I wasn't in a hardship currently, I would have donated money for this particular video, Barakallahu feek.
@manu4teju
@manu4teju Жыл бұрын
My purpose was different but with this method i could able to solve my issue, Thanks a Lot
@riyasrahman3083
@riyasrahman3083 Жыл бұрын
Thank you very much. This video has really helped me a lot. Thank you again
@ExcelBasement
@ExcelBasement 8 ай бұрын
Welcome
@Mrgasman1978
@Mrgasman1978 Жыл бұрын
Great video!! Saved me so much time. Btw, that customer named Anus, i feel for him
@shubhamsabale2948
@shubhamsabale2948 3 жыл бұрын
Your video really helped me... Big thanks to you
@AnkitYadav-qh9vn
@AnkitYadav-qh9vn 4 жыл бұрын
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.
@dilshadahmed5918
@dilshadahmed5918 3 жыл бұрын
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.
@jerlaaad9341
@jerlaaad9341 11 ай бұрын
Thank you so much!
@travelwithtariq
@travelwithtariq 2 жыл бұрын
Thanks a lot for saving my time
@gunasekar7517
@gunasekar7517 2 жыл бұрын
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
@mohitverma2474
@mohitverma2474 6 ай бұрын
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?
@sourabhmaurya6225
@sourabhmaurya6225 7 ай бұрын
Thank you so much❤ it helps a lot
@payamehussain2052
@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 )
@kashif2day
@kashif2day Жыл бұрын
I have a list having same bar codes repeated 3,4 times...i want to get/pick which having highest cost/price
@muhammadadnan2207
@muhammadadnan2207 Жыл бұрын
i need your help to arrange a large amount of data with the repeating codes , and i don't know how to do it
@trileshnaik5540
@trileshnaik5540 5 ай бұрын
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
@informationunboxed4366
@informationunboxed4366 9 ай бұрын
Agar humey sirf name ke saamne alag alag reg no chahiye ho vlookup se, to kya karenge?
@muhammadahsansiddiqui9392
@muhammadahsansiddiqui9392 6 жыл бұрын
Thank You for making such a useful video
@harrisali9034
@harrisali9034 4 жыл бұрын
What I dont understand why you have created combo column. Its not doing anything
@edenewsa2086
@edenewsa2086 Жыл бұрын
Thank you soo much
@ExcelBasement
@ExcelBasement 8 ай бұрын
Welcome
@civilworks3591
@civilworks3591 4 жыл бұрын
could you interface the results(reg No) in the dropdown list? so that we can chose 1 only in 1 cell?
@sufiyantahir6978
@sufiyantahir6978 7 ай бұрын
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
@ExcelBasement 7 ай бұрын
If you are using Excel 365 version, You can apply FILTER function based on your scenario.
@satyasrinivas2087
@satyasrinivas2087 3 жыл бұрын
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.
@CCAFO
@CCAFO 3 жыл бұрын
This is great, thank you very much!
@michaelsmith1076
@michaelsmith1076 2 жыл бұрын
Can the countif function work the same way if the column had numbers instead of text?
@cyclingmc
@cyclingmc Жыл бұрын
Should work the same. Give it a try..
@NiftyBullseye
@NiftyBullseye 4 жыл бұрын
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..)
@noushadpatan8860
@noushadpatan8860 3 жыл бұрын
Hi can plz make vide o by using xlookup as same data
@sougatabiswas8384
@sougatabiswas8384 Жыл бұрын
THANK YOU!!
@ExcelBasement
@ExcelBasement Жыл бұрын
Welcome!
@maarten4132
@maarten4132 3 жыл бұрын
Thank you, huge time saver!
@rogermathew378
@rogermathew378 4 жыл бұрын
My countif gives me result as ..total numbers of items repeated
@rajendrabajpai3565
@rajendrabajpai3565 3 жыл бұрын
Good
@ExcelBasement
@ExcelBasement 3 жыл бұрын
Thanks
@syedhidayathquadri9028
@syedhidayathquadri9028 4 жыл бұрын
the formula you gave is not working out in my sheet, tried enough times....
@johnnysarma3503
@johnnysarma3503 3 жыл бұрын
same
@alekhyaaalu4183
@alekhyaaalu4183 3 жыл бұрын
Same..not working
@cyclingmc
@cyclingmc Жыл бұрын
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
@cyclingmc Жыл бұрын
Maybe add demo excel file so we can follow along…
@shrikantchaurasiya7388
@shrikantchaurasiya7388 3 жыл бұрын
Thank you so much sir
@ExcelBasement
@ExcelBasement 3 жыл бұрын
Most welcome
@alekhyaaalu4183
@alekhyaaalu4183 3 жыл бұрын
@@ExcelBasement unable to get the result..please upload that excel
@nicasmwandu4706
@nicasmwandu4706 3 жыл бұрын
noma sana
@nawazshaikh0019
@nawazshaikh0019 3 жыл бұрын
Bro u can provide file for exercise 🙄
Dates Showing as Numbers & Excel Displays Formula rather than Result
3:18
Rahim Zulfiqar Ali
Рет қаралды 48 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 93 МЛН
Ouch.. 🤕⚽️
00:25
Celine Dept
Рет қаралды 29 МЛН
When mom gets home, but you're in rollerblades.
00:40
Daniel LaBelle
Рет қаралды 100 МЛН
小蚂蚁会选到什么呢!#火影忍者 #佐助 #家庭
00:47
火影忍者一家
Рет қаралды 126 МЛН
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel
12:20
Vlookup the Same Value Multiple Times in Excel
7:16
Syed Shah Zahurullah Hussaini
Рет қаралды 9 М.
Vlookup with Duplicate Entries
6:23
Myexcelacademy
Рет қаралды 67 М.
Use VLOOKUP to Find the 2nd Match (or nth Match)
7:47
Doug H
Рет қаралды 215 М.
Excel VLookup Return Multiple Matches on Multiple Lookup Values
8:17
Excel DGET Function Solves 2 of Your VLOOKUP Problems
11:18
Leila Gharani
Рет қаралды 863 М.
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
10:20
Leila Gharani
Рет қаралды 107 М.
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 93 МЛН