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.

Filter by
Sorted by
Tagged with
0
votes
0answers
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
0answers
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
1answer
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
1answer
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
1answer
14 views

Conditional VLOOKUP based on dates

I have two tables I want to merge in Excel: +---------------------+-----------------------+ | Date | Email | +---------------------+-----------------------+ | 2019-07-...
1
vote
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
3answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
3answers
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
2answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
0answers
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
4answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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 ...