omit data

  1. N

    Reference all numerical values in a column EXCEPT for last value

    I have a sheet with a counter in column D and associated times in column E as numerical milliseconds (ex. 72996 or 72.9 seconds). I am trying to figure out a way to sum the values above a certain limit (900,000) on all rows with a time with the exception of the last row which always provides bad...
  2. walhir

    exclude value related to drop down list element

    hello everyone, I tried to find the answer for some time now googling and yahooing without any result. I'm guessing I couldn't figure the proper search term :) Anyway my question is: I'm trying to sum a column of numbers, the numbers are calculated depending on the drop down list choice in...
  3. G

    Pivots & Slicers - hiding data (without filters!) v2010

    Hi, does anyone have any ideas on how to omit data from a pivot table (and therefore the slicers based on the pivot) *without* using a filter on the pivot table....as that does not work (i.e. this causes a filter to be made on the slicer, so the data can be viewed if someone changes the filter -...

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
Back
Top