Hi All,

I am using Excel 2007 for Windows. I would like a flexible (single) formula based solution for the following:

My data is numeric, in a tabular format spanning many columns and rows - the number of rows will continue to increase. I have numeric labels in row 3 spanning the width of my table.
The data starts in column "G" row 4 and ends in column "BK". The cells within the table are
populated with a formula which returns either a numeric value or empty text ("") showing a blank cell.

I would like to find many different duplicate values in my table and have their column number
(relative to my table starting in column "G") returned down a single column in separate cells,
starting with the oldest data in row 4 and working across the columns and down.

I would like to use an input cell in the formula to cater for the changing criteria value that I look for.

Sample extract of table: included as Excel 2007 file attachment - Book3.xlsx
NB: Returning the column number (relative to my table) where the criteria is found.

Clarification for how the expected results should be returned:
Use a single column and return each value on a separate row; for example,
looking for multiple criteria with a value of 0 (zero), the expected results should be returned down a single column in separate cells:

column "BZ4" = 3
column "BZ5" = 5
column "BZ6" = 14
column "BZ7" = 22
column "BZ8" = 3
column "BZ9" =16

I have used commas purely as a means to separate each numerical value - it should not be read as a string.

Example of criteria to look for:
Looking for multiple criteria with a value of 0 (zero)

Expected Results (returned down a single column in separate cells):
3,5,14,22,3,16

Example of criteria to look for:
Looking for multiple criteria with a value of 1 (one)

Expected Results (returned down a single column in separate cells):
6,12,15,16,9,2,17,18

Example of criteria to look for:
Looking for multiple criteria with a value of 10 (ten)

Expected Results (returned down a single column in separate cells):
4,15

Hope you can help.

Thank you,
Sam