hi all.
I have a table similar to;
<tbody>
</tbody>
I'm wanting to have sheet 2 display on deals for Company A that are active..
I have tried;
{IFERROR(INDEX('Data Sheet'!A:A,SMALL(IF('Data Sheet'!$C:$C="Company A",IF('Data Sheet'!$F:$F="Dead",ROW($A:$A))),ROWS($A$1:A1))),"")}
and drag down, however not getting any data coming accross?
thanks
I have a table similar to;
Lead # | Date In | Referrer | Sales Rep | Customer | Status | |||
1 | 1/8/18 | Company A | AG | Joe Blogs | Active | |||
2 | 14/8/18 | Company A | HB | John Citizen | Active | |||
3 | 21/8/18 | Company B | AG | Sherly Gray | Dead |
<tbody>
</tbody>
I'm wanting to have sheet 2 display on deals for Company A that are active..
I have tried;
{IFERROR(INDEX('Data Sheet'!A:A,SMALL(IF('Data Sheet'!$C:$C="Company A",IF('Data Sheet'!$F:$F="Dead",ROW($A:$A))),ROWS($A$1:A1))),"")}
and drag down, however not getting any data coming accross?
thanks