J
james
Hello World,
A3, B3,(C3)
I do monthly stats on availability and I use some fancy
functions (in C3)
=IF((A3=B3),"",IF(A3>B3,"▲","▼"))
Column A is last month, B this month, C will show me "" if
nothing changed, ▲ if increased and ▼ if decreased.
My problem is next month I will insert a new column after
colomn B and the function will auto update the reference
points and now not be looking at the two left adjacent
columns!
Each month I need to re asign the "relative cell
reference" which is supposed to be "relative" to the cell
where the function is?
Any help on locking the reference to look at the left
adjacent cells
James
A3, B3,(C3)
I do monthly stats on availability and I use some fancy
functions (in C3)
=IF((A3=B3),"",IF(A3>B3,"▲","▼"))
Column A is last month, B this month, C will show me "" if
nothing changed, ▲ if increased and ▼ if decreased.
My problem is next month I will insert a new column after
colomn B and the function will auto update the reference
points and now not be looking at the two left adjacent
columns!
Each month I need to re asign the "relative cell
reference" which is supposed to be "relative" to the cell
where the function is?
Any help on locking the reference to look at the left
adjacent cells
James