LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Formula to place the same value in a specific number of cells

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any formula to count number of cells with a specific color pattern Stu Excel Worksheet Functions 2 November 16th 07 05:13 PM
Is it possible to count specific words in a number of cells? theboytree Excel Discussion (Misc queries) 1 June 15th 06 09:29 AM
Finding cells with a specific number of characters Kamran Excel Discussion (Misc queries) 6 March 29th 06 11:04 PM
lookup specific character place Budwho Excel Worksheet Functions 6 July 20th 05 06:59 PM
need if-then formula-If a number is > /< something, then place a . JDenio Excel Worksheet Functions 3 March 24th 05 08:29 PM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"