| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find first and last values in a row of cells
I have price sheet dumped from SAP, which gives prices for a given item by
period. If no activity in a period, cell is blank. How do I get a formula to return the first value in a row(left-most) (of 6 cells) in one cell, and then the last value (right-most) in another? Represents old price, and last price. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| find the max values for cells in consecutive groups of 600 | Excel Discussion (Misc queries) | |||
| Find values from cells in multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
