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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
return a " " for null values | Excel Worksheet Functions |