Iron Sheik
06-10-2015, 02:00 AM
Hi,
I've been trying to get my head around an absolute value problem but no luck. :(
I'm trying to get an IF statement with absolute values to copy down a few thousand cells in a spread sheet but can't think of a way to do it other than to manually go into each cell and change the reference.
The formula is:
=IF($M$1222=U$11,$H1222,0)
What I want to achieve is the first absolute value ($M$1222) to change each time I copy it down the column. So if I drag the formula down the column, the value $M$1222 will automatically update to $M$1223, $M$1224 and so on. The formula is then copied across the rest of a table which has about 100 columns so the value in column M needs to stay absolute as it is comparing its value to values in different cells across row 11.
Can this be done or have I painted myself into a corner? Do I have to use VBA or can it be done without VBA? :think:
Cheers
I've been trying to get my head around an absolute value problem but no luck. :(
I'm trying to get an IF statement with absolute values to copy down a few thousand cells in a spread sheet but can't think of a way to do it other than to manually go into each cell and change the reference.
The formula is:
=IF($M$1222=U$11,$H1222,0)
What I want to achieve is the first absolute value ($M$1222) to change each time I copy it down the column. So if I drag the formula down the column, the value $M$1222 will automatically update to $M$1223, $M$1224 and so on. The formula is then copied across the rest of a table which has about 100 columns so the value in column M needs to stay absolute as it is comparing its value to values in different cells across row 11.
Can this be done or have I painted myself into a corner? Do I have to use VBA or can it be done without VBA? :think:
Cheers