tagging / tracing / referencing duplicate values

J

jonpdavies

I have a workbook containing weekly numbers, the numbers are 6 digits in
length and may re-occur in the coming weeks data, or weeks in the
future.

i need to reference the data to the week it occurs.

for example i have number 100200300 and it occurs in week1, then again
in week2 and in week4.

how can i reference this number in excel 2003 to the week/s it occured?
i have been given a master sheet containing all data..and have cut it
down into several worksheets, with a worksheet for each week with all
the numbers which occred.

any ideas?

thanks in advance!

jon
 
Top