I've tried to find another thread that deals with this topic, without success, so here goes:
I have a very large block of data: thousands of rows by hundreds of columns. I need to identify a known value in that block and return the value two cells to the right of it. I can use INDEX to...
In excel 2016, I am trying to concatenate text with a number but decimal point but will not show, i.e. "test"&C2 where C2 contains 3.0. I just get Text3 instead of Text3.0. what am i doing wrong?