Hi,
Please see attached workbook.
I have a table of data on Sheet '2017' - Columns I - AC
I need to display this same data on another sheet: '2017 Sorted by Start Date' but sorted by data in the Start Date column.
And I need it to only include row entries where the Status is either: 'Confirmed', 'Invoiced' or 'Paid'.
I can't think of a way to do this.
Thanks in advance for any help.
This proposed solution employs two helper columns, which may be hidden for aesthetic purposes, on the '2017' sheet.
The first helper column (AD) is populated by the formula:Formula:
Please Login or Register to view this content.
The second helper column (AE) is populated by the formula:Formula:Please Login or Register to view this content.
The table on the '2017 Sorted by Start Date' sheet is populated by the formula:Formula:Please Login or Register to view this content.
A conditional formatting rule has been applied to that table to hide zeros.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
All are ARRAY formulas, to be confirmed with Ctrl+Shift+Enter keys.
Helper cells AE2:AE4 are used.
IN K3, then drag down
IN I3, then drag across all yellow cells.
Please Login or Register to view this content.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks