Hi - I have a table extracted below which repeats many codes as months are actualised for sales
I have a summary sheet and would like to highlight the 1st month a sales occurs for each item - unfortunately I cannot use just the 1st month it appears in the report as sometimes we don't initially have sales
So below would be ARTSQETCH Jul-17 and ARTGLSLANT would be May-16 - Is there a calc I could use ? thanks
Code Month Sales
ARTSQETCH May-17
ARTSQETCH Jun-17
ARTSQETCH Jul-17 500
ARTGLSLANT Feb-16
ARTGLSLANT Mar-16
ARTGLSLANT Apr-16
ARTGLSLANT May-16 50
ARTGLSLANT Jun-16 100
ARTGLSLANT Jul-16 150
ARTGLSLANT Aug-16 200
ARTGLSLANT Sep-16 250
ARTGLSLANT Oct-16 250
Bookmarks