excluding certain rows

  1. P

    Ranking values in Excel

    I am working with a large data set. The values are included in two different columns. A lot of the values have very little value to the overall report impact. What I want to do is identify the top 10 items by percentages that have a number greater than 50 in my top 10 table separate from the...
  2. L

    Can advanced filter use include and exclude criteria simulatenously?

    I'm trying to use an advanced filter to gather lines where the department number equals my criteria, but exclude lines with a specific account number. For example, say my data has lines where department equals 1500000001 but I don't want lines with that department where the account equals...
  3. P

    sorting data alphabetically in different excel pages

    Hi all, I am facing this problem. I have an inventory of chemical ordered that should be ordered in alphabetically . The sheets has different columns also. every about 16 rows i have to insert a row which contain the description of each single column (the one in bold in the example below)...

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