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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top