formula increases by 1 when rotating list in another column

B

Ben

I have a list of numbers in column A6:A39 I rotate these numbers from A39 to
A6 by cut and insert cut cell method. In column L I have a formula
IF(A6=1590,4502,"") thru to IF (A39=1590,4502,"").When I
rotate column A,the formulas in col L change to IF(A7=1590,4502,"") .The
A6,etc increase by 1. How can I prevent this from happening.
reguards,Ben
 
B

Ben

I don't want to rotate column L as I have numbers in cells that need to stay
in their relative cell e.g.

Col A Col L
1455 123
1558
1590 4502
1699 786
1788
--
With the formula as above if you don't rotate Col A, wherever you put 1590
you get 4502 in col L. The problem occurs only when you rotate Col A. 1590
drops down a line but 4502 does'nt hold true a the A value in the formula
increases by 1
Reynella
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top