Thread
:
Row position of specified column and value
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
engineer
external usenet poster
Posts: 13
Row position of specified column and value
The Match function requires you to specify a range. I am only wanting to
specify the column number.
"Don Guillett" wrote:
Look in the help index for MATCH
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"engineer" wrote in message
...
I would like to know the row position of a specified column and value in a
table. If multiple occurences of the specified value occur in a
particular
column, I want the bottom most row position returned. For example, in the
folowing table, the function would specify column 2 (or B), value of 6,
and
return 3 since the bottom most 6 in column 2 is row 3.
A B C
1 5 8
2 6 9
3 6 10
4 7 11
.
Reply With Quote
engineer
View Public Profile
Find all posts by engineer