Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it "VBA". If it is about an Excel formula or worksheet function, then also tag it "worksheet-function".

learn more… | top users | synonyms (2)

1
vote
2answers
21 views

Adding multiple numbers to existing data

What if I wanted to add multiple numbers in different cells at the same time for example: Each number represents a cell 5 5 5 5 5 5 5 5 I would then like to add the below in one easy ...
0
votes
1answer
22 views

Excel, count characters except a string

I'm using Excel 2013. Basically I'm trying to count the number of characters within a cell, but if the cell contains a specified string to ignore that string but count the rest. Looking at the ...
4
votes
2answers
789 views

Excel “And” and “Or” Command

I have taken notice that the "And" and "Or" command is not consistently give the correct answer. 1) "And" formula =if(And(B2,C2>3), "Yes", "No") input Cell B2=4 and Cell C2=3, yield answer "No" ...
1
vote
1answer
33 views

Parse Excel to xml using VBA

I have VBA code that wirtes an Excel table to an xml file (actually writing the xml file line by line, tags equal column headers). This is the code, it is quite straight forward. Sub ...
0
votes
2answers
24 views

Excel Converting Rows to Columns

Input table is Project ID Project A 1 A 2 A 3 B 4 B 5 B 6 B 7 C 8 C 9 Output Table A B C 1 4 8 2 5 9 3 6 7 Can someone help with this?
0
votes
1answer
13 views

How do you obtain an array of vlookup values without an extra column in Microsoft Excel?

I have a list and a lookup table. The list will be in column A and the lookup table will be in columns C and D. Each cell in column C contains text and is unique. Column D has a corresponding value ...
0
votes
2answers
36 views

Random selection in Excel based on some criteria [closed]

I am a beginner .. I need some help to write a formula in excel urgently to randomly select people to 6 teams based on gender for example: I have a list of 78 people containing 48 females and 30 ...
0
votes
0answers
21 views

why does this select statement fail? it works as a macro but not as a button

i recorded a macro that selects a sheet and then a range. it works as a macro but it fails as a button, just want to know why? Private Sub CommandButton3_Click() manfix = InputBox("Enter in fixture ...
1
vote
1answer
18 views

count comma delimited list in excel

I have a column in Excel that contains a comma delimited list: Header A, B A A, B, C D, A I would like to extract this data so that I can count the occurrences of each item so that I would have the ...
1
vote
1answer
26 views

Can you autofill numbers going upward?

I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan). It may sound counter-intuitive, but my boss ...
0
votes
1answer
10 views

Summing values from across worksheets

Let's say I have two worksheets as below: WorksheetA ========== A B 1 John 5 2 Dick 4 3 John 4 WorksheetB ========== A B 1 Adam 9 2 Dick 2 3 John 8 What I ...
0
votes
0answers
32 views

How to keep a Value in Excel (constant value)

I have set up a formula, =IF(T74="1/2Dry Stack",0.1,IF(T74="DryMortar Joint",-0.1,0)) Linked to a drop down list on another sheet. How can I keep the value of the formula after making another ...
1
vote
1answer
36 views

Can't Remove Empty Custom Toolbar Under Add-ins tab

After messing around in Excel for a while, I have found out that a new toolbar called "Custom Toolbars" containing nothing showing under "Add-ins" tab as shown as the screenshot below. Although I ...
0
votes
1answer
22 views

Excel 2013 vlookup & sum

I have a data set which shows test results, each person my have several rows of data. My labels are ID - Test Date - Test Result - Interval Between Tests I want to sum the interval between tests ...
1
vote
1answer
42 views

Excel Top 5 Formula Explanation

This formula below works wonderfully! But I am having some trouble wrapping my head around what is going on. Can somebody explain what is happening here step by step. I have a good knowledge of ...
0
votes
1answer
33 views

Excel 2010 VBA click cell trigger macro to show list of values

When clicking on cell say d2 I want to show the values from j2:j6 in e2:e6. When clicking on cell d3 I want to show the values from k2:k6 in e2:e6, etc. Can someone help me? thanks
2
votes
1answer
43 views

EXCEL Formula economies of scale calculation

I need a formula to calculate a subscription charge that reduces based upon the number of subscriptions purchased, but as additional different subscriptions are added they will be at a different ...
0
votes
1answer
32 views

How to count the occurrence of a value in each month

In a worksheet ('guests'), I have a list of guests and their admission and leave dates. In a worksheet ('Report'), I want to know how many admitted and left in each month of the year and their names. ...
-1
votes
1answer
13 views

How can I parametrize an Excel Sort, i.e., make a generic sort? [on hold]

I am trying to build an Excel sort command which allows me to specify, as parameters (arguments) row numbers, columns, and worksheets. I can build the strings in the command, but have not been able to ...
0
votes
0answers
23 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
0
votes
1answer
11 views

How to retain conditional formatting on historical and new cells when inserting new column in Excel 2013

I have a macro that inserts a new column each week to a spread sheet. I have conditional formatting that indicates if cell H2 less than B2, then format font red. I need this retained for all ...
1
vote
1answer
26 views

Adding value to cell based on ending of string in another cell in Excel

I've got a seemingly involved request that I can't seem to wrap my head around. I will try and simplify as best I can... I have a column (A) that contains number values, and a column (B) that ...
1
vote
1answer
28 views

As a US user, how can I change the default date format in Excel 2016 (Mac) to YYYY-MM-DD?

Note: I see several questions (q1, q2) on this topic that describe how to accomplish this with the Windows version of Office, but I haven't found anything on Mac version of Office. I'm a US user, and ...
2
votes
3answers
38 views

Excel data numbering

I have a series of data in excel as under ARG2755-NNL4W BBF1732-NNM4WF BES0542-NNM4W BES0542-NNM4W BES0542-NNM4W BES0542-NNM4W BES0542-NNM4W BES0542-NNM4W BRA0743-NNM4VF BRA1650-NNM4TK ...
0
votes
0answers
34 views

counting text in non-consecutive sheets with variables

In Excel 2003, I've posted a question about counting text in 1 I got a very helpful answer by Gary's Student. But I want to count the text in a dropdown list with many items, and I want to count the ...
0
votes
1answer
49 views

How to view and change the assignment of keyboard shortcuts to existing macros?

In Microsoft Excel 2010, I have a macro assigned to a keyboard shortcut. Strangely, it's not working properly. I want to double-check the keyboard binding. How can I view and/or change the ...
1
vote
1answer
39 views

Merge 2 excel spreadsheets both containing updates in rows and columns

I have 2 spreadsheets and need to merge and update the data combination of both. Spreadsheet A userid, name, phone1, phone2, city 1, mister T, 123 123, 123 124, paris 2, mister A, , 123 124, tanger ...
3
votes
1answer
30 views

How do I calculate days elapsed since given time

I'm trying to calculate how many days elapsed from date. When I do =DAYS(TODAY();C3) I get 1903-06-04, but I'm expecting number of days.
2
votes
1answer
51 views

How do I assign numeric values to text in Excel or Numbers and add them

I created a spreadsheet to track my sons wrestling team. The text I'm trying to convert is Wp, Wt, Wm, etc. The first letter stands for Win and the second letter represents how the match was won. ...
1
vote
1answer
30 views

Last and first name lookup, return a value in that row

Using Excel, I have two separate workbooks with one worksheet in each that has one column for last names and one adjacent column for first names in the same (last then first) order. I want the second ...
0
votes
0answers
20 views

Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...
0
votes
1answer
44 views

Is there a way to word wrap the text in a button?

I have an ActiveX button that has a long line of text to it. It's long enough that it cuts off the text. Is there a way to wordwrap the button?
0
votes
0answers
53 views

Opening SharePoint files from Excel's recent file list always locks the file for writing

I use SharePoint extensively, and I find the "recent files" list within the Office applications to be quite a time saver. The problem is that I do not always wish to edit a file when I open it, but ...
0
votes
1answer
55 views

Multiply the Sum of one Cell if another cell shows value

I've added a hidden cell (T259) which calculates 10% of Cell U78 if "Mortar Joint" is selected in the Sales Agreement sheet. I want to add a function in cell U78 to add the value of T259. I am getting ...
0
votes
1answer
21 views

How to populate a dynamic dropdown list based on a value and a table

I have a table as follows: Item Name Slot Bronze Dagger Main Hand Shortbow Off Hand Magic Staff Main Hand and so on. I want to have a drop down list somewhere ...
0
votes
0answers
41 views

How do I program a excel chart to auto find or tell me the % likely for the next line?

Basically, I'm trying to find a way to get my excel file to tell me what is the % likely the next line is going to be a given set of numbers. https://www.dropbox.com/s/bd4hgyt886p86kk/Data.xlsx?dl=0 ...
1
vote
1answer
46 views

Find value based on multiple conditions

I have two excel files, one containing data of an event (STOPS_DATA) and one containing the amount of waste during that event (WASTE_DATA). Sample data can be found in: ...
-1
votes
2answers
53 views

Excel 50% Proportion Formula

I am trying to figure out the formula for a 50% proportion of a numbers. Given the following set of numbers, is there a way to calculate the number that represents 50%? I am using the following ...
0
votes
1answer
27 views

How to make line graph, or bar graph with different categories on excel

I don't know anything about Excel and I've been trying this for over an hour. I had to do an experiment for class that asks if hair color relates to height. I have the hair color and height of 20 ...
0
votes
1answer
22 views

Excel Formula to check set of cells for specific text then check and assign values to other set of cells

Alright I am trying to make a formula to check a set of cells for a specific word then if that word is found check a corresponding cell and assign a value depending on what is in that cell. Then take ...
0
votes
1answer
16 views

How to get column header if sub-string is found in sheet?

I am attempting to get the column header of a cell in Sheet1 when that cell contains a substring that is defined by cell Sheet2!A2. I have used this formula successfully for cases where the ...
0
votes
1answer
43 views

In Excel, make radio button active/inactive depending on cell value

I want to make an Excel radio button active/inactive, depending on the value of another cell. I made the following attempt: Sub test() If ActiveSheet.Cells(9, 3).Text = 3 Then ...
0
votes
1answer
18 views

Exports to Excel cause intermittent integer to decimal conversion

Does anyone know why when exporting data to Excel, some of the digits are changed from whole numbers or integers to decimals with 5 or more digits. For instance, 800 will become 799.999996 or it might ...
0
votes
0answers
23 views

Trying to show a month to month trend with several locations (10) with 6 different trends

Location Criteria 1 Criteria 2 Criteria 3 Criteria 4 Criteria etc... Location name Jan 12 10 5 2 0 Feb 2 5 3 ...
0
votes
0answers
11 views

Excel Pivot Table Calculated Field Error

My pivot table summarizes DebitOB CreditOB Debit Credit TotalDebit TotalCredit Net Debit NetCredit 0.00 0.00 0.00 648143 0.00 648143 0.00 648143.00 0.00 0.00 ...
0
votes
1answer
24 views

Make a hyperlink with variable arguments based on cell values?

I've got a question regarding the HYPERLINK() function in Excel 2013. I've got a list in column A, containing roughly 1600 filenames. From this list i filter our all the files in the following format ...
1
vote
1answer
17 views

Referencing a range using hyperlink

I'm looking for a solution of hyperlinking a cell. For example: On Sheet one I have details for XYZ from B1 to D5 for ABC B7 to D11. On sheet two I have XYZ and ABC. If I click in sheet two ...
1
vote
1answer
34 views

Progress Bar in Excel 2013

I have a training doc on Excel, with multiple sheets, showing multiple tasks that need to be done. On the home page (worksheet) I would like to show a progress bar showing the amount of tasks complete ...
0
votes
0answers
20 views

Formatting Cells in Excel Starter

What custom formatting in 'format cells' do I need to stop zero amounts (0.00) appearing on my spreadsheets, without losing decimal places for the actual amounts (i.e. I want 24.56 to show, not 25). ...
3
votes
1answer
37 views

counting a text string in non-consecutive sheets

In Excel 2003 I`ve a question about counting a text string Man in sheets named 001R through 900R, in the same cell C8 of all the sheets I`ve got the following answer ...