I have a daily entry of data and am working to build a weekly report for a certain time range.
Right now, I would like to set up a lookup or match function which extracts nonblank/nonzero values from a row of over 25 potential columns. The columns represent the output matrics for a given data entry and can vary for entry to entry.
Eventually I will set this up as a weekly report so that for every entry, only the nonblank values will show.
I have tried using index/match however my biggest issue is that I have not yet defined a range, as I must first lookup the run entry (using date and input code as criteria).
For reference -
In the data table:
Criteria 1 Date Range: Col. A
Criteria 2 Item Code: Col. D
Output Codes (Composition) Columns BU to CW
In the Weekly report:
Date Reference Cell: $A$4
Item Code Reference Cell: $A5 to how many runs in the week (5-8)
Composition Start Cell: G6
Right now, I would like to set up a lookup or match function which extracts nonblank/nonzero values from a row of over 25 potential columns. The columns represent the output matrics for a given data entry and can vary for entry to entry.
Eventually I will set this up as a weekly report so that for every entry, only the nonblank values will show.
I have tried using index/match however my biggest issue is that I have not yet defined a range, as I must first lookup the run entry (using date and input code as criteria).
For reference -
In the data table:
Criteria 1 Date Range: Col. A
Criteria 2 Item Code: Col. D
Output Codes (Composition) Columns BU to CW
In the Weekly report:
Date Reference Cell: $A$4
Item Code Reference Cell: $A5 to how many runs in the week (5-8)
Composition Start Cell: G6