Forum Discussion
Counting value combos based on matching values in other columns.
Thank you for your help! I am having some trouble figuring out parts of the formula you gave me (everything I know about excel is self taught using forums like these so I am probably just not using it correctly).
For =A2&B2&C2
Am I using this in that A=the Name column, B=the Date column, and C=the Time column?
- If yes, then this part I got to work 🙂 though I am not sure how it works with the next formula
For =COUNTIFS($D$2:$D$10,"*"&A13&"*",$D$2:$D$10,"*"&B13&"*")
Is D the column the tests are in or is it the helper column?
- This is the part I am not getting to work as it returns "0" for everything.
If it the test column where does the helper column come in and if it is the helper column where does the test column come in?
Any clarification would be greatly appreciated!!!
Perhaps this example can give you a better understanding of what I mean.
If it is not what you want, or it is what you want, just give us feedback, please.
Not quite what I need, though I think my example was unclear so below is more like what I am talking about. Only the ones with Name, Date, and Time matching need to be counted to find how many have both Test A and B, or Test A and C, or All three. I did find a round about way to do it using COUNTIF. It is not pretty but I think it is working. Thank you for your help!
Name Test Date Time Test, Potato A 1/17/2023 22:39 Test, Potato B 1/17/2023 22:39 Fake, Name A 1/17/2023 7:51 Llama, Iona A 1/20/2023 21:14 Llama, Iona B 1/20/2023 21:14 Llama, Iona C 1/20/2023 21:14 Mashed, Potato B 8/1/2023 19:01 Bioled, Potato A 9/1/2023 9:19 Boiled, Potato C 9/1/2023 23:06 Combos Total AB 1 AC 0 ABC 1