Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Interrogating Data in Excel
Hello,
Not being an excel wizard I need some help on this one. I have a summary sheet of a number of differnt teams at work, then in four different worksheets I have the same teams and their goals and whether they have met them or not on a rolling weekly basis for 10wks. What I want to do in the summary sheet is say look at this teams performance in Worksheet 1 and if they have failed for the week put a F or colour red in the summary spreadsheet. Then look at the next teams performance and so on. Any ideas would be much appreciated. |
#2
|
|||
|
|||
Daniel,
One option would be to use an IF statement to set up the condition. As an example, add the number 90 into cell A1 of Sheet1. Now, create another worksheet called "Summary". In cell A1 of the worksheet called Summary, add this formula: =IF(Sheet1!A1100,"Pass","Fail") The message in cell A1 of the Summary sheet should say "Fail". If you change the number in cell A1 of Sheet1 to 110, the message in cell A1 of the Summary sheet should now say "Pass". ---- Regards, John Mansfield "Daniel Dewes" wrote: Hello, Not being an excel wizard I need some help on this one. I have a summary sheet of a number of differnt teams at work, then in four different worksheets I have the same teams and their goals and whether they have met them or not on a rolling weekly basis for 10wks. What I want to do in the summary sheet is say look at this teams performance in Worksheet 1 and if they have failed for the week put a F or colour red in the summary spreadsheet. Then look at the next teams performance and so on. Any ideas would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
pasting excel data in a powerpoint slide | Excel Discussion (Misc queries) | |||
How do I plot Excel data on a floorplan? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |