A simple array that I am using isn't working as expected and I don't know why.
Could anyone help?
I have put into a simple format so it should be easy to assist.
A simple array that I am using isn't working as expected and I don't know why.
Could anyone help?
I have put into a simple format so it should be easy to assist.
AND doesn't give you separate results for each column, you will either get all 1s (only when all 8 values in A2:D3 = B5) or all zeroes (for all other scenarios) - to get a separate result for each column use * like this
=IF((B5=A2:D2)*(B5=A3:D3),1,0)
or just this will give the same result
=(B5=A2:D2)*(B5=A3:D3)
Audere est facere
Thank you for this answer.
You showed me that arrays do not work with logical functions and enabled me to learn how to replace them to make them work.
For anyone seeking an answer to this or similar, I am posting the link below.
http://dailydoseofexcel.com/archives...rray-formulas/
Hello, I try to import word file and Access file into Excel so I don't need to type the data again in Excel Sheet.
How can I import them into Excel Form and is there any website showing the instruction step by step by using pictures?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks