equal

Hi, Thanks in advance, i have three columns and want to compare them, conditions are 1- If Coloumn 1 & Coloumn 2 are equal - Delete entire row 2- If Coloumn 2 & Coloumn 3 are equal - Delete entire row 3- If Coloumn 1 & Coloumn 3 are equal - Delete entire row please provide any VBA or code...

Good Days, Please advise a vba code to process the duplicates values clean task, If word/text in Cell A1 is equal to Cell B2 ,then Cell B2.clearcontents ...... If word/text in Cell A65536 is equal to Cell B65536, then Cell B65536.clearcontents Else, no change Thank you very much!

Hello everyone, I could use some help in finding last used rows. If C1 is >0, I need the last used row in column C to equal last used row in column E. thanks

Hi gurus, I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively. Then, they will run through a set of database (can't reveal here due to confidential purposes) to...

Hi I need assistance with an if statement formula that looks at a row and if 4 or more of the cells in that row range that spans across multiple columns are equal to a value then the statement is true. Attached is a screenshot of the data. Need the formula to go into N4 - if the value of 4 or...

I have the following formula in cell AC4 =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,AB4) The formula works. However when I changed formula to =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,>=AB4) I get an error message. I tried this...

I have a variable of type Double that is not always the value that it should be, and I can't figure out why. Here's some of the code. TotalOnForm = Val(Replace(.Range("AC41").Value, ",", "")) TotalNotAssigned = TotalOnForm - TotalsInArray (There is other code that assigns the value to...

Hi, it seems to be a small thing but can’t wrap my mind to it. I have 2 columns. One has a formula resulting in a number. The other one has plain numbers. I need to use 3 colors for Greater than (green) Smaller than (red) Equal to (yellow) I know to use =value(b1)=value(a1) But where...

Hi all, I have a field of integers residing in cells B3:B26 (randomly ranging from 2 to 22) I have made an array formula to return a list of integers that are greater than or equal to 10 (in numerical ascending order) However when I try to do the same but with an AND formula to get numbers...

I have a table with columns for YEAR, CATEGORY (food, beverage, rental, misc, av, service charge), STATUS (actual, forecast, OTB), RMNOTB (a #) and REVENUE $. I also have a named range for BUDGET YEAR (budget_year). I need a formula to add the revenue amounts then divide by # of RMN OTB IF...

Good morning, I am working on a sheet and I am rusty on my Excel formulas. I have a column that needs to auto fill based on certain criteria. If a number typed in column B is 130,131,132,133,134,135 then column C needs to equal 25.8, if the number typed in column B is 136,137,138,139 then...

Hi all, I got below table where I want to extract the first date in the top row under the condition that the green row is not equal to zero anymore. Which formula would you advise to use? Thanks!

I have Excel 16 on MacBook I need to be able to search 2 columns and if there is a match to move the corresponding value in a third column to a fourth column Example If column A6 has a value equal to column B8 then I want to move the value in column C8 to column D8

I need a formula to find out the following: if D2=B2 return nothing; if D2 is different than B2, return D2; AND if #D2 is blank, return blank.

Hi guys, hope you can help me out. I am trying to build an emergency fund simulation. Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to F8 on "SALN" tab. Recommended funding multiplies the value of the monthly expenses by 3 and 6...

Hello, i'm after a way to change a cells color based on the value of that cell in relation to the value in an adjoining cell. essentially what the actual value is in relation to the target value. if the actual value cell is lower than the target value cell then i want it to turn red, and green...

Hey guys, I need a help. I need hep with a IF statement. conditions are: If cell D43 is greater than or equal to 1, then i want it to show text "san" if cell D43 is in negative number and is greater than or equal to -1, then i want it to show text "san" If cell D43="", then "" I did this...

Hi all, The below code works, up untill the last "<>Alternatives" =SUMPRODUCT(SUMIFS(Aladdin_notional_weight,Aladdin_country,A4,Aladdin_portfolio_full_name,"<>Alternatives")) Are named ranges not compatible with the "does not equal" function? Any work arounds?

Hello. Was wondering if someone might help me with an If, TRUE statement for a range? I'd like the range to be 0-60. The other thing is that the lower value has to be equal to or greater than 0, and the higher value has to be less than or equal to 60.

I am trying to set my string variable fasname to equal the value of the next non-blank cell to the right of the cell that is equal to my other string variable fasacct. Here's what I've tried: fasname = hws.UsedRange.Find(fasacct).Offset(0, xlToRight).Value I've tested by replacing...