Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,180
- Office Version
- 365
- 2019
- Platform
- Windows
Question 1:
The message is a continuation from the link below. I want to thank Andrew for answering that question but now I need to put an x at the end if it meets the condition (like in the example below) the boss wants this for counting. For those who are new to this post, If the is number before and after a blank cell then the cell should get an x in the row.
http://www.mrexcel.com/forum/showthread.php?t=537952
Question 2:
If there a way using MMULT to get a total count in a cell based on all rows, for the example below it would be 4!
Thanks in advance Stephen
The message is a continuation from the link below. I want to thank Andrew for answering that question but now I need to put an x at the end if it meets the condition (like in the example below) the boss wants this for counting. For those who are new to this post, If the is number before and after a blank cell then the cell should get an x in the row.
http://www.mrexcel.com/forum/showthread.php?t=537952
Question 2:
If there a way using MMULT to get a total count in a cell based on all rows, for the example below it would be 4!
Thanks in advance Stephen
Book1 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | 3/7 | 3/8 | 3/9 | 3/10 | 3/11 | 3/14 | 3/15 | 3/16 | 3/17 | 3/18 | 3/21 | 3/22 | ||||||||
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||
3 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
4 | 30 | 30 | 30 | 30 | 30 | 54 | 54 | x | ||||||||||||
5 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
6 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
7 | 5 | |||||||||||||||||||
8 | 22 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | x | ||||||||
9 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
10 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||
11 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
12 | 22 | 22 | ||||||||||||||||||
13 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||
14 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
15 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
16 | 10 | 10 | 10 | 10 | 10 | 10 | ||||||||||||||
17 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | x | ||||||||
18 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | ||||||||||
19 | 10 | |||||||||||||||||||
20 | 20 | |||||||||||||||||||
21 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | 101 | |||||||||
22 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | ||||||||||||
23 | 25 | 25 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | x | ||||||||
Sheet1 |