fine

=LOOKUP(2,1/(U:U<>""),U:U) I'm using the above formula and it works fine on my computer. I sent the schedule to some other people and it's working fine for most; however, for one individual, the cell with this formula isn't calculating: Her Options are set to Automatic Formulas: all other...

have the following formula so If A1 is No and A2 contains Apple and either A3 or A4 contain Yes then the result is Yes This works fine whenever I change any of the cells. =IF(AND(A1="No",ISNUMBER(SEARCH("apple",A2,OR(A3="Yes",A4="Yes")))),"Yes","No") However If I change the formula from...

Hi everyone - I have a user with an excel file which, when he right clicks on a row number and selects "delete", it deletes only the data and does not move any of the cells. If he right clicks, within the same file, and selects "delete", then selects either "Shift cells left" or "Shift cells...

I know this isn't the normal type of question for this forum, but I wasn't sure where else to ask. Recently I had an issue where research indicated I'd benefit from changing to the 64 bit version of Office 365, so I did. Now, however, I'm running into things I've not seen before. One example...

Hi - looking for help!! I designed an 'macro enable excel workbook' based health assessment tool a few years ago. It worked fine on versions of Excel as far back as 2003. I have just updated some of the content. A friend helped me with some coding to update a few features. He worked on it...

I have a workbook that has several different macros that are stored within the workbook. The workbook has 3 form controls and the rest of the macros are just run from the macro dropdown. Sometimes when I open the workbook no macros will be showing in the drop down and other times they are...

Can anyone advise why the below formula seems to include all blanks, and how I get around this please? (It works fine for every other month!) =SUMPRODUCT(1*(MONTH('Dev WIP'!$AC$2:$AC$1000)=1))

Good morning everyone, I am looking for a little help with getting a hyperlink to work. I am attempting to use V & H look up functions to provide me a hyperlink to another worksheet that is contained inside the same workbook. I can get the look up function to work just fine, I am having trouble...

Hello all, I have a spreadsheet that is pulling in query data. My VBA code refreshes the query, populates a formulas in two column, and finally sorts the data. The query refresh is fine. The formula population is fine. The trouble I am having is that the sorting is not behaving. I don't get an...

Hi Everyone, I'm having an issue on occasion where macros that are written in the vba editor are not showing up in the macro ribbon so I can assign it to a button? Whats strange to me is the exact same macro will show just fine in a different workbook? It is a macro enabled workbook and I have...

So I got a new computer and on it came Office/Excel 365. I pulled open one of the spreadsheets that I have been working on and figured out that the "-" key doesn't work when it is the first key pushed in a cell. For example: If I want to put in a negative number I would input -123, the...

Hi, I am wanting to combine 2 cells, so C5 (28/02/19) and D5 (1) together but when i do it i get the following. 435241 I am doing the formula of =C5&D5 to get this what else should i be doing? I am wanting the outcome of 28/02/191 or even 2802191 would be fine. thanks

I have a INDEX/MATCH formula, whenever it encounters a duplicate, it is being ignored. Otherwise it works fine =IFERROR(IF(COUNTIF($J$3:J3,J3)=1,MATCH(J3,INDEX(Input_Events,,5),0),MATCH(J3,INDEX(INDIRECT(ADDRESS(ROW(Input_Events)+K2,6,1,1)):data!$J$102,,2),0)+K2),"") Thanks

G'day guys. Have the below code: Set TB = ActiveWorkbookWorkbooks.Open "C:\Users\Luke\Desktop\LIVE\Best Shed Scheduler Flashing.xlsm" Set OB = ActiveWorkbook erow = OB.Sheets("Corner Flashing Machine Data").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row TB.Activate...

I'm new to Macros and working with a training tutorial, and there's a really simple problem, I just cannot figure out. I feel so stupid asking but i need help. Here's my code. So... I copied and pasted the line currently ' - which works fine But when I type the line, I get an "Unable to get...

February 1 has an Excel serial number of 43497. (fairly easy to figure out) Made a simple calendar based using the day function. =day(43497). Just copied it as necessary using the previous day +1 All is fine. Trying to use Conditional Formatting for today. It works, but when I apply it to...

In case you can't see the pict: https://snag.gy/v2MF7Y.jpg I get this randomly all the time. sometimes I close excel and open it and its fine. Othertimes, its temporarily fine, but really brittle. When it breaks, I have to unload and reload the model and then all of my cubevalue functions...

Hi. I have an issues with alignment in the worksheet below. .For some reason the column headers have started behaving strangely. You can see, even thogh they are centre aligned and columns are plenty wide enough they have started to be misaligned. Please help! They have all of a sudden done...

I am noticing strange behavior in one of my Pivot Tables. The columns are called Amount, My Fee, and My % and are shown by month, and subtotaled by Year. When I sort one of the columns for a given month, it works fine. And when I sort a column in the Totals section, it also works fine. However...

I have written an Excel workbook for Windows, and am now trying to make it work on Excel for Mac 2011. Several times in my code I call subs that are inside different worksheet objects. With Windows, it works fine to call them like this: Sub MySub If x = 1 Then Sheet1.AnotherSub End Sub...