Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic number of ROWS
I need to search a sheet with 79 ROWS but this can vary.
I use do the search from another sheet. I am looking for an exact match of a value in a particular Column C so I use MATCH(D24,C2:C79,0) This works ok and I take care of errors with ISNA. My question is how can I allow for the fact that the number of rows may be different without having to manually edit the formula. |
#2
|
|||
|
|||
Use can create a dynamic range using OFFSET:
=MATCH(D24,OFFSET(C2,,,COUNTA(C2:C65536)),0) HTH Jason Atlanta, GA -----Original Message----- I need to search a sheet with 79 ROWS but this can vary. I use do the search from another sheet. I am looking for an exact match of a value in a particular Column C so I use MATCH(D24,C2:C79,0) This works ok and I take care of errors with ISNA. My question is how can I allow for the fact that the number of rows may be different without having to manually edit the formula. . |
#3
|
|||
|
|||
This works fine, Jason,
Thank You -----Original Message----- Use can create a dynamic range using OFFSET: =MATCH(D24,OFFSET(C2,,,COUNTA(C2:C65536)),0) HTH Jason Atlanta, GA -----Original Message----- I need to search a sheet with 79 ROWS but this can vary. I use do the search from another sheet. I am looking for an exact match of a value in a particular Column C so I use MATCH(D24,C2:C79,0) This works ok and I take care of errors with ISNA. My question is how can I allow for the fact that the number of rows may be different without having to manually edit the formula. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a large number of rows, but not all | New Users to Excel | |||
sorting rows wich can vary in number | Excel Discussion (Misc queries) | |||
increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |