Hi,
Please find the attached file where in i have mentioned my requirement. Basically i want vlookup formula to find the second, third and so on result for the code no mentioned, This is sample file and the data is 4500+ rows long.
Thanks
Goodboy
Hi,
Please find the attached file where in i have mentioned my requirement. Basically i want vlookup formula to find the second, third and so on result for the code no mentioned, This is sample file and the data is 4500+ rows long.
Thanks
Goodboy
Hi
What year excel do you use now?
2003 or 2007 or 2010 or 2013 or 2016?
To help you by my post? it would be nice to click on to say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
excel 2003
Are you sure cos sample file with this xlsx mean from 2007 to 2016?
If you on 2003 it should be xls?
It won't be easy to get the result with 2003 unless you upgrade excel to 2010 or onward to 2013 or 2016 to get the result you need?
Sorry my mistake it is 2007 but u can provide the result I will check the same at my Office computer where it is excel 2010.
try this formula and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
If the data can be sorted (see attached) then try this
=IFERROR(INDEX($B$2:$B$24,SMALL(IF($A$2:$A$24=$G2,ROW($A$2:$A$24)-ROW($A$2)+1,""),COUNTIF($G$2:G2,G2))),"")
Enter with Ctrl+Shift+Enter
Or
=IFERROR(AGGREGATE(14,6,$B$2:$B$24/($A$2:$A$24=G2),COUNTIF($G$2:G2,G2)),"")
if you are using 2007+ version use below formula in h2 AND COPY TOWARDS DOWN
Please Login or Register to view this content.
Sorry due my working hour!
nflsales formula will work for 2007 onward? I would done similar to nflsales for 2007?
For 2010 onward can use AGGREGATE? But won't work on 2007?
H2copy downFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks