Find just "last row number"

[Kishan]

Using Excel 2000<o></o>
<o></o>
Hi,<o></o>
<o></o>
I want a Formula or may be VBA that can locate the only the "last row number" <o></o>
<o></o>
In the column C, there are repeated values<o></o>
In the column E, there are unique values; I need to search the "last row number" of each value column E, and result value be placed in column F<o></o>
<o></o>
Note: cells are coloured shown just to show example clearer <o></o>
<o></o>
Result data example<o></o>

Book1
	A	B	C	D	E	F	G
1
2
3
4
5			Join Count Patt Vari		Unique Patt	Last Row Number
6			0|6|1		0|0|0
7			2|0|1		0|0|1	43
8			0|0|1		0|1|0
9			4|1|2		1|0|0
10			2|4|0		0|0|2
11			1|3|0		1|0|1
12			1|1|6		1|1|0	60
13			2|4|0		2|0|0
14			2|0|1		0|0|3
15			3|4|0		0|2|1
16			1|1|0		1|0|2
17			2|4|2		1|1|1
18			2|2|0		1|2|0
19			2|2|0		2|0|1	40
20			0|1|2		2|1|0
21			2|0|1		3|0|0
22			0|1|1		0|0|4
23			1|5|0		0|1|3
24			1|4|1		0|2|2
25			0|0|1		0|4|0
26			4|0|1		1|0|3
27			0|3|1		1|2|1
28			2|0|1		1|3|0	11
29			1|6|0		2|0|2
30			2|4|0		2|1|1
31			2|2|2		2|2|0	19
32			4|0|2		3|0|1
33			1|3|3		4|0|0
34			2|3|1		0|0|5
35			2|3|2		0|1|4
36			1|3|1		0|4|1
37			2|0|1		0|5|0	23
38			1|6|0		1|0|4
39			0|3|0		1|2|2
40			2|0|1		1|3|1	51
41			0|3|1		2|0|3
42			2|2|2		2|1|2
43			0|0|1		2|2|1
44			1|4|0		2|3|0
45			0|2|3		3|0|2
46			1|6|0		3|1|1
47			3|4|1		3|2|0
48			4|0|1		4|1|0
49			2|1|3		5|0|0
50			2|2|3		0|0|6
51			1|3|1		0|1|5
52			0|1|2		0|2|4
53			1|0|6		0|3|3
54			1|1|0		0|4|2
55			0|5|2		0|5|1
56			0|2|0		0|6|0
57			1|1|0		1|0|5
58			0|3|2		1|1|4
59			3|1|0		1|2|3
60			1|1|0		1|3|2
61			3|5|0		1|5|0
62			1|1|2		2|0|4
63
64
Sheet2

Thank you in advance<o></o>
<o></o>
Regards,
Kishan

 

[jtakw]

Hi,

Same concept as Rick's formula, slightly shorter:

=IFERROR(LOOKUP(2,1/(C$1:C$62=E7),ROW(C$1:C$62)),"")

 

[Rick Rothstein]

Hi,

Same concept as Rick's formula, slightly shorter:

=IFERROR(LOOKUP(2,1/(C$1:C$62=E7),ROW(C$1:C$62)),"")

I would have posted a formula using IFERROR except the OP is using XL2000 (see first line of Message #1 ), so he does not have that available to him.

 

[jtakw]

I would have posted a formula using IFERROR except the OP is using XL2000 (see first line of Message #1 ), so he does not have that available to him.

Sorry Rick, missed it, didn't see that part.