| 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 |
| 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 | |||
Threaded Mode
