incorrect

I have the below formula that am trying to paste but for some reason is not taking =, what am i doing incorrect =AND([@Date]>=Calculation!$D$2,[@Date]<Calculation!$D$2+7) See sample link the sheet is called Raw Data but is calling from calculation...

I am trying to determine the number of active months for personnel on a rolling 12 month basis. This is the formula I'm currently using but am getting an incorrect result value. I'm new to offset so I know I must be missing something simple. =COUNTA(OFFSET(D2,0,COUNTA(D2:AA2),1,-12))

I'm trying to calculate elapsed time in hours from a start date/time to an end date/time. Work hours are M-F, 6AM - 6PM. Below is the formula I'm using. =(NETWORKDAYS(B3,C3)-1)*("18:00"-"6:00")+MOD(C3,1)-MOD(B3,1) The problem I'm having is if the start day is after business hours or on...

Hi Everyone. I am trying to create an error inclusive training in excel for my research, and would love your help to collect as many beginners errors as possible- those you see the most often - whether it is with formulas, functions or else. The below list is what I compiled based on online...

Can someone tell me why this formula is returning "FALSE" opposed to "YES" or "NO" ? I have a feeling the brackets are incorrect =IF(AND(($F$2>=A4),($C$2<=B4)),OR(IF(AND(($F$2>=A5),($C$2<=B5)),"YES","NO")))

I'm doing a simple vlookup between two tabs in the same spreadsheet. Many returned values have #n/a but when I search the second tab they appear in the table. Some of the values are correct and some even return an incorrect value. Please help. I've had to manually lookup over 100 values in...

I have a pretty complicated sheet that is calculating the average for the last 3 days, 6, 12 and 24 days. I have noticed that the answers fro 3 & 6 days are correct, but the 12 & 24 days are not correct. =AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer...

I have an excel template (Productivity Tracker), where we have to put specific request number based on various task. For e.g. for task MDC Account Creation, request number should start with "A" follow by seven digits(numbers) ex A9827366, total length 8. So, for each different unique task I have...

Hi everyone, My issue is that every time I try to open a password-encrypted file, Excel automatically populates the password field with a password I used in the past for other files (i.e. an incorrect password)...As a result, I get an error... Does anyone know if I can disable this automated...

<tbody> Name Org Day Start End Minutes Incorrect Person 1 A Monday 5:05 pm 6:00 pm 0:55 0:25 Person 2 B Tuesday 5:05 pm 5:15 pm 0:10 0:10 Person 3 C Saturday 6:15 am 2:50 pm 8:35 0:00 </tbody> Hello all, Hoping someone can provide some assistance with...

Hi all The below formula works but i need this to work up to the last row in K when i drag the formula down to autofill the formula works for 1st 10 cells then i receive a #VALUE ! i can put this in to array but it the locks all cells to k3 and give me the incorrect calculation. this is...

I need to prevent users from entering incorrect values. Everything works except SetFocus. Any suggestions? Private Sub TextBox2_AfterUpdate() CheckBox3.Value = True If (Me.TextBox2.Value) <= (Me.TextBox1.Value) Then MsgBox "Value Cannot Be Less Than 1st Flight", vbCritical TextBox2.Value =...

Hi all, Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough! So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm...

Dear friends and respected seniors, I have the following data in column A, starting from A2 100 200 250 300 100 350 550 400 What I am trying to do is I compare A2 with A3 . If A3<=A2+100 , then compare A2 with A4 and so on...... If A3>=A2+100 , use that cell instead of A2 and compare with the...

Hi, Memory has gone blank. Looking for the name of when you alter names in drop down list etc & something you click will circle the now incorrect items. Before it would be say Black Dog but now its White Dog,using this process would circle all the Black Dogs in the sheet. Thanks

Hi, I have a button that can log a user in via their windows user and password but what I would like to do is disable all buttons except the login button if the incorrect user/password is entered, If User enters correct info then enable all buttons. is this possible through vba?

I don't want to use VBA as this will make it a xlsm file which can be rejected when it enters the company's email system. I have date validated a cell so that only a current or greater date can be entered. However when an incorrect date is entered, a message appears but the incorrect date...

Hi there, I am using the Round Function to round some computed percentage values to 0 decimals. The values are: <tbody> 48,4848485 <tbody> 27,2727273 <tbody> 24,2424242 </tbody> </tbody> </tbody> So 100% all together. For the first number the Round Function, i.e...

I have 2 linked tables and wish to create a pivot table showing employee ID, Name and the person's related Role. The tables are linked on Employee ID but query displays what's shown below: Emp ID Name 123 John 456 Bill 789 Joe Empl ID Role 123 Admin 456...

I have the following code that's not working. It asks for the password and even provides the message if the incorrect password is entered. But it won't unhide the worksheets. The code is getting hung on ws.Visible = xlSheetVisible. What have I done incorrectly. Assistance is greatly...