| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column of numbers, how do I return the last non-zero number?
That is the bottom-most non-zero number?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a column of numbers, how do I return the last non-zero number?
Hi!
In a column of numbers Try this: =LOOKUP(2,1/(A1:A10<0),A1:A10) Biff "ACEACE" wrote in message ... That is the bottom-most non-zero number? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a column of numbers, how do I return the last non-zero numb
That seems to return only the value in A10.........
Perhaps this........ =SMALL(A1:A10,COUNTIF(A1:A10,0)+1) Vaya con Dios, Chuck, CABGx3 "Biff" wrote: Hi! In a column of numbers Try this: =LOOKUP(2,1/(A1:A10<0),A1:A10) Biff "ACEACE" wrote in message ... That is the bottom-most non-zero number? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a column of numbers, how do I return the last non-zero numb
Screencap:
http://img519.imageshack.us/img519/1...nonzero6xy.jpg Biff "CLR" wrote in message ... That seems to return only the value in A10......... Perhaps this........ =SMALL(A1:A10,COUNTIF(A1:A10,0)+1) Vaya con Dios, Chuck, CABGx3 "Biff" wrote: Hi! In a column of numbers Try this: =LOOKUP(2,1/(A1:A10<0),A1:A10) Biff "ACEACE" wrote in message ... That is the bottom-most non-zero number? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a column of numbers, how do I return the last non-zero numb
My apology.......I kept reading "the bottom-most non-zero number" as being
"the smallest non-zero number"......... Vaya con Dios, Chuck, CABGx3 "Biff" wrote: Screencap: http://img519.imageshack.us/img519/1...nonzero6xy.jpg Biff "CLR" wrote in message ... That seems to return only the value in A10......... Perhaps this........ =SMALL(A1:A10,COUNTIF(A1:A10,0)+1) Vaya con Dios, Chuck, CABGx3 "Biff" wrote: Hi! In a column of numbers Try this: =LOOKUP(2,1/(A1:A10<0),A1:A10) Biff "ACEACE" wrote in message ... That is the bottom-most non-zero number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
| SEeing if a number in one column is in another column | Excel Discussion (Misc queries) | |||
| How do I extract 3 numbers inside a longer number to another column ? | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Linear Mode
