This is a discussion on Need a formula to find difference between values in adjacent cells within the Excel Questions forums, part of the Question Forums category; Hi, Hope you can help me. This is probably very easy and irritating question but I cannot remember how to ...
Hi, Hope you can help me. This is probably very easy and irritating question but I cannot remember how to find the difference between two values in adjacent columns.
I have two sets of figures and I need to have in the third column the difference in numbers, such as (a1) and (b1). A1 has a figure of say 1086 and B1 has a figure of 796 which would be easy if all the figures in column A were going to be the biggest, I would just subtract b from a but they may change next month to a being 695 and b 1123.
Hope you don't mind me asking this question guys as I have completely forgotten how.
Thanks in advance anyway and will see you again soon no doubt
Thank you so much T. Valko. Could not remember what I had used before, you have save me a lot of work trying to figure out what I had to do. So simple, I may have been thinking about some other formula.
Thank you
.
Biff
Microsoft MVP - Excel
Don't be afraid to use volatile functions or array formulas
Tell us what version of Excel you're using
KISS - Keep It Simple Stupid
Hi T. Valko,
You will be pleased to know that I managed to put a conditional format on my work on my own, my god my old brain is working. Need to spend more time watching the mrexcel videos I think to kick start my brain into working.
thanks again
.
Biff
Microsoft MVP - Excel
Don't be afraid to use volatile functions or array formulas
Tell us what version of Excel you're using
KISS - Keep It Simple Stupid
Like this thread? Share it with others