Good Morning,
I'm trying to have excel look at cells referenced by a date, what function should I be using? The dates are all located horizontally across the top in a single row and the text I want to return when the data is greater than 0 are frozen vertically in three different columns. I want to look at the dates then return for example (GM Bad weld 1) so then I can order them greatest to least.
<tbody>
</tbody>
I'm trying to have excel look at cells referenced by a date, what function should I be using? The dates are all located horizontally across the top in a single row and the text I want to return when the data is greater than 0 are frozen vertically in three different columns. I want to look at the dates then return for example (GM Bad weld 1) so then I can order them greatest to least.
12-8-16 | 12-9-16 | 12-10-16 | 12-13-16 | ||||
GM | shoddy glue | 0 | |||||
GM | Bad weld | 1 | |||||
GM | Poor adhesion | 0 | |||||
GM | Ugly spot | 4 | |||||
GM | Bond issue | 0 | |||||
<tbody>
</tbody>