Thread: formula increases by 1 when rotating list in another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Ben is offline
external usenet poster
  
Posts: 509
Default formula increases by 1 when rotating list in another column
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
--
Reynella
Reply With QuoteReply With Quote