Good morning everyone,
I have a spreadsheet to organise promotional activity for our customers, organised by month. I have divider rows to separate each month to make the spreadsheet easier to read, but as you can probably guess, this doesn't work too well with filtering.
Is there a way to force excel to ignore these rows? See below image example, row 408.
http://www.excelforum.com/attachment...1&d=1455525263
Thanks,
Dom
You get better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Please see attached excel file showing before/after.
http://www.excelforum.com/attachment...1&d=1455527548
Thanks,
Dom
Select 76 and blanc in your filter.
See the attached file for the result.
and with a helpcolumn.
Then you also have to filter on the helpcolumn with the criteria show.
=IF(SUMPRODUCT(($J$4:$J$1000=$J114)*($K$4:$K$1000=$L$1))=0,"hide","show")
See the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks