does not equal

  1. K

    Sumifs - does not equal to an array

    Hi, I hope an you experts can help. If I have phrased the question poorly, please ask for more information. This is my first post and I'm a newb at excel. I need to create a sumifs formula (unless you can advise an alternative) which will allow me to sum a column which does not have the same...
  2. kylerisi

    Extracting a list of values based on a multiple criteria

    Hi team. We have a survey which asks our customers a series of questions in the form of radio options. At the end of the survey the customer has the option to input a free text response. This data exists as RAW CSV data and I am trying to extract all the user's free text answers from the...
  3. H

    Conditional Formatting - Highlight when cell does not match a list of values

    Hello, I've tried some solutions I found on other posts on this board but I just cannot get it to work on my spreadsheet! In column E, I have a product name. In column H, I have a client name. I want all the product names for client A to be in blue, the product names for client b to be in...
  4. N

    Index, Match and Does Not Equal To

    Hi all, Just wondering if anyone knows how to return a value in index and match, that is not equal to a value in another cell or range of cells. My current formula is: =INDEX($C$6:$C$9,MATCH($B$27,$D$6:$D$9,0),) I need to somehow embed a <> function in here. I have researched lookup, match...
  5. B

    VBA- Does not equal IF Statement

    Hi I have the following code to either add, subtract, multiply or divide two numbers Private Sub Cmd_Test_Click() Worksheets("Sheet1").Range("C9") = "1st Value" Worksheets("Sheet1").Range("D9") = "2nd Value" Worksheets("Sheet1").Range("E9") = "Operation" Worksheets("Sheet1").Range("F9") =...
  6. melewie

    VBA if value isn't in a range

    Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m having trouble with a piece of code to identify if the value of a cell is a value in a range.<o:p></o:p> I have a range 'Country_Code_Rng' which contains a list of countries I want...
  7. The_Rock

    SUMPRODUCT with OR function

    Hi Guys I've got a sumproduct formula, and saw from another post how to add in an OR function. Its working but what I need it to do is to exclude if it meets the OR function: =SUMPRODUCT((rABReseller="Non-AB Reseller")*(EPP_Rev_Strm="New...

Watch MrExcel Video

This Week's Hot Topics

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