Hi
I have a range of data where I wish to determine how many of a given set of conditions are met on each row.
For example how many values from A1:J1 occur in A5:t5, I can achieve this using countif + countif ....... for approximately 20000 rows.
However I am sure that there must be a better way, particularly where I may need to evaluate more conditions.
I would appreciate any advice.
Many thanks
Jeff
Bookmarks