Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
Thanks in advance for your help.
we have the following sheet, its a sample sheet (have data approx 90 row and 100 column)
Excel 2010 32 bit
Need the following result
Excel 2010 32 bit
We have counted Total "Na" which are in continuation from bottom. After this we want to compare
Thanks in advance for your help.
we have the following sheet, its a sample sheet (have data approx 90 row and 100 column)
Excel 2010 32 bit
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Marks | Ram | Ravi | Rozi | Sunny | Ahmed |
2 | 45 | Na | Na | Na | Na | Na |
3 | 65 | Na | Na | Na | Na | Na |
4 | 25 | Yes | Yes | Yes | Yes | Yes |
5 | 35 | Na | Na | Na | Na | Na |
6 | 26 | Yes | Yes | Yes | Yes | Na |
7 | 98 | Na | Na | Na | Na | Na |
8 | 78 | Na | yes | Na | Na | Na |
9 | 15 | Na | Na | yes | Na | Na |
10 | 45 | Na | Na | Na | yes | Na |
Sheet: Sheet1 |
Need the following result
Excel 2010 32 bit
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Marks | Ram | Ravi | Rozi | Sunny | Ahmed |
2 | 45 | Na | Na | Na | Na | Na |
3 | 65 | Na | Na | Na | Na | Na |
4 | 25 | Yes | Yes | Yes | Yes | Yes |
5 | 35 | Na | Na | Na | Na | Na |
6 | 26 | Yes | Yes | Yes | Yes | Na |
7 | 98 | Na | Na | Na | Na | Na |
8 | 78 | Na | yes | Na | Na | Na |
9 | 15 | Na | Na | yes | Na | Na |
10 | 45 | Na | Na | Na | yes | Na |
11 | | | | | | |
12 | Total "Na" in continuation from bottom | 4 | 2 | 1 | | 6 |
13 | | |||||
14 | |
Sheet: Sheet1 |
We have counted Total "Na" which are in continuation from bottom. After this we want to compare