| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increases by 1 when rotating list in another column
Hi,
Select both column A and L and then do the cut operation. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ben" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increases by 1 when rotating list in another column
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 "Ashish Mathur" wrote: Hi, Select both column A and L and then do the cut operation. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ben" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for 2% annual sales increases | Excel Worksheet Functions | |||
| Salary and Pension Increases | Excel Discussion (Misc queries) | |||
| Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
| rotating list | Excel Worksheet Functions | |||
| Formula to search for given term, and if not found in column to add it to list | Excel Worksheet Functions | |||
Linear Mode
