How to add Value if any one cell in Column equals a specific number?

Hello there,

I'm trying to get a cell to show a specific number if any one cell on another tab contains that same number.

Let me show you:
Tab 1 has column A which is a running list that will contain numbers and sometimes there may be one of the same number or 3 of the same number.

Please Login or Register  to view this content.

Then in Tab 2, I want the to list the numbers in the rows of a running list, but only one of the numbers. Basically with the content in Column A above from tab 1 I want tab 2 to have a running list of rows like this:

Please Login or Register  to view this content.

Does that make sense?

I've tried If statements, =IF(ISNUMBER(SEARCH, SumProduct, etc but I can't get it to work.

Thanks so much,
Lorne

Thanks for the Post Ice.

I tried that out and it is showing the number 1 in my column, but how do I do the same thing to show number 2 in the row below it if there is number 2 in the column from the first sheet.

This is my formula:

Please Login or Register  to view this content.

Thanks,
Lorne

Ok so I dragged it and now it just shows zeros after it lists the last number. However it lists numbers in the column multiple times if it's in there multiple times. I am wanting Excel to look in colum C4:C100 on sheet 'Additional Services' and if there is the number 1 put it in B3 of 'Admin Summary'. Even if there is 20 1's in the column, I want it listed once. Then in B4, if there are any 2's I want it listed only once.

Does that make sense? See the attached workbook.

Thanks so much,
Lorne

Brilliant! Thanks so much, I knew it was a long complicated formula!

Thanks again,
Lorne

Ok one last question...

So now let's say I have a Phase code in column D on sheet 'Additional Services'. How do I input that code on my 'Admin Summary' Sheet if the Mod Number is 1? The Phase code will always be the same for all Mod numbers.

I attached the file again.

Thanks,
Lorne

I just figured it out...no idea how I did it, but tried some stuff from another post and it worked!

Please Login or Register  to view this content.

That code is taken from my actual spreadsheet, and not my template, but you get the idea.