Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows. Alternatively, is it possible to do a mailmerge via word…
Hi, I am looking for a way to track attendance to multiple events for about 500 people. The same 500 people would attend some or all of the events. Right now, I have a sheet setup with the rows showing the 500 participants and the columns indicate the event. I use symbols to track their attendance (attended, RSVPed but no…
I am trying to setup conditional formatting for a cell if it does NOT contain certain text. There is an option for contains, but not the other way around. Ideas for a solution or go around? Thanks!
