| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extract numbers from cells
I have 2 columns of numbers in a sheet called "Fill up Records". I wish
to copy the data in the 2nd to last cell before a blank in one column ( L) and the last number before a blank in the other column (C) and divide the first by the second and put the answer on a different sheet. The blank cells only occur after the first blank cell. What formula would I use in the second sheet to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing cells with text and numbers | Excel Worksheet Functions | |||
| extract non-specific info from multiple cells | Excel Discussion (Misc queries) | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
Threaded Mode
