Hi,
Could you please let me know how I could display the row number that meet two conditions? Please let me know. Thanks.
Hi,
Could you please let me know how I could display the row number that meet two conditions? Please let me know. Thanks.
=MATCH(value1&value2,$A$1:$A$100&$B$1:$B$100,0)
which is an array formula, so commit with Ctrl-Shift-Enter.
It will return an index into the array, so if it does not start at row 1,
you need to adjust it.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"owl527" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> Could you please let me know how I could display the row number that
> meet two conditions? Please let me know. Thanks.
>
>
> --
> owl527
> ------------------------------------------------------------------------
> owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
> View this thread: http://www.excelforum.com/showthread...hreadid=501599
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks