![scriptcase field wont show on link scriptcase field wont show on link](https://images.sftcdn.net/images/t_app-cover-l,f_auto/p/badd7272-a4d2-11e6-a628-00163ed833e7/1284462733/scriptcase-php-code-generator-screenshot.png)
Excel SUMIF and COUNTIF Formulas – What are they, how to use & examplesįirst off, I just now noticed that there is a not equal sign missing between the second C5:C17 and “Josh” (It must not render incorrectly).Excel VLOOKUP Formula – What is it, how to use it & examples.Excel SUMPRODUCT Formula – What is it, how to use it & examples.It also has some interesting (and challenging) home work for you. The file includes few examples on how to fetch 2nd, 3rd etc. Now, to lookup 2nd occurance of John, all we do is, simply write =VLOOKUP("John2".) and we are done.ĭownload Example File – Getting the 2nd matching item from a list using VLOOKUP formula Notice the $C$5:C5?, well the mix of absolute & relative references does the trick here and gets John1, John2… etc. (see the below data table).įor this we can use COUNTIF() Formula, like this: =C5&COUNTIF($C$5:C5,C5). We just add a helper column before the sales person name and fill it with sales-person’s name & occurrence. So there should be a better way to do this? Like this =MATCH("John", C5:C17, 0) + 1īut sorting is not an option all the time.
![scriptcase field wont show on link scriptcase field wont show on link](https://www.scriptcase.net/docs/en_us/v81/grid-applications/links/img/ligacaodecampo.jpg)
![scriptcase field wont show on link scriptcase field wont show on link](https://www.inquirer.com/resizer/50IodRnmfAfEb6JcGx8Q6Sew50I=/760x507/smart/filters:format(webp)/cloudfront-us-east-1.images.arcpublishing.com/pmn/AUW27XCRJBDXNOKDAXVHR2KOMU.jpg)
And we just have to find the first John’s position and add 1 to it to get to 2nd occurrence. That way all Johns would line up one beneath another. Or is it?!?Ī simple solution to this problem would be sorting our data on sales person’s name. If you have below data, and you want to find out how much sales John made 2nd time, then VLOOKUP formula becomes quite useless. So what would you do if you need 2nd (or 3rd etc.) matching item from a list?įor eg. We know that VLOOKUP formula is useful to fetch the first matching item from a list. This article is part of our VLOOKUP Week.