Hi all,
I have been asked to come up with a simple spreadsheet to track any emails/calls we get about our employees regarding either praise or complaints.
So I have an overview page and a records page.
The records page is 4 columns:
HOST NAME > COMPLAINT > PRAISE > COMMENT
In the overview page, I have :
HOST NAME > TOTAL COMPLAINTS > TOTAL PRAISE
As the compaints come in I will go to the records page and enter the hosts name, put a Y in either the complaints or praise columns and fill the comment fields.
On the overview page I want the complaint field to go down the Host name column in the records page and find all records of that host, then to automatically find all complaints about them in order to show total complaints. I will then do the same for total Praise.
How do I do this?
Obviously, its a formula but other than basic stuff my excel is pants.
If you could explain the formula as well I'd be very grateful
How do I do this?
I have been asked to come up with a simple spreadsheet to track any emails/calls we get about our employees regarding either praise or complaints.
So I have an overview page and a records page.
The records page is 4 columns:
HOST NAME > COMPLAINT > PRAISE > COMMENT
In the overview page, I have :
HOST NAME > TOTAL COMPLAINTS > TOTAL PRAISE
As the compaints come in I will go to the records page and enter the hosts name, put a Y in either the complaints or praise columns and fill the comment fields.
On the overview page I want the complaint field to go down the Host name column in the records page and find all records of that host, then to automatically find all complaints about them in order to show total complaints. I will then do the same for total Praise.
How do I do this?
Obviously, its a formula but other than basic stuff my excel is pants.
If you could explain the formula as well I'd be very grateful
How do I do this?