EXTRACT ALL DATA OF REPEATED LOOKUP VALUE (WITHOUT HELPER COLUMN) USING INDIRECT FUNCTION IN EXCEL
HTML-код
- Опубликовано: 9 июл 2021
- EXTRACT ALL DATA OF REPEATED LOOKUP VALUE (WITHOUT HELPER COLUMN) USING INDIRECT FUNCTION IN EXCEL
part-10
Download Practice File: drive.google.com/file/d/14Mi3...
Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World.
SUBSCRIBE TO MY CHANNEL 👉 ruclips.net/channel/UC8sTJeRL...
#vlookupindirectmatch
#indirectfunction
#misinterviewquestion
Doston aap video ko pura dekhiyega aur achchi lage to ise like kijiyega share kijiyega, agar aapka koi sawal hai to aap mujhe comment bhi kar sakte hain ,main aapke comment ka reply dene ki poori koshish karunga.
PLEASE SUPPORT 🙏 ME FRIENDS BY LIKE 👍 AND SHARE aur SUBSCRIBE KARNA NA BHOOLE.(❁´◡`❁)
Thank You so much.
---------------------------------------------------------------------------------
About this channel-
Doston is channel me aapko office me work karne se sambandhit poori jaankari milegi,doston office me kaam karne ke liye ms excel aur ms word bahut jaroori hota hai,students ko bhi ms office ki bahut jaroorat hoti hai,doston is channel me aapko ms excel aur ms word aur computer se judi saari knowledge ke videos free me dekhne ko regular milte rahenge,yadi aap regular saare videos ko dekhenge to aap computer me perfect ho jayenge,doston main aapko ms excel me basic se lekar advance saari jankaari is channel me doonga aur shortcut keys bhi batata chaloonga,doston ye channel aapko office work/data entry me perfect banata hai.Doston MIS REPORT ke liye bhi aapko is channel me saari jankaari mil jayegi.
Doston agar aapko mera channel pasand aata hai to jaroor subscribe kijiyega.
Thank you so much-------
----------------------------------------------------------
shivam education world,shivameducationworld,extract data of repeated value in excel,extract data of repeated lookup value,vlookup on duplicate value,extract data of repeated lookup value without helper column,how to find duplicate values in excel,how to extact data of repeated lookup values,find data of repeat values using indirect functio,vlookup on duplicate values without helper column,how to find duplicate values,how to find repeated value in excel,vlookup indirect
Thanks sir your techniques are amazing 🙏👍
Thanks sir you explained step by step, so it is very clear to me 👏👍
Sir thanku so much
Loved it. Thanks sir
You keep your chnal and made more videos
I wish you are mak a good teacher❤️
Excellent زبردست
Nice. Also Need multiple sheets and multiple repeat too. Thank you
Sir you have explained stepby step to find the 2nd match through vlookup
Great
First of all thank to you for publishing videos like this.
Your data exactly repeat, but what if data repeated unevenly.
I mean paityn repeat again on 6th row, Evalyn repeat on 7th row. That's why dynamic table range can get unique value for vlookup.
Is there any way to get data if paityn repeat unevenly?
Thanks in advanced ☺️
Sir
Agar repeted result row mein chahiye to column ki jagah rows ka formula lagega.
Similarly intimate about Repeat date how I use helper column Pls soon reply
Sirji, macro with pivot table ka video banaye
Sure👍
How to sum of repeat ID in a single column for Same Name only, without helper column.
For ex. Paityn - 125 (54+71)
Evalyn - 120 (61+59)
Yah jo formula number mai laye wo kaise laye... Or fir formula mai kaise aaye
i am having 3 names so how do u get all three mobile numbers with one name
Please use good quality camera to make better vedio
SIR THIS FORMULA EXTRACT MAX 2 RESULT BUT HOW TO EXTRACT MORE THAN
Kindly check this video- ruclips.net/video/79L6HsqUsDM/видео.html
IN WITHOUT HELPER SHEET, NOT PICKING MORE THAN TWO DUPIICATE VALUE, PLEASE SHARE ONCE AGAIN
Are you not showing everything please