LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Deleting rows dependent upon cell contents

Hi,

I have a spreadsheet of 5 columns and 65536 rows, the columns a date,
time, flow rate m3/hr, power kWh, pressure bar. Some of the rows have
redundent information when the unit is turned off so in the kWh column I will
have values of 0. I want to delete these rows from the data. What is the
easiest way to do this? I cannot be bothered going down all the rows and
finding the instances where the kWh is 0 on an individual basis.
--
daedalus1
 
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
Directing cell contents to one of two cells dependent on its value Debi Excel Worksheet Functions 1 April 15th 10 03:13 PM
directing cell contents dependent on its value Debi Excel Worksheet Functions 2 April 15th 10 09:58 AM
Making cell contents dependent on another cell Jen Excel Discussion (Misc queries) 4 February 22nd 08 07:37 PM
Data Validation list dependent on contents of another cell Scorer150 Excel Discussion (Misc queries) 2 February 7th 08 12:13 AM
Change Cell Color dependent on Cell Contents Bill Excel Programming 4 March 15th 05 04:33 PM


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

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

About Us

"It's about Microsoft Excel"