I have a sheet1 that has the following dataset A
ColumnA: ColumnB: ColumnC: ColumnD:
Row1: June 1 June 2 June 3
Row2:
Row3: A Apple Apple Orange
Row4: B Orange Orange Orange
Row5: C Orange Apple Orange
Row6: D Pear Apple Pear
In that sheet I have the following table
Consumed fruits
**June 1** **June 2** **June 3**
Apple Orange Pear Apple Orange Pear Apple Orange Pear
A True True True
B True True True
C True True True
D True True True
Where for each cell I add the following code that pertains to datasetA
For June 1, A, Apple
=IF(B3="Apple","True","")
June 1, A, Orange
=IF(B3="Orange","True","")
June 1,A, Pear
=IF(B3="Pear","True","")
But when I drag the formula to the next date (June 2, A, Apple), it changes to
=IF(B6="Apple","True","")
Instead of
=IF(B4="Apple","True","")
Is there anyway to keep the query cells constant for 3 formulas, before incrementing just one query cell up in the next 3 formulas?
Aucun commentaire:
Enregistrer un commentaire