Filer question
I have 2 separate columns of data on the same sheet, A and H. (the data in both columns is a formula looking at data on another sheet)
I need to be able to put a filter on each column to remove blank cells ("") but without affecting the other column.
Please help.
That's not really possible.
My advice:
1) Offset the data in A and H so they don't have any overlapping rows.
2) Move them onto separate sheets (like, create a copy the sheet, then delete A etc from one and H etc from the other).
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks