Change data based on specific column?

Originally Posted by deesh123

I have a sheet where I have data specific to each day in a separate column.

Day 1  Day 2 
  A        X
  B        Y
  C        Z

I want to have another section on the same sheet that breaks down data specific to a day.

Day 1 Breakdown
[A] [A*2] [A*3]
[B] [B*2] [B*3]
[C] [C*2] [C*3]

OR

Day 2 Breakdown
[X] [X*2] [X*3]
[Y] [Y*2] [Y*3]
[Z] [Z*2] [Z*3]

Is there a way where I can have a single cell change whether Day 1 or Day 2 is broken down in my "breakdown section"?

There used to be, in very junior schools, a subject known as 'Reading and Comprehension' whereby a child could read the letters D O and G as d-o-g = dog and associate that with some furry little ball on 4 legs that runs, barks, bites, and pee's on the lawn.

I guess I must have failed that subject.

I cannot see two occurances of 'A' to relate to [A*2] [A*3] etc (nor to any other letter/day combination).

Is there some guide as to the criteria for inclusion on the second section?

---

I'm sorry I wasn't clear - this requires a simple solution to a complex concept.

I will have to be more specific. This excel sheet is for a 12 day weight lifting program.

I have 12 columns representing each day of lifting. Each row represents an exercise.

Here is an example:

Exercise Name  Day 1     Day 2     Day 3     Day 4     Day 5
Bench Press      100      110       120      130       140
Barbell Curls    10       20        30       40        50
Leg Press        200      210       220      230       240

Above, each exercise has a weight assigned to it for each day. This is where it gets tricky. The number above denotes the weight I will do for my set of 6 repetitions. Before I do that set of 6 repetitions, I warm-up with a set of 12 repetitions(at 50% of the weight assigned to 6 repetitions) a set of 10 (at 75% of the weight assigned to 6 repetitions) set of 8 at (85%of the weight assigned to 6 repetitions).

On the same excel sheet I have a section that I will select and print out each day to use as reference while at the gym. I would like this section to call on a certain day and break down each exercise as I've explained above

Here is an example:

Day 1

Exercise Name  Bench P    Barbell Curls     Leg Press
"12 Set"        100*.50    10*.50           200*.50
"10 Set"        100*.75    10*.75           200*.75       
"8 Set"         100*.85    10*.85           200*.85
"6 Set"         100        10               200

I can't figure out a way for an excel sheet to call on a specific column, or in my case a specific day, and then apply multiplication to it.

Please let me know if I am still not clear? I am willing to E-mail my sheet if need be.

Originally Posted by deesh123

I'm sorry I wasn't clear - this requires a simple solution to a complex concept.

I will have to be more specific. This excel sheet is for a 12 day weight lifting program.

I have 12 columns representing each day of lifting. Each row represents an exercise.

Here is an example:

Exercise Name  Day 1     Day 2     Day 3     Day 4     Day 5
Bench Press      100      110       120      130       140
Barbell Curls    10       20        30       40        50
Leg Press        200      210       220      230       240

Above, each exercise has a weight assigned to it for each day. This is where it gets tricky. The number above denotes the weight I will do for my set of 6 repetitions. Before I do that set of 6 repetitions, I warm-up with a set of 12 repetitions(at 50% of the weight assigned to 6 repetitions) a set of 10 (at 75% of the weight assigned to 6 repetitions) set of 8 at (85%of the weight assigned to 6 repetitions).

On the same excel sheet I have a section that I will select and print out each day to use as reference while at the gym. I would like this section to call on a certain day and break down each exercise as I've explained above

Here is an example:

Day 1

Exercise Name  Bench P    Barbell Curls     Leg Press
"12 Set"        100*.50    10*.50           200*.50
"10 Set"        100*.75    10*.75           200*.75       
"8 Set"         100*.85    10*.85           200*.85
"6 Set"         100        10               200

I can't figure out a way for an excel sheet to call on a specific column, or in my case a specific day, and then apply multiplication to it.

Please let me know if I am still not clear? I am willing to E-mail my sheet if need be.

To apply multiplacation to a cell, put the multiplier in a spare cell and Copy it,

Select the concerned cells, and

Paste, Special - set to Multiply

Is this what you mean?

---

Ah, we are getting much closer to the answer!

I forgot one detail. See the following example:

Variable Key:
θ = Bench pess weight on Day X
t = Barbell curl weight on Day X
α = Leg press weight on Day X

Day X

Exercise Name   Bench P        Barbell Curls     Leg Press
"12 Set"        θ*.50            t*.50              α*.50
"10 Set"        θ*.75            t*.75              α*.75       
"8 Set"         θ*.85            t*.85              α*.85
"6 Set"         θ                t                  α

How can I have a cell where all I need to change is X, which represents one day (or in excell's case one column of data), and have the rest of this chart get broken down as shown above. Remember that θ, t, and α change depending on the day.

Originally Posted by deesh123

Ah, we are getting much closer to the answer!

I forgot one detail. See the following example:

Variable Key:
θ = Bench pess weight on Day X
t = Barbell curl weight on Day X
α = Leg press weight on Day X

Day X

Exercise Name   Bench P        Barbell Curls     Leg Press
"12 Set"        θ*.50            t*.50              α*.50
"10 Set"        θ*.75            t*.75              α*.75       
"8 Set"         θ*.85            t*.85              α*.85
"6 Set"         θ                t                  α

How can I have a cell where all I need to change is X, which represents one day (or in excell's case one column of data), and have the rest of this chart get broken down as shown above. Remember that θ, t, and α change depending on the day.

Assuming your 'day' is in row 6, then try

="θ = Bench press weight on "&A6&" "&B6
etc

Originally Posted by Bryan Hessey

Assuming your 'day' is in row 6, then try

="θ = Bench press weight on "&A6&" "&B6
etc

Your suggestion only pulls data from one cell; however, I need the sheet to be more dynamic since I have so much data.

I've thought about this long and hard and realized a simpler way to ask my question. Disregard my previous postings and see the following example:

Col A      Col B   Col C   Col D    Col E
                           Day No.  X
Day no.     1       2    | Today
Bench P    100     110   |  t
Leg P      200     210   |  s

I want my sheet to function so that when I replace "X" by typing a "1" then "t" and "s" are replaced by their values 100 and 200 for Day 1. Similarly, I when I replace "X" by typing a "2" I want "t" and "s" to be replaced by their values 110 and 210.

Is this possible in excel?

Originally Posted by deesh123

Your suggestion only pulls data from one cell; however, I need the sheet to be more dynamic since I have so much data.

Correctly entered it adds data from cells A6 and B6, both addresses of which were guesses as your examples give no indication as to which cells data is in.

I've thought about this long and hard and realized a simpler way to ask my question. Disregard my previous postings and see the following example:

Col A      Col B   Col C   Col D    Col E
                           Day No.  X
Day no.     1       2    | Today
Bench P    100     110   |  t
Leg P      200     210   |  s

I want my sheet to function so that when I replace "X" by typing a "1" then "t" and "s" are replaced by their values 100 and 200 for Day 1. Similarly, I when I replace "X" by typing a "2" I want "t" and "s" to be replaced by their values 110 and 210.

Is this possible in excel?

Many things are possible, and to be able to detect an entry in another cell and use that or some indicated data in a formula is reasonably standard practice.

However, without using VB code a cell will contain only the result of it's own formula.

For the cell containing t to react to you enterering a figure in a cell the formula must be aware of that cell, ie

=If(A1="x","",If(A1=2,200,100))

should fill your request.
---