Quote:
Originally Posted by OCM
1. Any other codes AFTER the H0004 code is not allowed. Yes, if you can tweak it to show within 7 days after the H0004 dates
|
That's what it does now. I was offering to add 7 days
before H0004.
Quote:
Originally Posted by OCM
2. Can you please explain what you used as a solution for this problem? I would like to use the same method for future projects.
|
It uses
Power Query; go to the
Data tab of the ribbon, then in the
Queries & Connections section click on
Queries & Connections and a pane should show up, not surprisingly with the header '
Queries & Connections'. In the
Queries section you should see two queries, one called
Table1 which is the result table on the sheet, and another called
fnMiniTbl. The
Table1 query calls
fnMiniTbl. If you right-click
Table1 in the new pane you'll get the option to
Edit, which will let you step through what it does.
refs:
Power Query (Get & Transform) & M code
Microsoft Power Query for Excel Help - Excel