Formula to place the same value in a specific number of cells

[flarunner]

I have Excel 2000. I would like to do this without macros.

Column F is "Pace", written as mm:ss.
Column G is "Miles", written with no decimals.

Both of these columns are the result of other formulas.

Example:
F4 G4
Pace Miles
08:51 5

I would like to place the "Pace" value in a row of cells that corresponds to
the number of "Miles".

In the above example, the "Pace" of 08:51, would be in cells H4 - L4.

Any and all help on this is gratefully accepted.

~fla

 

[Fred Smith]

If you want H4:L4 to be the same as the pace that's in F4, enter the
following formula in H4:

=$F$4

Format it the same as F4, and copy it across to L4.

Regards,
Fred.

 

[flarunner]

Thanks Fred, but I don't want to have to do it manually. I want Excel to
place the "Pace" in the row of cells the same number as the number of
"Miles".

So, if "Miles" on Monday is 5, I want 5 cells filled with "08:51". On
Tuesday if the "Miles" is 4, I want 4 cells filled with that "Pace" which is
"09:03", and so on.

~fla

 

[Fred Smith]

Well, you're going to have to use either a macro or formulas. You'll have to
choose which one. To do it with formulas, you can use something like:

h4: =if(column(h4)<$g4+8,$f4,"")

and copy this across and down your table.

Regards,
Fred.

 

[flarunner]

Thank you Mr. Smith. That is exactly what I wanted.