does not equal

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

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

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

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

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") =...

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

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