Тёмный
No video :(

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

Rahim Zulfiqar Ali
Подписаться 48 тыс.
Просмотров 97 тыс.
50% 1

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

Опубликовано:

 

12 окт 2018

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 51   
@zed52a
@zed52a Год назад
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 10 месяцев назад
Thank you very much. This video has really helped me a lot. Thank you again
@ExcelBasement
@ExcelBasement 6 месяцев назад
Welcome
@shubhamsabale2948
@shubhamsabale2948 3 года назад
Your video really helped me... Big thanks to you
@travelwithtariq
@travelwithtariq 2 года назад
Thanks a lot for saving my time
@edenewsa2086
@edenewsa2086 9 месяцев назад
Thank you soo much
@ExcelBasement
@ExcelBasement 6 месяцев назад
Welcome
@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.
@mohitverma2474
@mohitverma2474 4 месяца назад
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 4 месяца назад
Thank you so much❤ it helps a lot
@Mrgasman1978
@Mrgasman1978 11 месяцев назад
Great video!! Saved me so much time. Btw, that customer named Anus, i feel for him
@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.
@jerlaaad9341
@jerlaaad9341 8 месяцев назад
Thank you so much!
@CCAFO
@CCAFO 3 года назад
This is great, thank you very much!
@muhammadahsansiddiqui9392
@muhammadahsansiddiqui9392 5 лет назад
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
@trileshnaik5540
@trileshnaik5540 3 месяца назад
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
@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
@kashif2day
@kashif2day Год назад
I have a list having same bar codes repeated 3,4 times...i want to get/pick which having highest cost/price
@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
@sufiyantahir6978
@sufiyantahir6978 4 месяца назад
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 4 месяца назад
If you are using Excel 365 version, You can apply FILTER function based on your scenario.
@maarten4132
@maarten4132 3 года назад
Thank you, huge time saver!
@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.
@sougatabiswas8384
@sougatabiswas8384 Год назад
THANK YOU!!
@ExcelBasement
@ExcelBasement Год назад
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?
@NiftyBullseye
@NiftyBullseye 3 года назад
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..)
@informationunboxed4366
@informationunboxed4366 6 месяцев назад
Agar humey sirf name ke saamne alag alag reg no chahiye ho vlookup se, to kya karenge?
@nicasmwandu4706
@nicasmwandu4706 3 года назад
noma sana
@michaelsmith1076
@michaelsmith1076 2 года назад
Can the countif function work the same way if the column had numbers instead of text?
@cyclingmc
@cyclingmc 11 месяцев назад
Should work the same. Give it a try..
@noushadpatan8860
@noushadpatan8860 3 года назад
Hi can plz make vide o by using xlookup as same data
@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 )
@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
@syedhidayathquadri9028
@syedhidayathquadri9028 3 года назад
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 11 месяцев назад
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 11 месяцев назад
Maybe add demo excel file so we can follow along…
@rajendrabajpai3565
@rajendrabajpai3565 3 года назад
Good
@ExcelBasement
@ExcelBasement 3 года назад
Thanks
@rogermathew378
@rogermathew378 3 года назад
My countif gives me result as ..total numbers of items repeated
@nawazshaikh0019
@nawazshaikh0019 3 года назад
Bro u can provide file for exercise 🙄
Далее
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Вся Правда Про Хазяевов !
41:02
Просмотров 1,8 млн
아이스크림으로 진짜 친구 구별하는법
00:17
Sevinch Ismoilova - Xayollarim 18-Avgust 19:00 Premera
00:19
Excel VLOOKUP With Multiple Workbooks
12:14
Просмотров 3,4 млн
Find Duplicate Entries in Excel
3:58
Просмотров 1,1 млн
Use VLOOKUP to Find the 2nd Match (or nth Match)
7:47
Просмотров 214 тыс.
How To Use Index Match As An Alternative To Vlookup
19:28
VLOOKUP All Matches with this Crazy Simple Trick
4:02
Просмотров 124 тыс.
Compare Two Lists Using the VLOOKUP Formula
12:49
Просмотров 2,9 млн
Vlookup with Duplicate Entries
6:23
Просмотров 62 тыс.
How to Use VLOOKUP in Excel (free file included)
15:15
Просмотров 183 тыс.
Вся Правда Про Хазяевов !
41:02
Просмотров 1,8 млн