Hi all,
Some very kind people helped me yesterday solve an issue, i now need to add more criteria to my existing formula but can't for the life of me get it to work!!
Please see my data below. I am trying to list the date (without blanks rows), for all Mr Smiths with the out come Open and Percentage at 70 or higher.
The formula i was given yesterday is:
{=IFERROR(INDEX($C$13:$C$24,SMALL(IF($A$13:$A$24="mr smith",IF($B$13:$B$24="open",ROW($A$13:$A$24))),ROWS(E$13:$F13))-ROW($A$13)+1),"")}
This worked great but unfortunately doesn't include my new criteria of percentage of 70 or higher...can anyone help?!
Name Outcome Date Percentage Result
Mr Smith Open 01.02.14 70 01.02.14
Mr Brown Disqualified 01.02.14 70 04.02.14
Mr Brown Qualified 01.02.14 70
Mr Barnes Disqualified 01.02.14 70
Mr Smith Open 02.02.14 70
Mr Brown Open 02.02.14 90
Mr Smith Qualified 02.02.14 90
Mr Smith Qualified 04.02.14 50
Mr Smith Disqualified 04.02.14 30
Mr Brown Qualified 04.02.14 100
Mr Alexander Open 06.02.14 100
Mr Barnes Qualified 06.02.14 70
thanks in advance!
Bookmarks