Thread: Excel Help
View Single Post
  #1 (permalink)  
Old 08-08-2007, 02:11 PM
ssmacc ssmacc is offline
Member

Thanks: 30
Thanked 20 Times in 13 Posts
 
Join Date: Aug 2006
Location: Macclesfield
Age: 35
Gallery: 0
Posts: 196
Points: 13,955.72
Bank: 0.00
Total Points: 13,955.72
Donate
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 3
ssmacc is on a distinguished road
This member is the original thread starter. Excel Help
I have one spreadsheet tab (sheet 1) with unique Subject ID’s against a date. I also have another sheet with multiple Subject ID’s and no dates (Sheet 2). Is there a way of mapping the dates from one spreadsheet sheet to the other? As I’ve not explained this very well I’ve included an example below!
Sheet 1
Subject_________Con Date
E0001001______24/11/2004
E0001004______01/02/2005
E0001006 ______05/02/2006
Sheet 2
Subject_________Con Date
E0001001
E0001001
E0001004
E0001004
E0001006
E0001006
In this case I would like the 'Con Date' column to be completed with repeats to match the Subject column
Thanks in advance
Reply With Quote
 
[Output: 14.13 Kb. compressed to 13.34 Kb. by saving 0.79 Kb. (5.62%)]