Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing rows that don't show the lowest stock each day
Hi
I have a spreadsheet that has a date column A and a stock level column Z. Due to stock coming in and going out at different times of the same day there are often a number of dates the same in col A (time is recorded separately in col B) and varying values in col Z. I need to produce a graph of the lowest stock level from every day on which the stock level changes. Thus:- A Z 1 1/1/5 100 2 1/1/5 150 3 1/1/5 99 4 1/1/5 120 5 2/1/5 130 6 2/1/5 120 7 6/1/5 100 8 6/1/5 150 9 6/1/5 175 etc Therefore I want to be able to hide/delete (somehow?) all but row 3, 6 and 7 in this example so I can use the remaining rows date and stock levels for the graph. Thanks, any help would be greatly appreciated. Guy. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find lowest and highest value from a set of rows | Excel Discussion (Misc queries) | |||
Show Rows Button | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |