reason

I created an excel sheet that contains all the purchases we've made at Costco. The main thing I was interested in was calculating the total grocery expenditures for each month in 2018. The SUMIFS formula that I had for some reason is no longer working. For reference, I posted a question about...

Hello, Say I have a macro-enabled workbook and I manually go to the file folder and make a copy of it (not with VBA), just simply make a copy. The workbook is of course renamed with a whole new file name. The reason I am doing this is because I want to re-use the macros in it, and I am only...

Hi Is there any certificate exam I need to do to get only Excel certification? Do you recommend any? I googled and found MOS but that is for the whole Office suite. I need the certification for job reason. Thank you very much.

Hello, I have created the below formula, which I'm trying to remove weekends and company holidays. I have a table built on another worksheet (worksheet name = Workings). For some reason it's not removing the time even though I have the date in the table. =IF(H2="","",IF(G2<>"CS Tech Team...

Hello, I am using Office 365 and when I open two Excel file then it opens on the same instance. For some reason, I am looking to open in a separate instance. Anyone has an idea how to achieve it. I appreciate your response. Thank you!

I have 3 columns (A:C) - header names are PatientID, Reason, Paid Reason is the reason for the visit, Paid shows if the visit has been paid for. So the data looks like this: 192837 Reason1 Y 459357 Reason2 Y 459379 Reason2 Y 192837 Reason1 Y 459357 Reason2 Y 342873 Reason3 N 345035 Reason2 N...

I have an existing workbook done by a previous employee...I am having several formula issues so in an attempt to teach myself whats needed and do refresh the workbook I am recreating it from scratch. I have already hit a roadblock though. Firstly this file basically acts as a "to do list". The...

Hello, I have had a worksheet working fine for 9 months. It normally takes 2 minutes to execute the macro in this worksheet, but for some reason in the last two months it started taking 6-8 minutes to execute. I was able to isolate the code that was taking so long. Open kmfile For Input...

For some unknown reason, when I type: .Value VBA changes it to: .value Does anyone know why?

Hello everyone! I have been working on an Excel spreadsheet for a master thesis, and this is my first time going around and using VBA. What I am trying to do is have each specific sheet in my workbook be protected against accidental changes of some cells. Therefore, I am running this code on...

Hello, I thought I knew how to do this, but for some reason I can't get it to work. For example: This formula returns the value I need to look up in range $W$16:$DUR$16. COUNTIF($W$15:$DUR$15,"<"&S$18)+V18 Once the value is found in that range I need the formula to return the value of the...

Hello all This line of code removes all my duplicate rows based on the primary key in column "A", at the moment it deletes from the last row upwards but I need it to delete from the first row downwards, reason being is that the newest records are always copied after the last row, is this...

Hello, I have a list of number, and from the list of numbers(Column B, 500 rows) I need to be able to see selected number to add to aspecific number. E.g 4 33 34 3 From the list I need to select number that add to 37. Therethe operation would select 4 and 33. I have used solver, but for...

Hello everybody, I am experiencing an issue in Excel which I cannot solve by myself. I find myself with 1280 columns with the first two rows (1, 2) filled with data: For printing reason, I need to move all the data under columns A, B and C: Thanks a lot for your help and suggestion! BC

Good evening! I have a column with 400 dates that are in the format "MM / DD / YYYY" and I need to convert them to "DD / MM / YYYY". The problem is: for some reason excel reverses the month with the day in some cells. I've discovered something that may be related, but I can't say exactly...

Good afternoon I am using the formula below to extract the first 3 words in a cell. Would it be possible to interpret the formula a bit so I can possibly modify- reason, there are some cells which I require to extract the first 4 words. Thanks Gents.... Extract 3...

Hi Everyone, for some reason pulling a blank on this. Two cells D3 & G3 I want to see the difference if its more than 1p (0.01) but show 0 id not please help Thanks Tony

Hi Everyone, I am having a minor melt down with a formula or lack of. I have a rather large table which has a whole load of times in. I have added a column to the end and i want it to show the earliest time but ignore 00:00. For some reason every example i have found online does not work. And...

Sometimes I want to sort numbers in a pivottable with the right mouse click ascending / descending. Unfortunately this doesn't work most of the times. Who knows the possible reason and how to solve this? Thanks. Best regards.

Is there a rational reason why the board requires that I wait 3 seconds between clicking on Like this post and Thank you for posting this? For that matter, is there a rational reason why there are two ways to acknowledge a helpful post?