|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
05-15-2009, 12:17 AM
|
#1 (permalink) |
|
Registered User
Join Date: May 2009
Posts: 2
OS: vista
|
MS Excel Formula help for noobie please
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 ? |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
