solution

I am using the below average if formula to determine average employee performance rating. I am trying to get rid of the #DIV/0! from cells where data has yet to be populated, as I want to set this up to be used in the following years and indicate an overall average. =AVERAGEIF(B4:E4,"<>0")...

When I move a table column to another position in the table, I keep getting an error message telling me that "Excel can't insert new cells because it would push non-empty cells off the end of the worksheet." I can confirm that the table column itself is selected and is being dragged to the new...

Hello, I am new here and not familiar with VBA so i would like some help if possible. I would like to make a list in excel to include all "xlsx" files and its sheets that will find in a specific folder and its subfolders. Until now, i came across to 2 possible solution but both are not...

Lets say i have a data set with five columns with subject name for every student and need to create a program for exams. Mark A B C F Paul K C L A Jane B F D A George M N C E I need to find the best way to combine all letters so that no student has two exams the same...

Hi, I have a huge dataset and I need to apply conditional formatting in a very strange and complex way. The data is a mix of hard coded and calculated prices. I need a formula that will apply formatting only if the cell ends with an 5 in the second decimal place (20.55, 5.05, 42.95, etc.). I've...

Hello all, Firstly, thank you for taking your time to read my question. I am writing this as I have run out of ideas as to how to fix this issue. Whenever I try to open any excel file, that has macros in it (both on my personal macro wb, and on the workbook itself), I get the error mention on...

I've spent forever searching for a solution to this, I only found one other person with the same problem (here: https://www.mrexcel.com/forum/excel-questions/983275-xlam-not-available-excel-2016-a.html) but a solution was never reached. Any idea what would cause the option to save as an add-in...

Hello, I have tried searching for a solution for my problem within the forums, but have been unsuccessful. I hope that this is not a duplicate thread, but if so, please let me know. I am still pretty new to VBA and hopefully this is not too much of a Rookie question. I am trying to set an...

Hello, I'm importing data every few minutes from a CSV file which contains about 25K cells with data. The importing process freezes my PC for about 5-10 seconds which isn't an option. I thought to myself if I could reduce this freezing time (hopefully to prevent it at all) by refreshing only...

Hello Team, am not able to save attachment in Outlook 365 as getting Cannot save the attachment. Not found Is there any solution for this? Regards, Chandru

Hello Team, am not able to save attachment in Outlook 365 as getting Cannot save the attachment. Not found Is there any solution for this? Regards, Chandru

<colgroup><col><col></colgroup><tbody> Problem Solution sites/213870278/_catalogs/masterpage/display templates/filters Filters sites/213870278/_catalogs/masterpage/display templates/filters/control_refinement.js control_refinement sites/213870278/_catalogs/masterpage/display...

Hi, I have a report that is run from another system, and unfortunately there is no way of altering the format of how it outputs the data. An example of what I get is: Anne 9:00 10:36 a 11:49 13:34 c 14:35 15:10 a 17:00 bob 7:20 7:45 a 8:00 8:45 9:00 c 10:00 11:00 a 13:00 carly...

I have searched the Internet and, ofcourse, this forum. I just could not find a workable solution (maybe I haven't searched good enough). What I have is a workbook with 200 sheets with exactly the same layout. It is a working schedule of 200 employees. What I want is in a specific sheet to...

I've seen the post to find (6 consecutive numbers adjacent to each other in the string) with the solution being: =LOOKUP(10^6,MID(A1,ROW(INDIRECT("1:"&LEN(A1)-5)),6)+0) I am trying to find the first 3 digits in a string like this: text 777 moretext 555. When I apply the solution above and...

My workbooks contain a lot of formulas. When I have te workbooks open it causes excel to be very-very slow. I need to find a solution as it is affecting my work. Please help.

I have a string that was exported from another program. It has quotation marks around it so I cannot do a text to columns on it Below is one cell. "PROBLEM: LOAD ERROR, WILL NOT CHARGE SOLUTION: REPLACE MAINBOARD, BARCODE AND PIN FIX, REPLACE IO LEVEL 2: BILL COMPANY, 201080354, 30160045 REPAIR...

Hi! I have read a lot about this topic, but unfortunately there are no codes which work with excel 2016 too. I need a macro, which exports for example the range of A1-E10 to the desktop as a jpg file. Do you know a solution maybe? Thank you for your help, it means a lot me! Have a very...

Hello Everything, I'm asking you for some solution with my problem. I turned the internet over, but I still can not find a solution to my problem. I have a table in which column A2: to the end I have products in column B2: by the end I have sold pieces of these products. My problem is that for...

Hi, I am trying to pull a csv file into a worksheet within a workbook and despite long searching have not yet found a solution. A single line would typically be in the following format: 407,"2018-07-24 12:21:08",processing,130.00,paypal,fist name,surname,name@email.co.uk,07123123456,"Hi, this...