# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

19,105
questions

**0**

votes

**0**answers

7 views

### Conditional Formating sections of a table based on a cell value

In my constant drive to work more efficiently I've been trying to learn excel to make my day to day work easier.
I'm using this graph I made here
Sorry for the link but I'm not sure how to input ...

**0**

votes

**0**answers

8 views

### Autorefresh excel file in sharepoint

I have an excel file that is connected to some external data sources (sql server...). This file is used as a data source in a power bi dashboard. What I want is to have the data in this excel updated ...

**0**

votes

**1**answer

20 views

### How to keep an excel file open in sharepoint or onedrive after I log out?

I have an excel file that contains some vba scripts that refreshes other excel files at specific intervals. My problem is this file must be open in order to have that macro run. My question is how can ...

**0**

votes

**1**answer

14 views

### How to automate football pool checking

I am looking into how I can automate the process of gathering the answers from a football pool sheet. The play sheets have 2 teams per line and a box to fill in for each if the contestant believes ...

**1**

vote

**1**answer

14 views

### Conditional VLOOKUP based on dates

I have two tables I want to merge in Excel:
+---------------------+-----------------------+
| Date | Email |
+---------------------+-----------------------+
| 2019-07-...

**1**

vote

**1**answer

14 views

### Replace Static Table Data w/ External Source and Update Pivot Automatically (Excel)

st tab is a table with data manually pasted from a file
nd tab is a pivot based on the 1st tab
Is it possible to replace the 1. st tab with an external data source (load-in the file without pasting ...

**0**

votes

**0**answers

12 views

### Pasting a URL into a cell and, based on a formula, the cell retains the text in it

When you COPY (CTRL+C) a URL from your browser and then go to a cell in an Excel sheet that displays the word LINK (with the formula I copied below in it) and replace the formula (Select all and ...

**1**

vote

**0**answers

14 views

### auto populate cells based off of list selection

I have drop down lists and dependent drop down lists, but I would like to find a method to populate other cells based off of these selections. For example, my position drop down is predicted by the ...

**0**

votes

**0**answers

8 views

### How to get a list of keyboard shortcuts that I use for my macros?

I know I can find a list of standard keyboard shortcuts of excel in google or through Microsoft Office Help. But I have overwritten some of them (I wasn't using them) to assign for some of my macros ...

**1**

vote

**1**answer

19 views

### Run macro continuously when button on QAT is pressed

I have added two macros to "Quick Access Toolbar"(QAT). Macros are for navigating left and right in the sheet, like when you press arrows at the bottom right corner of the workbook. When you press ...

**0**

votes

**0**answers

27 views

### Refreshing an excel file without opening it

I have an excel file that is somehow connected to some external data sources. In turn, the excel file itself is used to feed a chart in power bi. What I want is to have the file updated at regular ...

**1**

vote

**3**answers

32 views

### Excel - Extracting data if a cell contains a text

I have created an example image of what I am trying to do.
I want cells r3 to R11 to add up the any hours that in that row but holiday hours only.
Can anyone help? thank you

**5**

votes

**2**answers

743 views

### How can I change Excel so that I can enter English rather than German formulas?

I want to change my Excel installation such that I can enter formulas in English rather than in German. I believe, I should be able to change the corresponding settings under File -> Options -> ...

**0**

votes

**0**answers

11 views

### Spinning Button To Work on added row instead of the existing row

There are 2 objectives on this document. To simplify: 1. Count the # of clicks (3 buttons to count since there are 3 different categories to count off each click) and 2. Use the counter on a daily ...

**0**

votes

**1**answer

12 views

### Can I Create a Soft Data Validation Table of Joined Cells?

I have a set of data that makes up a list that would be good to use for data validation in another table. However, in the other table, I would like the fields to show a combination of two fields from ...

**1**

vote

**1**answer

16 views

### Hide Rows based on multiple cells

My database is getting massive and I am trying to make things a little more manageable. What I am basically trying to do is:
If cell E:E = "Complete" hide the corresponding row
Else If cell F:F = "...

**0**

votes

**1**answer

11 views

### How to populate a master sheet for multiple other sheets

I have a workbook that had 7 different sheets,
Each sheet has a column that is labeled Companies. How would I go about setting up a formula that would add the companies names to master sheet as they ...

**1**

vote

**0**answers

17 views

### VBA excel - Is there any way to ensure the user cannot call/run a macro in the immediate window?

So I have written a VBA application and locked the VBAProject (unviewable). But of course, the user can still have access to the Immediate Window (if they open another excel file for example and ...

**0**

votes

**1**answer

26 views

### VBA debug on counting blank cells in a filtered list with VBA code

Apologies if the answer is obvious, only been using VBA for a week. Want to filter the cells in a separate sheet, then count the blanks left in the filtered list. I have got the code basics from ...

**2**

votes

**1**answer

23 views

### Filtering empty cells

Notice that B2 and B3 are merged and a filter is created on the B column
When I'm going to apply the filter it shows Empty (Vazias in Portuguese) as one of the options as there are merged cells in ...

**0**

votes

**0**answers

15 views

### EXCEL machine epsilon of grg solver

I use very often the onboard solver of EXCEL (grg nonlinear) and I am quite happy with its
performance. Since I use the data generated by the solver for further calculations I would like to knwo the ...

**0**

votes

**1**answer

25 views

### Selecting certain columns based on their value

I have created a spreadsheet of all my inquiries.
I want to select all the columns for example with "B". My main aim is to see as a quick summery, all the people who have booked.
Then if I wanted to ...

**0**

votes

**0**answers

18 views

### Need Help Building a SQL Toolkit

I have taken a new job where I work with other client's data. It's been almost all MS SQL with one Oracle job. My job has two main parts. The first is to review their data. I usually get a massive ...

**0**

votes

**1**answer

38 views

### I need to determine how many new sales reps to hire based on an estimated number of future clients in Excel

We have to do an analysis on how many new sales reps to hire based on the number of expected onboarded clients. The dynamic part of the problem is that when we hire a sales rep, they have a 2 quarter ...

**0**

votes

**1**answer

59 views

### Summing Excel Values in rows and columns for conditions

Using Excel, how does one sum the values in all the cells of a group of cells in rows and columns which have values greater then zero (positive) into a total sum of the positive values, and ...

**0**

votes

**1**answer

17 views

### Possible to check if a VBAProject is clicked?

VBA excel -- When a VBAProject is clicked or double-clicked, it will trigger a macro. <<<< Is there any way to do that? How to determine if my VBAProject is clicked or double-clicked? ...

**0**

votes

**0**answers

4 views

### How to Get Drill Down Sheets to Display Only The Matching Values Their PivotTables Sum Up?

I find PivotTable drill-down sheets are displaying excess data, and I want to see only the appropriate records that match the cells that I've double-clicked.
My Situation
I've got an Excel ...

**0**

votes

**0**answers

11 views

### Excel 2016 change pivot table analysis services data source erases the pivot table

We are upgrading an MS Analysis Services cube from SQL Server 2008 to 2012 (I know, I know...wish we moving to the latest-and-greatest!). We have 100+ fairly complex spreadsheets that read from the ...

**-2**

votes

**0**answers

27 views

### Microsoft office 365 excel formula questions [on hold]

I am trying to create a function that will take multiple inputs (cells) and output into one cell.
I have tried using IF and OR functions, and embedding the OR function into the IF function. I get an ...

**-1**

votes

**1**answer

29 views

### How to define a code text for a predefined result?

I couldn't word it very well in my question but a detailed explanation will be easier to understand.
I want to define a code -such as "A"- and a result text for that code or in my case I need a date. ...

**4**

votes

**3**answers

84 views

### How to create (truly) blank cells from formula so that they get skipped in Ctrl+Arrow?

This question asks about how to use a formula to create truly blank cells so that they won't show up in a chart. The solution is to use the formula NA() which makes the cell take on the value #N/A. ...

**1**

vote

**2**answers

39 views

### How to do a partial string comparison in Excel?

I have two columns in Excel. Both columns have a list of string that are suffixed with a random character. The format of the prefix is two strings appended by an underscore, and the suffix is added ...

**3**

votes

**1**answer

31 views

### How to turn on or off editing invisible cells when filtering?

When I filter out a row in excel, if I edit the entire range (including the cell that is filtered out), only visible cells get edited. When my boss does this on his computer, the entire range gets ...

**0**

votes

**0**answers

12 views

### Show the latest value using pivot table in Excel - part 2

For reference I have a similar problem to the follow thread, with a few alterations, making this solution not work as well as I would want.
Show the latest value using pivot table in Excel
The ...

**0**

votes

**2**answers

52 views

### Color row until the sum of cell is equal to a certain value

Good day everyone,
I need to dynamically color rows of a table, until the sum of cells of a column reachs a certain value
The "Effort" column is column E. I need therefore need to color rows until ...

**0**

votes

**0**answers

29 views

### Converting horizontal records to flat records using VBA

I am trying to convert the following format of records:
To a flat record, like the below, using VBA.
Please could you give me some pointers on how to begin this using VBA?

**0**

votes

**1**answer

24 views

### Excel Scatter Chart

I am try to create a chart that shows the difference in pay between male and female. I want pay at the top/bottom, sector on the left, and a male/female icon and the pay points. I can not seem to ...

**0**

votes

**0**answers

57 views

### Unable to install Micro Focus ALM Microsoft Excel Add-in

Unable to install HP ALM Microsoft Excel Add-in.
I am using ALM 12.60.
I need to upload test cases from Excel to ALM;
for that I have to install HP ALM Microsoft Excel Add-in.
Please find the ...

**6**

votes

**4**answers

1k views

### @ in the beginning of a formula

I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).
It seems that it is a new feature of Excel.
Does anyone know what this @ ...

**0**

votes

**0**answers

21 views

### Creating a repeating formula using cells

I am required to add two cells together and subtract another in order to get a number.
Example: (D2 + B3) — C3 = D3 (the answer would be put in D3).
The columns are always kept the same, it is just ...

**0**

votes

**0**answers

18 views

### Export Excel template with no meta data or special characters

We have a template that we are using to allow people to enter data in Excel, we then export that data to add to a database.
We need to use Excel for this because we have tens of thousands of users ...

**0**

votes

**1**answer

40 views

### Is Excel VLOOKUP the best choice for my application?

I have an Excel file that tracks the maximum elevation of the sun throughout the year, one row per day, given a specific lat/lon. If I edit the lat/lon the daily maximum elevation changes.
I'd like ...

**0**

votes

**0**answers

5 views

### NVivo-exporting a matrix to excel

After creating a matrix coding query with cases down the rows and coding categories across the columns, NVivo allows you to filter the matrix by row or column values, which is very helpful. However, ...

**0**

votes

**0**answers

7 views

### Link x2 Tables in Excel with Name Column in Second Table updated from Name Column changes in Table 1

I have a problem in linking name changes and alphabetically sorting the Name Column in Table 1 with the name column in Table 2. I shall be extremely grateful for any help: I am pretty much an ...

**0**

votes

**0**answers

23 views

### MS Excel with error messages

I have MS Excel spreadsheet with lots of tabs and 1 tab with workbook connections linking to other spreadsheet. It was working fine and after I have done the update, this message error appears:
This ...

**0**

votes

**0**answers

17 views

### Varying Chart Range Based on Drop Down Lists

I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list.
I have 3 selections for my drop down list: All, Alberta and Saskatchewan....

**0**

votes

**1**answer

45 views

### Excel Chart with Different Series Lengths

I run a pool league and I have a chart of player handicaps over time. Handicaps change over time based on performance. Since not all matches are played on the same days, I chart against the ordinal ...

**0**

votes

**0**answers

11 views

### How can I set up a bar chart to have two bars for each product on different axes that don't overlap?

I am trying to put together a Pivot chart and would like to have two values associated with each of our products, each displayed on a separate bar. One of these bars is Sales (Tonnes), and the other ...

**0**

votes

**0**answers

21 views

### Column “skipped” when opening file in Excel

When opening some shared files in Excel, some columns are "skipped". They are not hidden but they are not visible in the window.
For example, Column A is not visible. At first look, it seems that the ...

**0**

votes

**1**answer

12 views

### Excel - Pivot table from multiple Tables with the exact same columns

So I've got Datasets from multiple third party sources, which have the exact same layout.
I put them into excel into 2 Tables like this:
Table 1 from source1
Year Month InfoType Source ...