Home/ Questions/Q 11138
Next
Answered
computing
  • 4
Asked: 2021-12-06T23:32:12+00:00 In:

How Do I Filter Rows With Negative Values

  • 4

Hi,

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.

rian

Share

    1 Answer

    1. Best Answer
      Set up a table like this:

             A        
1    Value    
2    ="<0"   (This will display as <0)
3        
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
      or
      Copy to another location

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

      • 0