4 posts shown.
Hi there!
Does anyone happen to know if Johnson opens up at eight or ten in the morning? I can't quite recall what was posted on his office door, and I'd hate to make a wasted trip—I've done that enough times myself! If anyone could clarify this for me, I'd really appreciate it.
Thanks in advance for the help!
Kyle Johnson2, thanks so much!!!
So, this was how I finally managed to pull it off 🙂))
Walter Jackson48, thank you so much for getting back to me!
I gave that formula a shot, but I can't quite get it to work—it's just not clicking 😢
The core issue is that I'm actually dealing with 25 different possible combinations based on values ranging from 1 to 5 😢
1-1 1-2 1-3 1-4 1-5
2-1 2-2 2-3 2-4 2-5
3-1 3-2 3-3 3-4 3-5
4-1 4-2 4-3 4-4 4-5
5-1 5-2 5-3 5-4 5-5
At this point, honestly, it feels like it might be easier to just count them all by hand—haha 🤣
What's really making my head spin is that I need to tally how many times these specific combinations show up across 51 rows in two columns—and we're talking about nearly 220 almost identical scenarios. Then, I have to present all of that through over 220 pivot tables... 😲
I am still very much open to any suggestions or creative ideas regarding formulas! Truly, any help at all would be greatly appreciated.
So, here’s the situation—I’m running into a bit of a snag with a specific formula and could really use some guidance. I assume I’ve landed in the right thread, but please excuse me if I haven't 😉
.
To lay it out clearly, I have data organized in column A (specifically the range A1 : A52) and column B (range B1 : B52). All the values in these columns are whole numbers ranging from 1 to 5.
Here is a quick visual of how the data is structured:
A B
1 1
4 5
3 2
2 3
1 1
2 2
. .
. .
. .
What I am trying to achieve is a formula that counts specific combinations. For instance, how many times do we see:
A=1 and B=1 — looking at the sample above, there would be two such instances where A=1 and B=1.
A=3 and B=2 — that would be one combination.
A=2 and B=3 — and another single combination...
I hope my explanation makes sense so far 😉
. While browsing online, I came across the COUNTIFS function, which seems to be the exact solution for what I'm trying to do—it describes my requirements perfectly—but for some reason, my Excel isn't accepting the formula 🙂 😠
. Does anyone have any insight into why Excel might be rejecting this (honestly, I can't even find it in my list of available functions), or perhaps you could suggest an alternative combination of existing formulas to reach the same result? Essentially, I just need to count how many times a specific value in A pairs with a specific value in B.
Thank you all so much in advance for any help or suggestions you can offer!