transfer data to a different format

[Joey]

Hi all

Please help!!!

Is it possible to transfer data from one sheet to another when th
sheets contain data refering to dates in accompanying cells.
The data transfered should appear as a "1" alongside the date and nam
of the person it's regarding.

Example:
Worksheet 1

If cell A1 = 01/02/04 and B1 = John Doe
If cell A2 = 03/02/04 and B2 = Micky
If cell A3 = 04/02/04 and B3 = Donald

Then Worksheet 2

A2 = John Doe and B1 = 01/02/04 and B2 = 1
A3 = Micky and C1 = 03/02/04 and C3 = 1
A4 = Donald and D1 = 04/02/04 and D4 = 1

Thankyou
Joe

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER) in B2
=IF(ISNA(MATCH(1,('sheet1'!$A$1:$A$10=$A2)*('sheet1'!$B$1:$B$10=B$1),0)
),"",1)
and copy down/to the right