Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding amounts that meet specific criteria
In one tab of my spreadsheet, I have data setup as follows:
Dec 1 Dec 2 Dec 3 Dec 4 Dec 5 Ariz 1.00 2.00 2.00 1.00 0.00 Ala 5.00 0.00 3.00 2.00 4.00 Calif 3.00 0.00 2.00 5.00 6.00 Colo 5.00 2.00 0.00 3.00 5.00 In a seperate tab of the worksheet, I'd like to come up with a formula that will be able to list out any of the amounts that are greater than 0. For example, I'd like the second tab to list the following: Ariz Dec 1 1.00 Ariz Dec 2 2.00 Ariz Dec 3 2.00 Ariz Dec 4 1.00 Calif Dec 1 3.00 Calif Dec 3 2.00 In short, I'm looking for the second tab to list all the amounts individually, and omit any days that are zero...and also give me the ability to pick which states I want to see this data for. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
Finding amounts that sum to a number | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Finding count of unique number within a specific criteria? | Excel Worksheet Functions | |||
Formula that only adds numbers that meet specific criteria | Excel Discussion (Misc queries) |