**1**

vote

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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
...