missing

The green section of my formula is counting blanks as Tier 4 and some below the mark of Tier 1 are showing Tier 4. Can anyone see an obvious error i may be missing? =IF(AND($D5>=$N$6,$E5>=$N$7,$F5>=$N$8,$G8>=$N$9),"Tier 4",IF(AND($D5>=$M$6,$E5>=$M$7,$F5>=$M$8,$G5>=$M$9),"Tier...

Hello, I built the below array formula for a spreadsheet that we use at the office (column B). ={ IFERROR(VLOOKUP(INDEX($E$1:$E$16,MATCH(TRUE,ISNUMBER(FIND($E$1:$E$16,A1,2)),0),1),$E$1:$F$16,2,0),"N/A")} My concern is that, since the file will be used by many not-so-Excel savvy users...

A few times I've had this error when it always seems the case that I have a For statement. To make sure I'm not missing something I've stripped the code down to the bare bones but still getting it with the following code: Sub mysearch() Dim v As String, i As Integer For i = 1 To 10 v =...

Hi all, what am i missing, =LOOKUP(B5,{((>=0.36,<1.44),(>=1.44,<3.6),(>=3.6,<7.2),(>=7.2,<14.4),(>=14.4,<21.6))},{"10.5","10.2","9.9","9.3","8.7"}) basically first one is = if B5 >=0.36 and <1.44 then =10.5 and so on. please help, its for work. Thanks

Hi, I am new here and could not find if it was posted again but I want to compare data from 3 different Excel files so as to find whether the 3 different sheets contain the same data or if some are missing. I am using the lookup function for now but I would like something more sophisticated...

Hi Experts Got another problem to resolve I want to filter my records for dates before 10 yrs from today. So I have written following code, which is not working. There must be some technical thing, I'm missing upon. Further, my system use date as dd/mm/yyyy Please help Thanks...

Hi, I just noticed something about assigning worksheet values to vba variables. age1 = Worksheets("Inputs").Range("Age") is the same as age1 = Worksheets("Inputs").Range("Age").value I guess if the .value is missing it uses the default? Doesn't it seem better to throw an error in this...

Hi, I have just upgraded to Excel 2016 (64bit version) and the conditional column feature is missing from the Query Editor/Add Column/General ribbon. I only have Add Custom Column, Add Index Colum and Duplicate Column. Has anyone else encountered this problem?

I do a lot of automation between Excel and Access. Unfortunately, I’ve been switched to Excel 2016 and am now missing the “Access Developer Extensions Type Library” reference. Below is just a sample piece of code I would use that is now puking due to the missing reference. Has anyone found a...

Using Excel 2000 Hi, I want to find among each row in C:F column what is unique or missing, results in the coloums H:I Example data <colgroup><col><col span="2"><col span="4"><col><col span="2"><col></colgroup><tbody> A B C D E F G H I J 1 2 3...

Hello helpful souls, I have just signed up here to learn the wonders of Microsoft Excel and a complete total noob. I just want to ask for help in shortening my formula: =IF(D10="Yes",C10)+IF(D11="Yes",C11)+IF(D12="Yes",C12)+IF(D13="Yes",C13)+IF(D14="Yes",C14)+IF(D15="Yes",C15) and so...

The problem with the missing formula in a cell has been haunting me for the last 2 months. I have heard of all of the possible causes but none of the solutions have helped me. I wrote a letter to Microsoft asking that some resources be put on the issue. It would seem that you could have the...

I've been trying to google every combo I can think of but I'm not able to find what I'm looking for, I believe it's because I'm not sure how to ask. I have two sheets. One has data with First Name, Last Name, and Account Numbers. The Second sheet has First NAme, Last Name but missing account...

I have a excel work sheet that I exported. in column "D" i have cost codes. for example 00-105, 00-600. some of them do not have a dash. for example 01600, 05300. What would be the fasted was in adding a "-" when missing?

Hello all A member of the Excel forum kindly helped with this code and I want to expand it to saying. Number of supplier email missing Proceed Yes or No if yes then action my code if no then end function With Sheets("Data") LastRow = .Range("B" & Rows.Count).End(xlUp).Row Set...

I can't figure out what I am doing wrong. I thought if you declared a variable as public, it could be used anywhere within the workbook. Not so in this case because none of these public variables declared will pass their value. So what I am doing wrong? Any help will be greatly appreciated...

I have a formula that obtains it values from a userform and a spreadsheet. The problem is if any value is missing from either the userform or mainly the spreadsheet, I should get a Runtime-error 11 'Division by zero, which I do, as expected. So I wrote this little snippet of code, within a Sub...

I currently have a few columns working off of a pivot. The pivot has a missing dimension under one year, and the calculation is already fairly complex. What is the easiest way to add a double check for a missing Tender to Ship Group"? =+IF($A29="Grand Total",SUM(AA$11:AA28), IF($A29="",""...

Hi Everyone - I initially missed a value when I was typing into my data set. I then ran my pivot table and noticed it was missing. I copy pasted my new data with my correction and could see that it was there. I ran my pivot table again and it was still missing. I filtered to see if it was...

Hello All, When I have a blank cell with no data, I want a dash to display...I am having trouble with the formula... The cell is G44, so I thought the formula would look like this: =IF(G44=0, "-") But a zero is displaying not a dash.... What am I missing? overlooking? Manny