Hi everyone,

So I have created this advanced spreadsheet for the nursery I am working for. This is part of a market analysis for the business plant I am writing.

I have a list of over 1000 plants in the A column, followed by 8 nurseries (including the one I am working for) in Columns D to K. Each of those columns has a unique fill color and an X in the cell, with the text colored the same as the fill color. This X I am using as a cell reference for the plant name and the nursery it's available from to make the other formulas I have running.

I already have some cool formulas running showing the tally of plants and market percent for entire nurseries, plant types, and even plant genus. These statistics I will be using to write in the business plan to show our current and potential markets.

What I am trying to do now is develop a formula that will list only the plants that are found in all of the 8 nurseries (e.g. Themeda australis, which all nurseries grow). I believe that I should be using a combination of Index and Match functions, but I cannot seem to get the right combination going to make it work.

I would be greatly appreciative of any help.

Many thanks in advance,

Richard.