excel 2013

Hello, I've been trying to research a way to include the OR conditional, or an array, within an AVERAGEIF formula, and cannot find a way to do so. The AVERAGEIFS function is essentially an AND operator, so it says that all the conditions must be met, but I need for it to calculate the average...

Hello all, I need to rely on your wisdom once more; This time for the solution to what will hopefully be a simply issue, that I'm simply drawing a blank on. Context: I work within a Help Desk / Service Desk team for a company, and do metrics reporting. One of the systems I report on is a...

Hi i have 5 column table - 1st column -"product" ,2nd column-"A",3rd column-"B",4th column-"C",5th column-"D" Product are selecting from drop down list.The drop down data come another sheet. have 4 product (Name) LSOU ,LCOU,COC,DEC If select each product name to row "LSOU" , "LCOU" , "COC"...

by using data validation we can lookup from a list and select a record. my query is how can we delete that chosen record from the list as soon as it is selected? it's like a cut and copy paste process but only it is in a drop down list via data validation. hope this is clear. many thanks

I have many rows in spreadsheets that I need to first add value in c1 to d1 and then delete d1 as an example <colgroup><col><col span="3"></colgroup><tbody> ESOS10 $ 2,813 $ 5,759 $ 2,879 ESOS10 $ 10,856 $...

say, I have a string: "The Greatest Show On Earth" I just want to have the first letters of each word: "TGSOE" pls help with the formula (not VBA) - maximum words per string = 5 many many thanks

I have named cells A1,B2,C3,D4 as "lfk" these cells have some values when I used =SumIf(A1:D4,lfk) - I didn't get anything, what is wrong with the formula? many many thanks

what is the formula to populate a column with alphanumeric string? the string is to be used as product code.. say, starting at LFK101 - LFK102 - LFK103 (increment) so on down.. the string can be any number of letters and numbers.. like A1, ABC123, XYZ110.... the letter is always at the left and...

Hi, Can anyone help me with generating a simple XML file from a table in Excel sheet? I can do this using the add-in if it was a regular table with simple rows and columns. But in my case, it's a tweaked table with merged cells. Is there a macro which I can use? I have attached a sample Excel...

I have a spreadsheet in Excel 2013 where I have a pie graph that displays percentages as the data labels. I had a custom format code, 0.0%;-0.0%; ,to hide zeros from the chart, however a request came through to display both percentages AND values. Now my custom format code is not working for the...

so I have spreadhseet that I want to do a couple things in VBA and compatible with excel 2013 sheet1 (named complaints): sort column E in numeric order older to new automatically as entered it will sort for me when column I is marked yes to then move that entire row to sheet2 and removed from...

I have a workbook with the following spreadsheets: Summary, and Jul18, Aug18, Sep18 (and rest of the months going to May19). On the Summary Spreadsheet, it looks like this: A1 - Month (drop down list) A2 - Student (drop down list) A5 - Number of Assignments A7 - Number Completed A9 - %...

Greetings all, I am trying to run a script which is supposed to delete the visible rows from a table I've filtered. However, when the script is ran it comes up with error msg: :warning: "Runtime error '1004': Delete method of range class failed. :eeek: I have tried it two different ways...

Hi Group, Had a question and curious if anyone knows an answer for this: I recently had my company switch from Excel 2013 to Excel 2016 and I noticed several reports with Macros have all recently been crashing and getting Errors that are around lines of code like Workbooks.Add and the solution...

Hope you could help me. I saw the below code in the internet, however, I don't know why it's not working for me. Function CheckColor1(range) If range.Interior.Color = RGB(256, 256, 0) Then CheckColor1 = "***" Else CheckColor1 = "" End If End Function Inputs: 1. I...

I am looking for some assistance with VBA as I am extremely new to this... I have a drop down menu in cells D8:D28 that have 5 options (Elec, Mech, Op, C/Over and Project). I want to stop people selecting either Elec or Mech unless there is a numeric value in cell N8:N28. Please if anyone can...

Hello So I have a spreadsheet (Excel 2013) with two columns for Firm Names and Address. Now for several entries, the firm name is present in both the firm name and the address column. How can I compare these two columns and strip off the firm names from the address column? How I have it...

I have a UDF that I wrote .... nothing fancy, but I could sure use some help cleaning up. It is very basic and I am not 100% sure where or how I should clean it up so that it is easier on the eyes, easier to follow (doesn't make one cringe just looking at it), better coding...

I have a worksheet as ff: column A Column B Column C materials unit of measure quantity sorted on column A then SUBTOTALed on column C but after that -- only Column A & Column C were shown the column B is blank! is there a way to...

I’m trying to protect cells in my worksheet while maintaining the functionality of collapsing and expanding the worksheet. I’m working in Microsoft Excel 2013. I’ve read that I need to run the following code: Private Sub Workbook_Open() Sheets("Sheet1").Protect Password:=""...