Hi,
I need your help with the following.
Column 1 Column 2
X1 Insurance
X1 Tax
X1 Utilities
X1 Other
X2 Insurance
X2 Tax
X2 Utilities
X2 Other
On another sheet I have the X1 and X2’s that need to be plotted on this sheet in the first column, so I want to have a formula that recognizes it needs to switch to X2 when having insurance again. Does anyone know a clean way of doing this?
Thank you!
I need your help with the following.
Column 1 Column 2
X1 Insurance
X1 Tax
X1 Utilities
X1 Other
X2 Insurance
X2 Tax
X2 Utilities
X2 Other
On another sheet I have the X1 and X2’s that need to be plotted on this sheet in the first column, so I want to have a formula that recognizes it needs to switch to X2 when having insurance again. Does anyone know a clean way of doing this?
Thank you!