Column "B" contains a list of names of race winners, column "D" contains the finish, column "Q" breaks out the winners and column "R" should list any name that is a repeat winner. With the following formula I can get the next instance of a former winner. I want to be able to list all races won after the first name, as shown in column "S".
The attached file should make it much clearer.
Please Login or Register to view this content.
Jim O
Last edited by JO505; 06-07-2011 at 05:48 PM.
Hi Jim O,
Put this in R2 and pull down.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try this
In R2 dragged down
=IF(SUMPRODUCT(--($B1:B$2=B2),--($D1:D$2>0)),"FW","")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ChemistB and MarvinP,
Thank you both very much. They both work very well for my needs. Is their an advantage of one over the other or is it just personal preference?
Jim O
Hi,
Pick the one that makes more sense to you. ChemistB is smarter than me.
MarvinP,
I will go with your solution because ChemistB's formula uses column "D", the finish position, and while I did not include it in my example there will be numbers in all cells and that plays havoc with the results. I left them out in my example to reduce the clutter.
Again Thank you both for your time.
Jim O
Ha! Good one MarvinChemistB is smarter than me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks