I have the following formula:
=SUMPRODUCT(--(LEFT(May08WFA!$A$1:$A$4000,2)="x-"),--(ISERROR(MATCH(May08WFA!$A$1:$A$4000,Apr08WFA!$A$1:$A$4000,0)=TRUE)))
I want to amend the part of the formula “(LEFT(May08WFA!$A$1:$A$4000,2)="x-")” to now look at column B range 1:4000 on the same sheet and isolate only values that do not contain a comma in the text.
LEFT function not needed for this part.
Then Is Error (Match B1:B4000) between the two sheet
=SUMPRODUCT(--(LEFT(May08WFA!$A$1:$A$4000,2)="x-"),--(ISERROR(MATCH(May08WFA!$A$1:$A$4000,Apr08WFA!$A$1:$A$4000,0)=TRUE)))
I want to amend the part of the formula “(LEFT(May08WFA!$A$1:$A$4000,2)="x-")” to now look at column B range 1:4000 on the same sheet and isolate only values that do not contain a comma in the text.
LEFT function not needed for this part.
Then Is Error (Match B1:B4000) between the two sheet