| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table formula to pick most recent value.
Is there a way to pick the last value of an item in a pivot table? I was
using the Average function, but it's not correct. I need to poll the data and pick a value based on date field in my data. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table formula to pick most recent value.
this tool will tell you the first cell in the Pivot Table:
http://www.contextures.com/xlPivotPlayPLUS01.html I'm not sure about the last cell... Regards, Ryan--- -- RyGuy "Kaye" wrote: Is there a way to pick the last value of an item in a pivot table? I was using the Average function, but it's not correct. I need to poll the data and pick a value based on date field in my data. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table: Most recent price for an item? | Excel Worksheet Functions | |||
| How to pick a value out of a table | Excel Worksheet Functions | |||
| vlookup - can't pick up table array | Excel Worksheet Functions | |||
| Pull recent pricing data from table | Excel Worksheet Functions | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
Linear Mode
