kylenusser
New Member
- Joined
- Aug 3, 2018
- Messages
- 9
Hello. I am trying to compile a database and use some function to match the number of calls ran by date.
For example:
<tbody>
</tbody>
Above is a database of the first two days. I am trying to compile a sheet that has Facility A-F in column A and in Column B-Etc is each date from 1/1/18-12/31-18. I am trying to see if there is a function that will allow me to search the table above for say Facility A on 1/1/18. I want to set it to be able to pull any day, as the table will ultimately extend to 12/31/18.
Does anyone know of any functions that can do this?
For example:
1/1/18 | 1/2/18 | ||
Facility A | 15 | Facility A | 25 |
Facility B | 20 | Facility B | 15 |
Facility C | 30 | Facility C | 15 |
Facility D | 20 | Facility D | 10 |
Facility E | 8 | Facility E | 7 |
Facility F | 9 | Facility F | 10 |
Facility G | 5 | Facility G | 6 |
Facility H | 8 | Facility H | 9 |
Facility I | 10 | Facility I | 20 |
<tbody>
</tbody>
Above is a database of the first two days. I am trying to compile a sheet that has Facility A-F in column A and in Column B-Etc is each date from 1/1/18-12/31-18. I am trying to see if there is a function that will allow me to search the table above for say Facility A on 1/1/18. I want to set it to be able to pull any day, as the table will ultimately extend to 12/31/18.
Does anyone know of any functions that can do this?