incorrect

  1. L

    Help with Excel Formula

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

    CountA with a Dynamic Range

    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))
  3. M

    Calculating elapsed hours with weekends.

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

    Seeking help with common Excel errors

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

    Formula Not Returning Expected Value

    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")))
  6. J

    vlookup returns some correct values, some #n/a and some incorrect values

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

    Average is returning a wrong answer

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

    Run-time error "13": Type mismatch

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

    Excel Password

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

    Calculating incorret time recording

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

    Help formula VBA incorrect calculation when placed in array

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

    Preventing incorrect data entry

    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 =...
  13. E

    Compare data in table with Exchange data

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

    array iteration problem

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

    What is this process called please

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

    VBA Custom Ribbon Tab Buttons

    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?
  17. azizrasul

    Clearing a Cell of an incorrect date

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

    Round Function yields incorrect result

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

    Power Pivot: 2 small linked tables returning too many results

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

    VBA to require password to unhide all sheets

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top