Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using the following to create a dynamic list:
=OFFSET(LookupLists!$A$2,0,0,COUNTA(LookupLists!$A :$A),-1) The problem is, it always adds the blank cell at the bottom of the list that is also included in the combobox. How do I modify this so it does not include the blank cell at the bottom? (I have a header above the list in A1 that I do not want included in the list - it is currently not included.) Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Nevermind, got it!
=OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$ A:$A)-1),-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |