list dates that correspond to employee ID numbers from a different sheet

[tlacloche]

Hello,

on sheet 1:
column A, i have dates. (e.g. 15/08/2013)
column B, i have employee ID numbers.

the only employees i have are employees 31, 32, and 33.
its common for a specific date and employee ID to be listed many times. (e.g. there are multiple 22/08/2013 and 32)

so on sheet 2:
column A, i have the employee IDs that i manually input. All 3 employees always work on each date. so column a will repeatedly be: 31,32,33

i would like column B to be the dates the employees are matched with on sheet 1.
so each employee will have the same date next to them.

[oeldere]

Post an example, without confidential formation.

Please also the desired (expected) result.

[tlacloche]

column b on sheet 2 is the desired result

[oeldere]

Why not remove duplicate on sheet 1?

Excel 2007 => data => remove duplicate

[tlacloche]

i dont understand

[tlacloche]

sheet 1 needs to be as it is.
it will always be random.

i need a formula in column B on sheet 2

[oeldere]

The example of the solution in #4.

See the attached file.

[tlacloche]

appreciate your effort mate, but youre miles off.

im looking for a formula for column B on sheet 2 which puts the date next to the employee ID numbers based on the data on sheet 1.
im not exactly sure what youve done here.

just looking for a simple formula...

[oeldere]

Please Login or Register  to view this content.

The result is what you asked for, so I don't understand your comment.

[oeldere]

Other solution,

with an pivot table.

[tlacloche]

again, thanks for the attempt but all i want is a formula.
i dont want any filters and i dont want a pivot table.

surely theres a formula that easily matches the date to the employee based on sheet 1. thats all.

[NS4Excel]

Is this correct? On a date somewhere around 8/15 you enter 31 in cell A1, 32 in cell A2, etc. Then you want the corresponding formulas in Col B to pull the first date in the list in Sheet 1. Then the next time you go into the file, you enter 31, 32, 33 in the next available cells in Col A. The corresponding formulas in Col B will be the next date associated to them that is greater than the 8/15 the formula gave you last time. And so on... Is this what you're trying to do? If not, please explain how the employee numbers appear in the file each time and in what increment you want the dates - is it next largest, next smallest, next date in the same order it appears in sheet1, etc.

[tlacloche]

Is this correct? On a date somewhere around 8/15 you enter 31 in cell A1, 32 in cell A2, etc. Then you want the corresponding formulas in Col B to pull the first date in the list in Sheet 1. Then the next time you go into the file, you enter 31, 32, 33 in the next available cells in Col A. The corresponding formulas in Col B will be the next date associated to them that is greater than the 8/15 the formula gave you last time. And so on... Is this what you're trying to do? If not, please explain how the employee numbers appear in the file each time and in what increment you want the dates - is it next largest, next smallest, next date in the same order it appears in sheet1, etc.

exactly that!!
ill manually input the employee numbers repeatedly (31,32,33,31,32,33,31,32...) in column A whilst column B has a formula that will pick up each date inserted in sheet 1

[NS4Excel]

The solution is in the attachment. The formula is an array formula so be sure to use Ctrl+Shift+Enter when entering the formula.
Nadine

[AlKey]

I'am not sure if this is exactly what you want but please take a look at the attached file.

As you keep adding info on Sheet1, the formulas on Sheet2 will pick up and calculate the number of occurrences of 31, 32 and 33 for each day.