Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 30th 08, 07:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default Delete row 1 based on condition in cell on row 2

I need to delete the row above if the value $c2 is less 2 minutes (0:02:00)

Thanks for your help - Ian McDonald
--
602 952 2526

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to delete rows based on a condition Darrilyn Excel Worksheet Functions 1 September 6th 07 12:12 AM
lock cell based on a condition Amanda Excel Worksheet Functions 22 June 25th 07 07:53 PM
How to delete a data row based on a condition wmc New Users to Excel 4 April 18th 07 02:40 PM
Condition based on cell colour Richhall Excel Worksheet Functions 2 March 25th 07 04:23 PM
Is there a way to delete a cell value based on a condition? Peanut Excel Discussion (Misc queries) 2 October 2nd 06 09:55 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017