Hi,
On a column we have mixture of 'Non blank" & "Blank" cells.
If I have a filter & click it, we do not get all the options on the column.
Instead it shows the content of first "Non blank" cell.
is there a possibility to see all the options under filter option ?
Thanks
Shadmani
When you apply the filter, select your entire data set and not just the 1st row. That way, the blanks also will be included and all your data too.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
post a screen shot showing what you mean
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi
I think, that this is because when you create the filter you did't highlight all the column but you did only the header..
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks