counting 2 lookup values as per dupicates

Key Takeaways

hello friends here your friend group and now i'm going to teach you the solution for the quote because everyone is calling me and asking for the submission of this for that reason actually i'd like to start to from after two days but i'm not having time to solve it now here is the solution which i'm going to show you how to do this one two things i will explain you the two things the first one and the second one and the for the and along with this another query i'm going to ask you if you have any doubts please let me know in the comments and in my group now what i said you have to get not the first one here if you use the vlookup it will pick up the first occurrence of the value but i don't want like this okay i don't want like this i don't want like this name one a and name one b the b should come here like this yeah a e f b okay the second one i need not the first one okay the second b i need not the first one b you're the second name to f i need not the first one like this okay so here i will explain the solution for this two solutions and one query so let's start okay now first of all what you will do here let's find it out how many are there first of all how many name ones are there in the name string right so what i'll do here i'll do this one i'm not freezing anywhere equal to just because how many are there and increasing the ring because when i drag this formula it could not move anyways with a row or a column for that reason i've reached both things half nine so wherever it finds the name one in a range it will show us the true and remaining or all our faults so we are interested in truth no fault but that is not one okay here i'll show you the method what i use if article text this one if anything is true comma then row but i need one two three four five see i need one two three four five six seven eight like this so what i'll do is now it will start from three minus three means zero it will start from zero to nine f9 sorry zero to seven okay so i don't need that i need here if it is true pick up the corresponding number that is one two three one two three four four false so it will not pick up this one because only the true one can in previous video i used to use this one but it will not work if you want you can take it extraordinary okay now i will continue shift enter to show you the better four one two three four two pick up d but i need b not d two six one two three four five six i'll need this one not this one e and define it not f and three three see the difference which i am going to show you now j dollar now see the difference so that which one you have to use i need second occurrence here third is it i don't want third value i i need the value which is second document so i'll use this one this formula is used in a cave okay and they can use instead of rules i will use okay f4 first one is yes second one is b name two first one okay still now you understood if you have any dot ask me the group or in the comment box here what i said i could get like this right so see so what i'll use is okay what i'll do here here f2 instead of one is but when i drag this formula it should come like this see what i'll do here one two three everywhere i'll use the rules function f dollar eight it's colon this formula the word will repeat like this but i don't need like this whenever it completes the word it should show us the blank whenever it completes the word it shows the blank so what i'll do is is this f4 and then go to block whenever it passes the length of four it will show up the it see when i drag this formula to show the branch only all right when i enter any word like smaller words [Applause] okay i hope you understood now coming to the question which i'm going to ask you is this one find the employee name by using vlookup all with date adding these two february one double knight to here in the data violation you can change it you can change it like this but the name should come here may 1985 may 1985 yes the name should come in three over here and i said if i change to february 99 is not dead 1975 so this one should come name one should come here okay and uh thank you guys thanks for your support if you have any doubts please let me know in the comment box signing off regina count excel group you