Most of what I know I have learned by solving practical problems and by trying to help other Excel users in groups like this one. One important thing in understanding complex formulas is to master Excel's Evaluate Formula tool/F9 technique.

There are almost an infinite number of websites with Excel stuff. If you are specifically interested in array formulas you might want to take a look at:

https://www.ablebits.com/office-addi...nctions-excel/

http://www.emailoffice.com/excel/arrays-bobumlas.html

The last one is superb but really advanced.

Firstly thanks again for your help yesterday, for my own learning I'm trying to get my head around those arrays u used. see attachment of excel doc.

Attached Files

xor question.xlsx (17.4 KB, 14 views)

See comments in sheet xor.

Attached Files

xor question.xlsx (21.8 KB, 17 views)

Thanks for that explanation, was really good, learn a great deal , cheers.
One issue I had with it is explained in attached spreadsheet, cheers.

Attached Files

xor question (2).xlsx (23.5 KB, 15 views)