fine

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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