Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find first non-zero value in a vertical list of numbers
Looking for a formaula that finds the first non-zero value in a
vertical list of numbers. The zero values will always precede a number greater than zero. January 0 0 February 0 0 March 0 0 April 580 0 May 1000 1050 June 235 850 July 1032 1000 August 654 2635 September 6854 2654 October 987 9852 November 3214 1568 December 605 6387 the answer to above should be 580 for the first column and 1050 for the second column. THANK YOU FOR ANY HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the last non-zero value in a list of numbers | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | New Users to Excel | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Find in list function | New Users to Excel |