I am struggling to create a formula that will track the first occurrence of a given name, but always in conjunction with a further cell value, and would really appreciate someone devising a formula-based solution that I have been unable to find.
Please see the attached spreadsheet. I have...
Apologies for not thanking you yet for your latest formula update, but I've been playing around with it in the interim and have noticed that it's not yet performing 100% accurately.
For the most part it's pretty darn good, but for some reason there seems to be exceptions slipping...
I was worried that ten lines might not be enough data to produce the required results, so the attached file is somewhat larger (but not nearly as big as the original one posted).
Thanks for your time!
Sorry to be a pain, but there appears to be an additional complication.
In my actual database, there are seven other columns between the player name (column A in the uploaded sample) and the first column for holding the team name (column B here). As a result, the last bit of your formula...
Thank you very much, Bosco. Much appreciated!
At the risk of sounding greedy though, is there a way to alter the returns so that they don't list the team played for in a player's every appearance, but rather just list of all the different teams represented in each player's range of appearances...
Please see the attached sample from a much larger Excel database that I am running.
I need to extract all of the teams that each player has appeared for (as compiled from the Appearances tab), and list them in columns B - G on the Summary tab.
I can determine the first occurrence easily...
Ended up having a rather busy weekend, to the extent that I didn't touch my laptop at all. I therefore have only now tried out your formula suggestion.
I'm very happy to announce that it (once again) worked perfectly for me. I wish I could hire you to create my entire spreadsheet for...
Thanks, but I think that'd wreak havoc across the rest of the spreadsheet.
Slightly disappointing, but not that serious - I'd rather have double reporting that I can manually edit than no reporting at all.
Appreciate your efforts very much.
Sorry, just one slight tweak still needed actually, please.
As the same name often appears twice for the same Column C event, the combined value of that person's Column D scores appears next to each instance of that person's name when I copy the formula down, such that each total is reported on...
That is all kinds of awesome, thank you 945cal!
I have added that as a helper column to my spreadsheet, and it works beautifully! I will now use it by referencing that helper column in the worksheet where I want the formula summary to be for reporting purposes.
Gotta love this forum!!