| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible or impossible to auto adjust range in a formula?
I have small ranges separated by blank rows, and have unique identifiers for
each range. Is it possible to have a range adjust on the criteria of blank rows separating data or on the unique identifier cell? May be impossible but how would I know if I dont know better. Thanks for you help. Below is a formula for an example, I need to range $N$287:$N$297 and $I$287:$I$297 to adjust. Regards, Vadda =IF(COUNTIF($N$287:$N$297,N287)<2,"",$I$287:$I$297 ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get columns in Excell to auto-adjust | Excel Worksheet Functions | |||
| Auto adjust dates in a chart | Charts and Charting in Excel | |||
| Auto Adjust Scale | Charts and Charting in Excel | |||
| auto adjust columns in a pivot | Excel Worksheet Functions | |||
| cell to auto adjust to fit text in excel 02 | Excel Discussion (Misc queries) | |||
Linear Mode
