fine

  1. D

    "#VALUE" error from IF statement

    This works all the time with a new worksheet, but as I keep editing cells something happens. Say, I want to put a blank in cell B1 if A1 is blank. In B1 I use =IF(A1="","",A1). If I try to use B1 in a formula it treats it as a "0" and calculates fine. Sometimes though I'll get a "#VALUE"...
  2. T

    Help with nested if statements with vlookups

    I am trying to have a multiple criteria if statement to vlookup a value based region (which each is on a different tab). Each of the if statements work fine on their own, but not combined. What am i doing wrong here...
  3. khalilAsslan

    Can't do Refresh All on worksheet that is connected to SQL databases

    I have a worksheet that is connected to many SQL2008 databases, it pull information from DB's to the excel worksheet, I do (Refresh All) every day, After I press RefreshAll , the worksheet ask for password. So far this works fine on 4 computers who have full access to the worksheet, on 2 other...
  4. M

    Why could my macro slow down?

    Why could my macro slow down? Hi I have a large spreadsheet with millions of formulas with a macro that takes 8hrs to run a full cycle. Everything for the macro has worked fine until I recently made so changes to check results which doubled the file size. Basically it runs threw a loop...
  5. C

    Comment Boxes & Dropdown Arrows only appearing momentarily - Excel 2016

    Hi, I have a file which used to work fine but now has a problem - the only difference is that I have upgraded from Excel 2010 to 2016 (which I guess must be the issue!?). The comment boxes and dropdown list arrows only appear momentarily (a quick flash on/off) with this particular file in 2016...
  6. C

    Selecting text

    The formula =IF(RIGHT(F510,6)="Avenue","Avenue") works fine copying Avenue into L510 The formula =IF(RIGHT(F509,6)="Street","Street") works fine copying Street into L510 But when I put them together I get #VALUE ! =IF(RIGHT(F510,6)="Avenue","Avenue"),IF(RIGHT(F509,6)="Street","Street") Can...
  7. I

    Partially delete cell content, based on previous cell

    I'm dealing with 4 Columns with the following initial layout example: <tbody> COLUMN S COLUMN T COLUMN U COLUMN V 01, 03, 21 01, 03, 21 08, 15 08, 15, 08 15 30, 33, 34 30, 33, 34, 30, 34 33 09 09 </tbody> I'd need, via either an equation or a macro, that the cells in Column V...
  8. B

    VBA - Workbook suddenly requiring all variables declared when no option explicit

    Hi, I have a workbook that I've used for years. I know it's not best practice but the variables are not defined. This has never caused an issue, it has always worked fine, but today it is giving me a compile error on every variable unless I dim them. Option Explicit is not set, neither is the...
  9. L

    Excel links corrupt

    Hi, I linked a file in Excel 10 to a file sent to me from Japan. The links all seemed to be fine. I saved and closed both files. I then reopened my file and the links were fine, but when I opened the Japan file at the same time, my links instantly turned to #REF !. I tried to redo it several...
  10. Gerald Higgins

    Weird problem, comment box moves to new location when comment is edited

    Hi all, having a weird problem here, tried searching on the board to see if it had come up before but couldn't find any reference to it. I have a big spreadsheet set up, and users can add comments to certain cells. When you hover over a cell with a comment, the comment box appears close to the...
  11. J

    Countif problems not calculating correctly

    Good afternoon all I am having issues with a Count If formula =COUNTIF('From April 2017'!F2:F801,"On call manager") This one works fine =COUNTIF('From April 2017'!F1:F802,"OOA") This one and =COUNTIF('From April 2017'!F3:F803,"=YFS")gives a 0 count when they should be 10 and 1 There are no...
  12. M

    VBA-Save file, paste data and email to a user-Almost there, just need a little more

    Hi Guys, I posted a question earlier about how to save with a prompted name and the date appended, and I got that answered. I also have my code set to select ONLY the rows filled and paste them into the body of an email, and send that email. I also want to attach the current file. THis makes it...
  13. B

    Problem with 2 rows with - Dim LR As Long

    Hi, I have a problem with VBA in excel. My code works fine for every table except when I have just 2 rows then I have error. First row is filled with column names and second rows i filled with formulas for each column. So if I have more then 2 rows everything works fine, but when I have just 2...
  14. T

    Sum product not working properly

    Guys, any chance you could give me some pointers? I have copied the below formula from another work book, where it worked fine. However it keeps returning a #Div/0! error in my new work book...
  15. A

    MSEXCEL 2016 VBE : Can't find project or Library error

    At my Workplace which is a Home Office, running PC: Windows 10 Pro MS Office 2016, released via Office 365 Problem with: A specific MS Excel File (xlsm), that has been working perfectly fine since 2013. MS Office 365, has been on the machine for past 2 years. The Wb (lets say MyWB) is...
  16. M

    Index Match not working when linked in name manger from a formula

    Hi Im using excel 2010 In the name manager i have a range using this formula =INDEX('Picture Lookup'!$Z$2:$Z$3,MATCH('Picture Lookup'!$I$2,'Picture Lookup'!$Y$2:$Y$3,0)) its not working correctely im using another formula in $I$2 on my sheet to return the value of either a 0 or 1 If i type...
  17. L

    Formula error #NAME?

    I am getting the #NAME ? error with the formula listed below and am not sure how to fix it? I am using the same formula on another sheet within the same workbook and it is doing just fine. =IF(COUNTIFS(CA Data!I:I,CA Temp!H2,CA Data!G:G,CA Temp!F2)>=1,1,0)
  18. Anne Troy

    Count unique by date/time stamp

    Sample file: http://annetroy.com/mrexcel/Sample2.xlsx Countif and Sumif have always been my nemesis. I need to count how many unique airlines are listed in column G, each time the timestamp changes in column A. I only need it to show once in the column. Sorting first is fine, if necessary...
  19. J

    Macro, that worked fine, not working on Excel 2016

    Hi, my work PC has just been updated from Excel 2010 to 2016. I had a macro that worked fine before the upgrade but now when i run the macro from a button in 2016 it formats the worksheet incorrectly. However if i go into Visual Basic and run the macro step by step it formats correctly. Any...
  20. C

    Calculating 'Negative' Time

    Hi there, I have a sheet that shows the number of hours above or below a standard working day a person has worked. I need to then sum these. The formula I have (column R) is fine if the outcome is positive (row 3) but not when negative (row 4). Any ideas please...

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