Hi everyone.
In the attached workbook in B2 "grafici" sheet there is a data validation define name = mese.
Is it possible to remove the empty cells from the list?
max
Hi everyone.
In the attached workbook in B2 "grafici" sheet there is a data validation define name = mese.
Is it possible to remove the empty cells from the list?
max
The cells are not empty, they have formulas in them.
I suppose you could find the last row in Column N and use that as the last row in column B
Please Login or Register to view this content.
Hi in web I found this formula
but does not remove empty cellsPlease Login or Register to view this content.
Davesexcel In the web I found
does it work, someone has better?Please Login or Register to view this content.
Yes, your formula works for me.
Can you clarify why you are asking if it works, when clearly it does?
To see if there are other formulas to get the same result
max
=offset(n2,,,24-countif(n2:n25,""),1)
or
=OFFSET(N2,,,COUNTA(N:N)-1,1)
Not prepared to help until you start marking your threads as SOLVED...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks