shido
03-04-2015, 01:41 PM
Hi All,
I have the following formula which check for condition SH$1 and return list of non-repetitive values.
=IFERROR(INDEX(Applus!$B$7:$E$300,MATCH(0,COUNTIF($H$3:$H3,Applus!C$7:C$300 )+(Applus!$B$7:$B$300<>$H$1),0),COLUMN(Applus!B7)),"")
I need to modify this formula to look for another column and if found "cross pin", then exclude it from the list too.
If your require any more information, please let me know
Regards
Sha
I have the following formula which check for condition SH$1 and return list of non-repetitive values.
=IFERROR(INDEX(Applus!$B$7:$E$300,MATCH(0,COUNTIF($H$3:$H3,Applus!C$7:C$300 )+(Applus!$B$7:$B$300<>$H$1),0),COLUMN(Applus!B7)),"")
I need to modify this formula to look for another column and if found "cross pin", then exclude it from the list too.
If your require any more information, please let me know
Regards
Sha