| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Race Distance Formula
I have a column A1:A17 which displays variations the following data.
5f 6f 7f 1m 1m 1f 1m 2f 1m 3f 1m 4f 1m 5f 1m 6f 1m 7f 2m 2m 1f 2m 2f 2m 3f 2m 4f 2m 5f The data refers to race distances. As 1m (mile) = 8f (furlongs), how can I simplify the data to show the following data in B1:B17? 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 I was using the ISERROR function, but that does not work anymore, maybe because of formatting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| Can this be done using an array formula ? | Excel Worksheet Functions | |||
| Creating a formula for down and distance | Excel Worksheet Functions | |||
| Time and distance formula | Excel Worksheet Functions | |||
Threaded Mode
