How fill series containing one variable and one fixed value in XL
In a column of logical functions IF Cell a = Cell b is true, how do I fill
down the series if Cell a is the variable but Cell b remains constant. For example Cell a would be the number of the row in a column and the entry should equal Cell b to return a true answer. I keep getting the actual values replicated but not the formulas. Thanks -- nomad |
How fill series containing one variable and one fixed value in XL
Look in Excel help for the difference between absolute and relative
addressing. If your formula is =A1=B$1, then when you copy it down the column the next row's formula would be =A2=B$1. The preceding $ makes the row 1 reference absolute. -- David Biddulph "nomad" wrote in message ... In a column of logical functions IF Cell a = Cell b is true, how do I fill down the series if Cell a is the variable but Cell b remains constant. For example Cell a would be the number of the row in a column and the entry should equal Cell b to return a true answer. I keep getting the actual values replicated but not the formulas. Thanks -- nomad |
How fill series containing one variable and one fixed value in
THANKS. Appreciate the quick response.
-- nomad "David Biddulph" wrote: Look in Excel help for the difference between absolute and relative addressing. If your formula is =A1=B$1, then when you copy it down the column the next row's formula would be =A2=B$1. The preceding $ makes the row 1 reference absolute. -- David Biddulph "nomad" wrote in message ... In a column of logical functions IF Cell a = Cell b is true, how do I fill down the series if Cell a is the variable but Cell b remains constant. For example Cell a would be the number of the row in a column and the entry should equal Cell b to return a true answer. I keep getting the actual values replicated but not the formulas. Thanks -- nomad |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com