Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Directing cell contents to one of two cells dependent on its value | Excel Worksheet Functions | |||
directing cell contents dependent on its value | Excel Worksheet Functions | |||
Making cell contents dependent on another cell | Excel Discussion (Misc queries) | |||
Data Validation list dependent on contents of another cell | Excel Discussion (Misc queries) | |||
Change Cell Color dependent on Cell Contents | Excel Programming |