Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
Date:
Jan 1st: Jan 2nd:

Color 1 Color 1
Yellow 10 Yellow 10
Green 20 Green 20
Purple 30 Orange 20
Purple 30
Color 2
Yellow 15 Color 2
Green 25 Yellow 15
Purple 35 Green 25
Purple 35


Hello, here are the reports that I receive daily, I'm looking for a formula in excel that will give me a result in the following information.

Color 1-> Green: 20, Orange: 0. Color 2-> Green: 25, Purple 35

sometimes the colors are not necessary in the same order + I only care about green, orange and purple.. If for some reason the colors are not written in the report, I want it to automatically say 0

Anyone can help please ?
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top