Stupid Question - How to use a filter to hide all figures which are less than -1 minus 1

ChrisHaley81

New Member
Joined
Jan 31, 2013
Messages
7
Hi,

I need help and I am sure I am being stupid but I have a filter on a spreadsheet, which I need to hide all figures which are less that -1 so I want it to show everything -0.9 or more. But whenever I do a filter and I put greater than or equal to or just greater than if never works. It just shows everything even things which are -77 or whatever.

Would really appreciate the help though! This report is doing my head in.

Thanks.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,448
Office Version
  1. 365
  2. 2010
1604530561695.png


Would show only -17 and -15

Use Greater Than option for the reverse.
 

ChrisHaley81

New Member
Joined
Jan 31, 2013
Messages
7
Hi,

Thanks I tried that but it doesn't work. I am trying to do it on a column with a formula in it. I also forgot to mention that its figures are percentages. (See attached) I've put the filter on as greater (because I want to hide anything that is less than -1. But I am still seeing what is meant to be hidden. Its the Actual Margin % that I am trying to filter.
 

Attachments

  • Untitled.png
    Untitled.png
    8.2 KB · Views: 1

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
I also forgot to mention that its figures are percentages.
That is very significant since -77% is actually -0.77 so it does fit the filter if you put > -1.
In your Numbers Filter you need to put "is greater than" -0.01 if you want to see values > -1%

1604565497873.png
 

Watch MrExcel Video

Forum statistics

Threads
1,123,456
Messages
5,601,772
Members
414,472
Latest member
Chris_1990

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top