Hello,
I am trying to use a formula for creating a dynamic range where there is match functions to three separate values to determine the row and end of the column for the dynamic range but I cannot seem to get the formula correct, if anyone could assist I would appreciate it greatly...
what I have is similar to as shown below
CX CY CZ DA DB DC DD
XTSR52 726 Imperial Custom 3.50 5.00
XTSR52 826 Imperial Custom 3.50 5.00
XTSR52 996 Imperial Custom 4.375 5.00 7.00
XTSR71 726 Metric Custom 100 140 180
XTSR71 826 Metric Custom 140 180 250
XTSR71 996 Metric Custom 100 180 250
Is there any way to use a combination of index and match to create a dynamic range of the values from columns DA thru DD skipping the blank cells where the row selected matches column CX and CY and CZ?
Respectfully,
Charles S
I am trying to use a formula for creating a dynamic range where there is match functions to three separate values to determine the row and end of the column for the dynamic range but I cannot seem to get the formula correct, if anyone could assist I would appreciate it greatly...
what I have is similar to as shown below
CX CY CZ DA DB DC DD
XTSR52 726 Imperial Custom 3.50 5.00
XTSR52 826 Imperial Custom 3.50 5.00
XTSR52 996 Imperial Custom 4.375 5.00 7.00
XTSR71 726 Metric Custom 100 140 180
XTSR71 826 Metric Custom 140 180 250
XTSR71 996 Metric Custom 100 180 250
Is there any way to use a combination of index and match to create a dynamic range of the values from columns DA thru DD skipping the blank cells where the row selected matches column CX and CY and CZ?
Respectfully,
Charles S