View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tweacle[_5_] tweacle[_5_] is offline
external usenet poster
 
Posts: 1
Default How can I delete duplicated data


I have a workbook and I need to delete certain data. What it is if the
time difference in columns C and D is less than 2 mins I need that row
deleted and cells shifted up. It will always be in columns C and D and
will be numerous rows. Has anyone any idea as to how I can do this.
Dosent matter if it works up or down the workbook.

I.E if C and D 14 time diff is less than 2 mins I need that row deleted
and cells shifted up.

Can anyone help.

Thanks




--
tweacle