highlighting matching cells

**stevesunfold** · 04-11-2008, 04:56 PM

hi guys

im looking for a formula that will find matching dates in column a and then i want to see if column b has a matching time in it

all help gratefully received

**stevesunfold** · 04-11-2008, 05:02 PM

ps

column a is a date
column b is a time with a track

**oldchippy** · 04-11-2008, 05:12 PM

Hi,

Can you post a zipped sample of your data?

**stevesunfold** · 04-11-2008, 05:39 PM

cheers chippy

try here mate http://www.savefile.com/files/1498659

**oldchippy** · 04-11-2008, 06:00 PM

Hi,

There appears to be 20 matching races, there is a formula in column A

=IF(AND(B2=B3,C2=C3),"Match","") that finds the matches between the dates and times of the race.

In C2 this formula extracts the time

=TIMEVALUE(LEFT(D2,4))

**stevesunfold** · 04-11-2008, 06:09 PM

amazing chippy

thanks very much

how can i copy and paste data from a website straight into excel as it is ie if its 1st / 4 which means 1st of 4 rather than 1st april

cheers very much

**oldchippy** · 04-11-2008, 06:22 PM

Hi,

If the format is exactly like you say, then this works

**stevesunfold** · 04-11-2008, 06:27 PM

should have explained myself better really chippy

if i copy and paste from a site for example

8 Apr 2008 2:40 Lingfield MOKSI 7-2 4/12 -9529 -13606

on excel if i just copy it straight in it comes up

08-Apr-08 2:40:00 AM 2:40 Lingfield MOKSI 07-Feb 04-Dec -9529 -13606

odds were 7/2 and it shows 07 - feb and it finished 4th of 12 and ot says 04-dec ive tried formatting cells before i paste but must be doing something wrong

**oldchippy** · 04-11-2008, 06:31 PM

Can you point me to the web page?

**stevesunfold** · 04-11-2008, 06:36 PM

well basically its anything like the racing post or this one

http://81.109.253.228/web1/db3/dbaccess.php

**oldchippy** · 04-11-2008, 06:58 PM

This is the way to pull information from a website in to Excel so that it keeps the format displayed like the web page.

http://www.mrexcel.com/tip103.shtml