Hello Everyone,
I'm using this formula to use cascading data validation lists:
=INDIRECT(SUBSTITUTE(O2," ",""))
I'd like this formula to not go to O2 but rather the cell left of the current cell with the formula in it. Is that possible?
Many Thanks,
Ellsworth
Bookmarks