Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
first number in a column not equal to zero
I am have a table that has a row for each day of the month. As I enter the
inventory values for the day the last field in the row is the total for the day. What formula will give me the most last field in the totals column not equal to zero?for instance 427T Total 15,358 15,358 4,500 19,520 0 0 0 the formula would return 19520 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SEeing if a number in one column is in another column | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions |