Hia.
I have a worksheet with 7 columns & 2500 rows. Each cell in that contains a series of words (Required, N/A, Match, etc.).
For each row I need to count as per the following logic :-
Does the Row (A1) start with the word "Required" - if so then add 1 to the row count & if not then stop & goto the next row.
Does the adjacent cell (B1) contain the word "Required" if so add 1 to the row count & if not then stop & goto the next row.
Does the adjacent cell (C1) contain the word "Required" if so add 1 to the row count & if not then stop & goto the next row.
Repeat for each of the 7 columns.
In the simplified example below ......
Row 1 should return 2
Row 2 should return 1
Row 3 should return 2
Row 4 should return 3
Row 5 should return 0
Row 6 should return 0
Screen Shot 2017-08-17 at 18.01.18.png
Hope the above makes sense - have been bashing my head on this one for hours now so hoping someone can point me in the right direction.
Many thanks !!
Bookmarks