Hi again,
I am looking for a formula (I have looked and looked)
That will display the "added" repeated occurrences
This is what I want (Manually entered)
Heads or Tails-Heads-Tails-Evens
HEADS WON 2
HEADS WON 2
TAILS WON 1
HEADS WON 2
HEADS WON 2
TAILS WON 1
EVENS WON 1
TAILS WON 4
TAILS WON 4
TAILS WON 4
TAILS WON 4
HEADS WON 3
HEADS WON 3
HEADS WON 3
TAILS WON 3
TAILS WON 3
TAILS WON 3
HEADS WON 1
EVENS WON 1
Thanks again
David
perhaps with a helper columm,
F2 =IF(B2=B1,F1,A2)
G2= =B2&" "&COUNTIF(F:F,F2)
Although you have 2 draw number 228 at the bottom, I assume its 229
Regards
Dav
Last edited by davsth; 12-05-2016 at 07:24 AM.
C2=D2
=IF($B2="HEADS WON",IF($B2=$B1,C1,COUNTIF($B2:INDEX($B2:$B$20,IFERROR(MATCH(0,INDEX(($B2:$B$20=$B2)+0,0),0),MAX(INDEX(ROW($B$2:$B$20),0))-ROW($B2)+1)),$B2)),"")E2=IF($B2="TAILS WON",IF($B2=$B1,D1,COUNTIF($B2:INDEX($B2:$B$20,IFERROR(MATCH(0,INDEX(($B2:$B$20=$B2)+0,0),0),MAX(INDEX(ROW($B$2:$B$20),0))-ROW($B2)+1)),$B2)),"")Try this and copy towards down=IF($B2="EVENS WON",IF($B2=$B1,E1,COUNTIF($B2:INDEX($B2:$B$20,IFERROR(MATCH(0,INDEX(($B2:$B$20=$B2)+0,0),0),MAX(INDEX(ROW($B$2:$B$20),0))-ROW($B2)+1)),$B2)),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks