Counting values in colums
Solved/Closed
gunnarb
gunnarb - Feb 7, 2011 at 10:42 AM
- Posts
- 2
- Registration date
- Wednesday January 26, 2011
- Status
- Member
- Last seen
- January 27, 2011
gunnarb - Feb 7, 2011 at 10:42 AM
Related:
- Counting values in colums
- How two count values matching other values ✓ - Forum - Office Software
- Counting values in Multiple ComboBox's ✓ - Forum - Office Software
- Excel - Count 2 values in one column and 1 value in other - How-To - Excel
- Can the formula COUNTA / COUNT exclude 0 values? ✓ - Forum - Excel
- Count 2 values in one column and 1 val in oth ✓ - Forum - Office Software
9 replies
TrowaD
Feb 7, 2011 at 08:57 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Feb 7, 2011 at 08:57 AM
Hi Gunnar,
Take a look at your file:
https://authentification.site/files/26731266/Gunnar2.xls
The alfabet letters in B6:B27 have a conditional format. When 7 1's are next to each other the letter turns blue.
Note: the formulas used in row 45:66 can be hidden or turn the text color to white, to keep your sheet look clean.
Is this better?
Best regards,
Trowa
Take a look at your file:
https://authentification.site/files/26731266/Gunnar2.xls
The alfabet letters in B6:B27 have a conditional format. When 7 1's are next to each other the letter turns blue.
Note: the formulas used in row 45:66 can be hidden or turn the text color to white, to keep your sheet look clean.
Is this better?
Best regards,
Trowa
rizvisa1
Jan 27, 2011 at 09:07 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 27, 2011 at 09:07 AM
I think you need vba to do that. Is this waring to show up as you type in number or does it need to show up in some other way ?
gunnarb
Jan 27, 2011 at 09:53 AM
- Posts
- 2
- Registration date
- Wednesday January 26, 2011
- Status
- Member
- Last seen
- January 27, 2011
Jan 27, 2011 at 09:53 AM
hi
when there is 7 in a row, it should just display somthing at the end colum
like when you input 1, 7 times in a row it lets you know
thanks
when there is 7 in a row, it should just display somthing at the end colum
like when you input 1, 7 times in a row it lets you know
thanks
TrowaD
Jan 31, 2011 at 09:35 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jan 31, 2011 at 09:35 AM
Hi Gunnarb,
You could use an extra column next to B (or wherever).
Use a simple SUM formula to count seven cells.
At the end of the column use the following formula:
=SUM(IF(C8:C23=7,1,0))
This is an array formula, confirm by hitting Ctrl+Shift+Enter.
When this formula shows a 1 you know 7 times a 1 are below each other.
If a 0 shows up this is not the case.
Does this work for you?
Best regards,
Trowa
You could use an extra column next to B (or wherever).
Use a simple SUM formula to count seven cells.
At the end of the column use the following formula:
=SUM(IF(C8:C23=7,1,0))
This is an array formula, confirm by hitting Ctrl+Shift+Enter.
When this formula shows a 1 you know 7 times a 1 are below each other.
If a 0 shows up this is not the case.
Does this work for you?
Best regards,
Trowa
Didn't find the answer you are looking for?
Ask a question
TrowaD
Feb 1, 2011 at 09:25 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Feb 1, 2011 at 09:25 AM
Hi Gunnar,
The strategy remains the same.
Take a look at the following file:
https://authentification.site/files/26620522/Gunnar.xls
Hope this helps.
Best regards,
Trowa
The strategy remains the same.
Take a look at the following file:
https://authentification.site/files/26620522/Gunnar.xls
Hope this helps.
Best regards,
Trowa
thanks for that, i might be able to use that
this is the table i am trying to use this in
https://authentification.site/files/26634931/v2011.xls
thanks
Gunnar
this is the table i am trying to use this in
https://authentification.site/files/26634931/v2011.xls
thanks
Gunnar
TrowaD
Feb 3, 2011 at 08:53 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Feb 3, 2011 at 08:53 AM
So case solved?