| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting last five numbers in a selection
I have a series of data in the same row, (F5:AC5) containing anywhere from 1
to 24 numbers. In cells AD5:AH5, I want to determine the LAST five numbers entered in the row of data (not smallest or largest, but simply the last numbers that were entered in). There could be duplicate numbers, and blanks in between cells of numbers. How would I go about this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Selecting multiple objects by drawing a selection box | Excel Discussion (Misc queries) | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
| how to set shading color of selection when i am selecting cells? | Setting up and Configuration of Excel | |||
| Selecting Multiple Columns in a Named Selection | Excel Worksheet Functions | |||
Threaded Mode
