LinkBack URL
About LinkBacks
I'm really struggling here and have racked my brain and google for this to work.... I can't get the count to work right for the next set.. please review and any help would be awesome..
I'm really struggling here and have racked my brain and google for this to work.... I can't get the count to work right for the next set.. please review and any help would be awesome..
Last edited by FDibbins; 02-27-2015 at 09:15 PM.
I think all you need here is this?
=COUNTIF(E8:J8,P8)
Note that the use of "=1" is unnecessary, all you need is 1 or 2 etc
Also, I changed your title to something that actually describes your problem (Read rule 1)
Last edited by FDibbins; 02-27-2015 at 09:26 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Actually, I think your original formula is working (but FDibbins is correct about the "=1"... just put 1)...
I don't see any 1's in the the 3rd row, so it should show 0... or am I reading this wrong?
edit R8, press Control+Shift+Enter and drag down
Sandy, how will that work? The formula is actually working fine, all your suggestion does, is make it an unnecessary ARRAY formula
The "= and " can be removed though
But if you do that (CSE) it's working, isn't it? :-)
Yes it is, but it is working without it too, so it's kind of redundant
ARRAY's can become very resource-intensive and start to slow your file down (not in a simple example like this, I agree). You normally use ARRAY's when you atr using - well - array's
Ups, sorry, I saw RED and without checking did CSE and drag.
My fault :-)
Hey, no problem, if you dont ask, you wont know. We are here to try and help (and be helped)
And we are not always right, so - ask away all you want
thank you for the help, still not working right though. Sorry I'm really trying to get "it" but having a hard time, please read the included notes in the excel file that will help explain what each set is (I have this formula correct on another sheet).. Anyway it is just the count I can't get right...Formula test.xlsx
My suggestion still works. I dont see how you expect to get an answer of 6 for those red cells when you only have 4 matching entries in that row?
Tier 1 Tier 2 Tier 3 Tier 4 Tier 5 Tier 6 Correct incorrect incorrect correct incorrect incorrect incorrect incorrect
Q19=COUNTIF(E19:J19,P19)
Maybe Fdibbins are following the origin formula with COUNTIF which is not suitable.
What does the "Count to Next Set" should do? what are your expected results for this column?
Quang PT
The expected results for the count to next set is for excel to count how many are needed for next set..
Formula test.xlsx
some how I need it to count to the next set with it understanding that tiers 1 through 4 are 1111, 2222,3333 etc... tiers 4 and 5 are 1and1,or 2and0,or 0and2, for first set, then 2and2, or 1and3, 3and1, or 4and0, or 0and4. I need it to understand all the possible combos needed for the next and then calculate how many are missing to get to the next set.. Again thanks for the help...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks