Hi,
I need to in whole do 2 tests but unsure why it's not working.
I'm running a simple copy page down copy.. macro on another programme that copies the data and then pastes into Excel, however with said macro it will duplicate the copy once at the bottom of the list.
This will create a 7 row, 10 column paste of data * however much until I stop running the macro.
I will paste this in B4 and the data can range from B4:K(end of data).
What I need to test is if in column B there's a Y which is simple but then also test if a 7, 10 matches the 7, 10 below e.g does B12:K18 = B19:K25. If either of these tests come true then mark a Y.
So something like {=IF(B12="Y","Y",IF(B12:K18=B19:K25,"Y",""))} but this brings back a Y even if B12 doesn't have a Y and even if the whole of B12:K18 doesn't equal B19:K25.
What's the best way to go about this?
I need to in whole do 2 tests but unsure why it's not working.
I'm running a simple copy page down copy.. macro on another programme that copies the data and then pastes into Excel, however with said macro it will duplicate the copy once at the bottom of the list.
This will create a 7 row, 10 column paste of data * however much until I stop running the macro.
I will paste this in B4 and the data can range from B4:K(end of data).
What I need to test is if in column B there's a Y which is simple but then also test if a 7, 10 matches the 7, 10 below e.g does B12:K18 = B19:K25. If either of these tests come true then mark a Y.
So something like {=IF(B12="Y","Y",IF(B12:K18=B19:K25,"Y",""))} but this brings back a Y even if B12 doesn't have a Y and even if the whole of B12:K18 doesn't equal B19:K25.
What's the best way to go about this?