Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning row headings for values greater than 0
Hi,
I have a table of data that runs over several months in columns B to D and I have different types of fruit in rows 2 to 4 e.g apples, pears and so on. Under each month would be the number of that fruit sold that month:- Jan Feb Mar Apples 0 2 3 Pears 5 0 5 Oranges 7 0 6 What I need excel to do is just return the types of fruit where the value is greater than 0 in a particular month. So if I wanted to know what fruit sold in Jan it would return:- Pears Oranges The table of data i actually have has 51 "types of fruit" and 28 "months" but i only need excel to look at one "month" at a time. Hopes this makes sense and any help you can provide is much appreciated as i've hit a wall with this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greater than less than arguement returning value when text inputte | Excel Discussion (Misc queries) | |||
Sum values greater than x and less than y in a column | Excel Discussion (Misc queries) | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
How can I count values greater than and less than certain values? | Excel Worksheet Functions |