How do I filter rows with negative values

Microsoft Excel 010 - complete package
October 16, 2010 at 23:04:31
Specs: Windows XP


I have a record with more than 200 rows. It is displayed in column C. Now, i want filter only and RETAIN records with negative values (formatted to be inside a parenthesis), while those with values zero and greater are to be deleted out. By the way, this is related to a payroll data where the negative values represent the time to be deducted. So how do i do that in excel? Thanks for the advice.


See More: How do I filter rows with negative values

Report •

October 17, 2010 at 08:51:14
Set up a table like this:

1    Value    
2    ="<0"   (This will display as <0)
4    Value
5      1
6      9
7      3
8      4
9     (4) 
10    (7)    
11     6   
12    (7)
13     0    
14    (4) 

Data...Advanced Filter

Choose either:

Filter the list, in place
Copy to another location

List Range: A4:A14
Criteria Range: A1:A2
Copy to: Optional, based on the choice you made above.

Report •
Related Solutions

Ask Question