Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
5 views

Excel drop down list based from other drop down lists

How to you get a ddlist to populate from a selection of another ddlist. I need to select an item from one of 3 tables. Cell g2= dTYPE is a list of 3 different table names (RP,DC,PVB) Cell g3= ddMFG ...
0
votes
1answer
13 views

Excel's base color scheme was replaced by pinks, purples, and blues. How do I revert to the “normal” MS color scheme?

Excel decided it wanted to shake things up and the only color schemes available to me are very bright pinks, purples, and blues, rather than the standard greens, reds, and blues of the "normal" Excel ...
0
votes
0answers
14 views

Excel formula help - exclude data if a checkbox is unchecked

I am working on a sheet to track my golf league scores and prize money. I came across an issue recently that i cant figure out. I have it set up to count the lowest score on a hole and assign a 'skin' ...
0
votes
2answers
20 views

subtracting the hours from a total of hours granted

I have difficulty in subtracting the hours worked (column B), from a total of hours granted (Column A) A simple subtraction between the two cells does not produce the desired result, probably because ...
0
votes
0answers
8 views

Dropdown creation to autofill entire table into another sheet

I need to copy data from one worksheet to another (within the same workbook) from 'Source' to '48597' based on selection from a dropdown list. In '48597', information is displayed across columns B:L....
1
vote
1answer
13 views

Remove column names from formulae (Convert into regular cell coordinates without sheet names)

I have a defined table of several rows and columns containing data and formulae. Some of the columns' cells' formulae are: =[@[Weight]]*1000 Where 'Weight' is the name of a column heading. I want ...
0
votes
1answer
14 views

Excel counting occurancens of specific order inside column

I have the following column in a Excel spreadsheet: A B Z A A B C Z Z A B A Z How do I count the orrucence of the order A B Z ? The result of the example should be 3. A -| first occurence B -| Z -...
0
votes
2answers
26 views

I would like to set up a macro to restrict an Excel file to a specific user from the list

I have an excel file which I would like to restrict it for only a certain users to view so because there are multiple files I would like to setup a macro which will restrict the files to a certain ...
0
votes
1answer
14 views

Set connections in excel to default to read

As I've create connections in Excel via, Data Menu Get External Data MS Access from Ribbon The connection that gets created by default is of Mode=Share Deny Write. I know I can manually change the ...
0
votes
0answers
16 views

Automatically add new series to COMBO chart in Excel

I'm trying to get a combo chart to automatically add new data series into it when the underlying named range is expanded. My excel chart is a simple combo chart with one series as a line (max ...
1
vote
1answer
17 views

Excel/Word losing pinned files - registry fix but why happening

I regularly lose my pinned files list in Excel, and have not identified a common cause. On reading into this, I find that pinned files are stored in Registry under ....\Software\Microsoft\Office\15.0\...
-1
votes
1answer
23 views

How to maintain multiple documents?

I have a list with different positions that form a schedule of prices. That list is over 12 pages long. Some of these prices are adjusted yearly, while others are not. So far, the adjustments were ...
0
votes
0answers
9 views

PowerPivot get the last value recorded for a date

I have a PowerPivot query where I have 3 columns: ID, Date and a Value. Every day is possibly recorded multiple values each on new row. so it looks like: ID Date Value 1 1/1/2019 654594 ...
0
votes
0answers
10 views

Data Validation - Using truth table to define list options

I have a worksheet where I would like two drop down lists, one for screw size, and one for screw length. Only certain lengths are available for each size, so I want the length drop down to read the ...
-1
votes
0answers
16 views

Automatically e-mail a client when first part of project is done in Excel [on hold]

Is this possible with Excel? Automatically e-mail a client when a value is typed in a certain cell. And as you see on the picture, there must be 3 or more e-mail templates. File example Example ...

15 30 50 per page