| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
Dear All.Please help
Help on Excel -- Data Validation -- Hide Previously Used Items in Dropdown I have an Excel file with two sheets (Room and Main) On Sheet Room (A1:A66) I have room numbers from 1 to 66 (F1:F66) I have formula =IF(COUNTIF(Main!$A$6:$A$66,A1)=1,"",ROW()) (G1:G66) I have formula =IF(ROW(A1)-ROW(A$1)+1COUNT(F$1:F$120),"",INDEX(A:A,SMALL(F$1 :F$120,1+ROW(A1)-ROW(A$1)))) On sheet Main on A6 I have a Name manager =RoomChk with a formula =OFFSET(Room!$G$1,0,0,COUNTA(Room!$G$1:$G$120)-COUNTBLANK(Room!$G$1:$G$120),1) The following message appears:- The Source currently evaluates to an error. Do you want to continue? Pls help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Threaded Mode
