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) |