Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    get a row number (Excel 2003 SP3)

    I'm looking for a way to get the row number location for a text string that is located within a column range. The column range also includes numbers, and blank cells. I don't think there are any duplicate text entries in the range.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: get a row number (Excel 2003 SP3)

    Are you searching for a specific string? If so, you can use the MATCH function. For example, if you're looking for "Search String" in column C, the following formula will return the row number:

    =MATCH("Search String",C:C,0)

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: get a row number (Excel 2003 SP3)

    Hans,

    It did the trick.

    Thanks once again!

    BTW, I didn't know that you could refer to a column as "C:C"... I learned two things!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: get a row number (Excel 2003 SP3)

    Similarly, you can refer to an entire row as (for example) 37:37.

    It's also possible to refer to multiple columns: C:E and to multiple rows: 13:18.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: get a row number (Excel 2003 SP3)

    That's pretty cool!

    Thanks again, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •