How might I go about determining the following excel report
from this sheet?
Thanks
Serial | Low | Moderate | important | Critical |
11112 | 1 | 1 | ||
10616 | 1 | 1 | ||
10859 | 1 |
from this sheet?
Thanks
Host | Serial | Date | Ship | New | Text |
abc | 11112 | 1/1/2020 | 1/2/2020 | 11/6/2020 | Moderate |
abc | 11112 | 1/2/2020 | 1/3/2020 | 11/6/2020 | Important |
def | 10616 | 1/25/2020 | 1/26/2020 | 11/6/2020 | Moderate |
def | 10616 | 1/26/2020 | 1/27/2020 | 11/6/2020 | Low |
jhi | 10859 | 1/31/2020 | 2/1/2020 | 11/6/2020 | Critical |