Reports

Is there a way to use this formula but drag the data validation down so it stays the same all the way down a column? The formula I am using looks like this: =OFFSET(Products!$I:$I,XMATCH(B62,Products!$A:$A)-1,,COUNTIF(Products!$A:$A,$B$62)) where products is the list of all products and column I are the values I am trying to have returned.

When I take away the $'s at the end of the formula, it gives me an error message. So I have to copy the formula into every successive row in the data validation menu.

Reasons:

Blacklisted phrase (1): I am trying to
Blacklisted phrase (1): Is there a way
Long answer (-0.5):
No code block (0.5):
Contains question mark (0.5):
Starts with a question (0.5): Is there a
Low reputation (1):

Posted by: Tanner

79156579