| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return an array of values that are not zero/Null
Dear Excel experts
I have a workbook with Sheet X and Z. On Sheet X, there are these coloums Class Number of Students Male Female AA 10 3 7 YY ZZ 0 NN OO 20 5 15 (More data at a later date) How do I have Excel 2003 fill data on Sheet Z, so that it will Print out those Classes that have number of students (ignore zeros and null)? Result: Class Number of Students AA 10 OO 20 Please remember that Sheet Z will be added with more data as time goes by and I want SHeet Z be able to keep spitting out Classes that have students. Thank you for your advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return an array of values that are not zero/Null | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Array Pasted from One Worksheet Converts Null Values to Zeros | Excel Discussion (Misc queries) | |||
| Use array to return array of values | Excel Worksheet Functions | |||
| return a " " for null values | Excel Worksheet Functions | |||
Threaded Mode
