| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding cell value from top of a list greater than 0
I am trying to find a formula which will return a value from a list which is
greater than 0. For example, from cell AC48:AC52, I need the first number greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20, AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding cell value from top of a list greater than 0
Joker,
Array enter (enter using Ctrl-Shift-Enter) =INDEX(AC:AC,MIN(IF(AC48:AC520,ROW(AC48:AC52)))) HTH, Bernie MS Excel MVP "Joker" wrote in message ... I am trying to find a formula which will return a value from a list which is greater than 0. For example, from cell AC48:AC52, I need the first number greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20, AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding cell value from top of a list greater than 0
You can use the AutoFilter. DataFilterAutofilter. Autofilter places
arrows at the top of your column. Click on the arrow at the top of your column and select "custom" and select greater than on the left and type 0 on the right. One caution though, Autofilter only works on the first 1000 rows. "Joker" wrote: I am trying to find a formula which will return a value from a list which is greater than 0. For example, from cell AC48:AC52, I need the first number greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20, AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List that has formatting of cell range Font ect. | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
| How do I set up drop-down list for a cell when the list is in ano. | Excel Discussion (Misc queries) | |||
Linear Mode
