Akashwani
Well-known Member
- Joined
- Mar 14, 2009
- Messages
- 2,911
Hi,
I'm in the process of compiling some sample data and I have hit a mental wall with this situation!
Sample Data....
In this example the Result should be 7, as there are 7 cells in the row that are populated by numbers, any other data needs to be ignored.
Any suggestions?
Thanks
Ak
I'm in the process of compiling some sample data and I have hit a mental wall with this situation!
Sample Data....
Excel Workbook | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Data | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Cells Populated | ||||
2 | ABC123 | 99999 | 99998 | X | X | X | X | X | X | 2 | ||||
3 | ABC124 | 99996 | 99997 | 99998 | X | X | X | X | X | 3 | ||||
4 | ABC125 | 99991 | 99992 | 99993 | 99994 | 99995 | 99996 | 99997 | 7 | |||||
5 | ABC126 | 99991 | 99992 | 99993 | 99994 | 4 | ||||||||
6 | ||||||||||||||
7 | Lookup | Count Result | ||||||||||||
8 | ABC125 | |||||||||||||
9 | ||||||||||||||
Sheet5 |
In this example the Result should be 7, as there are 7 cells in the row that are populated by numbers, any other data needs to be ignored.
Any suggestions?
Thanks
Ak