Hi All,
I have table detailing hotel reservations records, with 3 columns for partial payments. So the same reservation record could have 1st payment in August and 2nd payment in September.
I use advanced filtering to make excel display records with payments charged in say, September only, but the records will display other partial payments (if any) charged in other months as well.
Is there a way for excel to display only records with payments from say, September, be it 1st or 2nd payment column, but not showing the other partial payment tagged to the same record that were charged in other months?
Many thanks.
Bookmarks