plums

I have 50 odd tabs (labels by weekly date range (1st -7th etc) with data in unheaded columns adjacant to a text column on the left hand side, which is the same on each tab. Withing each text column (V) on each tab , the word plums could be written. I want to pull into a table all the...

I am trying to setup an IF statement using a VLOOKUP to find a value in a range greater than zero and return that column's header label. I have a list of names and I am trying to find the first column that has an actual dollar amount instead of blank and then return that column's header label...

Hi If I have this table in cells A1 to C4 Apples 1 yes Pears 1 no Oranges 3 no Plums 4 yes want to count fruit which have a "1" in col B and a "yes" or "no" in col C using COUNTIFS and an array to create an OR criteria So like this:

Hi, I'm trying to work out a formula in which expands out a list based on 2 columns. Column A is the number of fruit, column B is the fruit and I want in column C a list of all the fruit. e.g. <colgroup><col><col span="2"></colgroup><tbody> Number of Fruit Fruit Result: 2 Orange Orange...