Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation Data
I am using a validation data formula, initialy I have it set up to use only the range (A1:A24) and (B1:B24) now I want to expand the range to (B1:B30) (A1:A30)
Initial formula: =IF(ROW(A1:A24)-ROW(A1)+1COUNT(B1:B24),"",INDEX(A:A,SMALL(B1:B24, ROW(INDIRECT("1:"&ROWS(A1:A24)))))) When I go to the data validation window and modify the formula as follows: =IF(ROW(A1:A30)-ROW(A1)+1COUNT(B1:B30),"",INDEX(A:A,SMALL(B1:B30, ROW(INDIRECT("1:"&ROWS(A1:A30)))))) There is not changes the range still reads the initial formula and the new rows read as A48 , A49.... I would like to know what should I do to modify my data as the second formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |