exclude blanks

  1. iggydarsa

    RANK.EQ excluding Blanks

    I have a table (tbl) with columns of Site and Sale I want to Rank the Sales where Site is not blank. On Column C (Rank) I using =RANK.EQ([@Sale], [Sale], 1) but not sure how to exclude the Site where it is blank so that the resultset would be like Column D (Expected) Site Sale Rank Expected...
  2. W

    Combining Filter function with Indirect/Concatenate to look up from another worksheet

    Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...
  3. G

    Average if but exclude rows with today's date

    Hi All, I want to average the dollar amounts in a column but I need to exclude those columns that have a zero dollar value and I also need to exclude rows that have today's date. I am lost as to how to do this and any advice would be hugely appreciated! A B C...
  4. R

    Index and Match formula to exclude blanks

    Index and match formula but need it to exclude the blanks Example 1 A B C D E F G 2 Name 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 3 a...
  5. L

    Count values based on criteria with no duplicates

    Apologies if this has been answered elsewhere but I cannot find it. I need an excel formula to count text values (that may include blanks) in one column based on criteria from an adjacent column. I only want to count duplicates once and exclude blanks. Eg if cells in column contain "x", count...

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