Counting same numbers in different columns.

[dixon1983]

Hi,
I get a report each day that has an unique field.

Each day I copy the column that holds the unique field into a master sheet. Each column in this sheet is labelled with the corresponding date.

I would like to see how long each ID appears on the report.

Is there a way to do a count of how many columns each ID appears in?

Ideally I would like a report page which lists the ID and how many days (columns) this was on the report for. (or even returning the start date and the last date it was on the report - im probably pushing my luck here tho!)

Hope someone can help.

Thanks

 

[dixon1983]

Hi Ben,
That first fix has sorted the problem. It works fine now.

Thanks for all your help and time spent. Its very much appreciated.

Chris