EXTRACT ALL DATA OF REPEATED LOOKUP VALUE (WITHOUT HELPER COLUMN) USING INDIRECT FUNCTION IN EXCEL

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 24

  • @taizoondean689
    @taizoondean689 3 роки тому +3

    Thanks sir your techniques are amazing 🙏👍

  • @khushisingh6468
    @khushisingh6468 3 роки тому +3

    Thanks sir you explained step by step, so it is very clear to me 👏👍

  • @abdulsalam935
    @abdulsalam935 2 місяці тому

    EXCELLENT

  • @sanjeebkumarmaharana9149
    @sanjeebkumarmaharana9149 6 місяців тому

    Sir thanku so much

  • @pankajbiswas4138
    @pankajbiswas4138 3 роки тому +2

    You keep your chnal and made more videos
    I wish you are mak a good teacher❤️

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому +3

    Loved it. Thanks sir

  • @mohammadilyas2240
    @mohammadilyas2240 2 роки тому

    Excellent زبردست

  • @asimali5820
    @asimali5820 2 роки тому

    Great

  • @creativemindblog3789
    @creativemindblog3789 2 роки тому +1

    Nice. Also Need multiple sheets and multiple repeat too. Thank you

  • @manoharmotilal6761
    @manoharmotilal6761 2 роки тому

    Sir you have explained stepby step to find the 2nd match through vlookup

  • @pravinghogare2105
    @pravinghogare2105 Рік тому +1

    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 ☺️

  • @skdaveskdave9798
    @skdaveskdave9798 7 місяців тому

    Similarly intimate about Repeat date how I use helper column Pls soon reply

  • @prashanttyagi1156
    @prashanttyagi1156 3 роки тому +2

    Sir
    Agar repeted result row mein chahiye to column ki jagah rows ka formula lagega.

  • @hiteshchourey9730
    @hiteshchourey9730 10 місяців тому

    Sirji, macro with pivot table ka video banaye

  • @muzammilalikhan3411
    @muzammilalikhan3411 Рік тому

    Please use good quality camera to make better vedio

  • @shyamallrounder
    @shyamallrounder 2 роки тому

    Yah jo formula number mai laye wo kaise laye... Or fir formula mai kaise aaye

  • @Srigurukupa
    @Srigurukupa 5 місяців тому

    i am having 3 names so how do u get all three mobile numbers with one name

  • @mohdazeem4193
    @mohdazeem4193 Рік тому

    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)

  • @crazy2us
    @crazy2us 2 роки тому

    SIR THIS FORMULA EXTRACT MAX 2 RESULT BUT HOW TO EXTRACT MORE THAN

  • @SumitKumar-it2zg
    @SumitKumar-it2zg 2 роки тому

    IN WITHOUT HELPER SHEET, NOT PICKING MORE THAN TWO DUPIICATE VALUE, PLEASE SHARE ONCE AGAIN

  • @ayazshahali2789
    @ayazshahali2789 4 місяці тому

    Are you not showing everything please