SMALL function with multiple IF statements (or alternative suggestion)
Hi, I am new to this forum and this is my 1st post for help.
I have outlined the problem below and in the attached Word document.
I have a data table with 4 columns of data:
Job number (Column A), visit date Column B), Job type (Column C), Status (Column D).
Also an answer table with columns E to K.
I want to return the date occurrences in 1st, 2nd, 3rd etc order, that relate to aaprticular Job number, that also meet certain Job type and Status criteria.
This is described further in the attached document.
I have tried the function 'SMALL' with multiple 'IF' statements, but can't get it to work.
This example is an extract of a larger spreadsheet with much more data variations in the descriptions in columns C and D.
If someone could give me the formula I need to enter in cells G3:K4, that gives me the date occurrences I need, I would be most grateful.
Forgive me if I have not got the forum etiquette or format correct. I am new to this. Any advice would be welcome.
Thank you.
garymon9AX
|