compare rows for a match and sum the matches
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges? |
compare rows for a match and sum the matches
Bert wrote:
How do I compare numbers say d101:l101 with c17:k17 and count the number of matches between the 2 ranges? Array-formula (commit with CTRL+SHIFT+ENTER): =SUM(--(C17:K17=TRANSPOSE(D101:L101))) |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com