C
crafty_girl
I know there has to be a way to do this but can't figure it out. Does this
look like something anyone can assist with!?
(early-late) Line Biz Unit
Col D Col G Col H
10 VOLUME IPG
80 VOLUME PSG
-160 VALUE IPG
20 VOLUME TSG
GOAL:
IF Col G = Value & Col H = IPG, count occurrences greater than 10 days,
count occrences between 5-10 days, etc. for each grouping.
(col G) (col H)
VALUE IPG
COUNT numbers matching the below ranges (found in col D).
No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)
(col G) (col H)
VALUE PSG
COUNT numbers matching the below ranges.
No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)
REST OF THE LIST OF SEGMENTS TO COUNT FOR…
VALUE TSG
VALUE NO PRODUCT GROUP
VALUE CORP AND OTHER SEGMENT
VOLUME IPG
VOLUME PSG
VOLUME TSG
VOLUME NO PRODUCT GROUP
VOLUME CORP AND OTHER SEGMENT
look like something anyone can assist with!?
(early-late) Line Biz Unit
Col D Col G Col H
10 VOLUME IPG
80 VOLUME PSG
-160 VALUE IPG
20 VOLUME TSG
GOAL:
IF Col G = Value & Col H = IPG, count occurrences greater than 10 days,
count occrences between 5-10 days, etc. for each grouping.
(col G) (col H)
VALUE IPG
COUNT numbers matching the below ranges (found in col D).
No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)
(col G) (col H)
VALUE PSG
COUNT numbers matching the below ranges.
No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)
REST OF THE LIST OF SEGMENTS TO COUNT FOR…
VALUE TSG
VALUE NO PRODUCT GROUP
VALUE CORP AND OTHER SEGMENT
VOLUME IPG
VOLUME PSG
VOLUME TSG
VOLUME NO PRODUCT GROUP
VOLUME CORP AND OTHER SEGMENT