I am trying to perform the following:
Column A has text.
If the text in Column A equals a specific value, "apples" for example.
I need to count how many times in the corresponding row of Column A="apples" to multiple columns; Column C,G,K,O equaling either "Y" OR "N"
There are blank values in the corresponding rows of Column A when it equals "apples" in Columns C,G,K,O.
In other words, when Row 2 of Column A = apples, Row 2 Column C has blanks, Y or N.
I'm counting repeating sequences (sequence being apples, oranges, pears) in Column A, based on Y or N in columns C,G,K,O. So for example:
Column A ----- C ----- G ----- K ----- O
apples ----- Y ----- ----- Y -----
oranges ----- Y ----- N ----- -----
pears ----- ----- Y ----- -----
apples ----- ----- N ----- -----
oranges ----- N ----- ----- -----
pears ----- ----- ----- ------
So, in total apples has a value of Y or N, 3 times. Y, 2 times and N, 1.
The values in Column A repeat in the sequence through 150 row, and in my specific example the sequence is 32 repeating values, all specific text.
If you have questions, please ask. I hope I've been as clear as possible to reach an answer. Of my 32 text values, I'm trying to decipher fewest entries, percentages, etc. based on these results.
Bookmarks