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.

learn more…| top users | synonyms (2)

-1
votes
0answers
8 views

Pulling subset of data from Master sheet to individual sheets based on criteria, without using VBA

I have a master sheet with some sales data, the simplified view is like this:Date, Product, Quantity, Price, Amount, CustomerThen I have another workbook with individual Customers. I want to be ...
0
votes
0answers
5 views

(shrink/elongate) range size but distribute values equally in excel

I have a number of project costs per month that I am trying to normalize to analyze.Around 100 projects with different lengths (shortest is 18 months and longest is 123 months)I'm trying to average ...
-1
votes
0answers
17 views

text editor in Notepad++

I have multiple ascii files(each of size of 21 MB) of a model output. These files are supposed to contain the water depth along the river channel and floodplain. It should contain either -9999.0 or ...
0
votes
0answers
14 views

Add condition based on Ted ID in table

The code works by looking to see if column (“NamedRange”) exists as a named range in the template workbook and then returns the report balance if it does exist. However I want to add logic where for ...
0
votes
1answer
19 views

Sub-values for a specific category in stack chart

Is there a way to plot a stack chart wherein one specific category within the stack can be further sub-divided and displayed on the chart? This way we can see the total for that category as well as ...
1
vote
0answers
20 views

Excel chart – massively create two point lines

I want to create a very custom grid for an Excel chart. I am trying to create a grid system like this: It's called a tripartite graph. For the vertical and horizontal gridlines it's easy, I just ...
-1
votes
0answers
15 views

Want to record value from a live data after each 30 minutes [on hold]

Greetings to all.I have excel-2010 sheet which is linked with a website. some columns of this sheet changes after every thirty minutes.But i want to store the value in another cells before it ...
1
vote
2answers
37 views

Can Excel automatically convert an entry into a clickable link inside the same workbook?

Please let me better clarify my question. What I would like to do is the following:1) Have a workbook with, say, 100 worksheets2) Each worksheet has a different tab name3) Each worksheet ...
-4
votes
1answer
24 views

I want to put the amount I owe in one column and the amount I pay down another and have the amount I owe reduce every payment [on hold]

I want to put the amount I owe in one column and the amount I pay down another and have the amount I owe reduce by that amount each payment. Each payment being different amounts.
-1
votes
0answers
21 views

Duplicate sheets while retaining and updating incremental formatting in cells

Last year I built and formatted 52 tabs (sheets) names 'Wk1, Return1''Wk2, Return2' both up to wk52 and Return52. There is a lot of formatting in individual cells within these sheets. Wk2 takes data ...
0
votes
1answer
19 views

How to add an existing Excel userform & VBA to new spreadsheet (For Dummies)

I have an end user who exports data from an accounting program and each time they export and create a new spreadsheet, they need to add a userform and VBA file. Below are the instructions I have ...
1
vote
0answers
13 views

Excel—insert underline to separate weeks

I have an excel worksheet with a column of deadlines. My project managers want an underline added to the last row in a given week to visually separate between weeks. How can I do this without having ...
2
votes
1answer
13 views

Excel 2010 line chart - how to have the x axis show mmm format (e.g. Jan Feb etc)

I have a table of data, with one row for each day of the year (1/1/2018 through to 31/12/2018). I want to show this on a line chart with the x axis labelled with the short text format of the dates, so ...
-3
votes
1answer
51 views

Limits of creating a database with Excell [on hold]

I'm creating a in-house database to track the progression of multiples files. An Excel sheet should be enough for our current needs, but I have three quesitons regarding Excel limits:is it possible ...
1
vote
2answers
25 views

Excel how to deactivate “Most Recently used function” suggestion from drop down list

I am currently using Office 365 on Mac.For the "Drop-down Function-suggestion list", Excel have started suggesting the "most recently used" function, as opposed to JUST suggesting it in alphabetical ...

153050per page