In the example Kumar Raje Gowda should be 1.
Another one
=COUNT(INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)):INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+MIN(IFERROR(MATCH("*",INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+1):$A$595,0),
Kris
--
FORUM RULES (934+ members already BANNED for violat
Hi Rajan,
Please find a list of data and i want numbers counts under names. And
delete dates in the coloum.
A1 cell (containing name, date, and numbers)
Jack
9/20/2011
120
121
122
123
james
9/21/2011
124
125
126
127
jack
9/22/2011
128
129
130
I need the formula of deleting the dates and count
