Row Number

[How_Do_I]

Hello all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have my count in F3 which is counting “L” in the highlighted column (Column C)…
<o> </o>
What I need is the row number of the three “L”s
<o> </o>
How would I do that please?
<o> </o>
So my expected results are 6,7,11.

Excel Workbook
	A	B	C	D	E	F
1	Preston North End	W		W
2	Burnley	W		W		Count
3	Coventry City	W	W	WW		3
4	Scunthorpe United	W		W		6
5	Derby County	D		D		7
6	QPR	D	L	DL		11
7	Leicester City	W	L	WL
8	Bristol City	L	W	LW
9	Middlesbrough	W	W	WW
10	Portsmouth	L		L
11	Millwall	D	L	DL
12	Barnsley	W	D	WD
13	Reading	W	W	WW
14	Crystal Palace	W	W	WW
15	Cardiff City	L	W	LW
16	Doncaster Rovers	W	D	WD
Sheet1

 

[Jonmo1]

Perhaps

F4: =MATCH("L",$C$1:$C$16,0)
F5: =F4+MATCH("L",INDEX($C$1:$C$16,$F4+1):$C$16,0) - Fill Down.

 

[How_Do_I]

Thanks jonmo... I look for a solution, couldn't find one, posted my question and then found something...

I've put the solution in Column G as opposed to F...

G3 = L

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 39px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>G</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial Unicode MS; COLOR: #808080">6</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial Unicode MS; COLOR: #808080">7</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial Unicode MS; COLOR: #808080">11</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G4</TD><TD>{=SMALL(IF($C$1:$C$16=$G$3,ROW($C$1:$C$16)),ROW(1:1))}</TD></TR><TR><TD>G5</TD><TD>{=SMALL(IF($C$1:$C$16=$G$3,ROW($C$1:$C$16)),ROW(2:2))}</TD></TR><TR><TD>G6</TD><TD>{=SMALL(IF($C$1:$C$16=$G$3,ROW($C$1:$C$16)),ROW(3:3))}</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4