Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>
Row\Col | A | B | C | D | E | F |
---|---|---|---|---|---|---|
1 | 712345678 | |||||
2 | 712345678 | |||||
3 | 123745678 | |||||
4 | 8234756 | |||||
5 | ||||||
6 | 8234756 | |||||
7 | 712345 | |||||
8 | LK | |||||
9 | 7123 | |||||
10 | Y712345 | |||||
11 | ||||||
12 | ||||||
13 | Answer: | |||||
14 | No. of items (that are numbers) that start with digit 7: | 3 | ||||
15 | No. of items (that are text) that start with digit 7: | 1 | ||||
16 | ||||||
17 | Please help me on this, (preferably, worksheet function.) Thanks. |
<tbody>
</tbody>
Sheet: Sheet3 |
<tbody>
</tbody>