Hi Guys,
Just a quick one...
I have a set of numerical data in 2 columns next to each other. I want to see the difference between the two. I usually use "=A1-B1" and then copy it down, if B1 has a greater value than A1 and shows the minus sign I simply swap the formula around to "=B1-A1". Here is the issue though, this has worked fine for me when I have been working with no more than 10 rows of data.... but now I have 100s rows of data and I want to pop the formula in the top cell and copy it down in one swift go to save time.
Any formula suggestions will be a great help.
Or a VBA if that works better.
Thanks
Bookmarks