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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
26,096
questions
2
votes
1
answer
33
views
Excel HSTACK multiple arrays where an array may be empty
I want to abut multiple dynamically sized tables to each other where any one of the tables may be empty.
For example, say I have the following:
where A3 has the following formula:
=LET(
a, ...
0
votes
0
answers
23
views
VBA timer stops running when using another Excel workbook
I'm using the following VBA script for a countdown timer in Excel. It works well, except that the timer stops running when I switch to another Excel workbook - is there a way to keep it running in the ...
0
votes
2
answers
29
views
How to match a number in a column to make sure its in another column
[excel][1]
What formula do i use to make sure the number in column B exists in any row within column A ?!
|----------------------------------------------------------------|---------------|------------...
0
votes
1
answer
31
views
In a pivot table - how to summarize by specific value
Here is a table:
I want to create a pivot table that will show me for each name, how much percent of "A" the name have, for this example:
Dan 100%
Ron 40%
Dafna 14.29%
Can you explain me ...
0
votes
0
answers
29
views
Password protected Excel file on usb drive file behaving strangely when clicked
Nothing unusual at first glance - a password-protected Excel file on a usb stick. Previously, put the stick in the usb port, double-click the file and enter the password to work on the file.
Now ...
0
votes
2
answers
131
views
Dynamic Array - How to Conditionally Generate Sums?
I have a formula that's meant to iterate through a dynamic range, generate cumulative rows (the #/# in "Tally" represents a number of pieces and a length in ft.) and stack them into a new ...
0
votes
1
answer
33
views
Filter function for column with values only
I have a master database that lists the company with associated products and the clinical trial phase the product is in for different diseases. I am trying to only pull in columns that have values in ...
0
votes
1
answer
33
views
How to create a single stacked bar chart with dual y axes in excel?
I have data pertaining to price-quantity bids are sorted according to price and looks like this:
I wish to plot a single stacked bar chart, something that looks like this image of single stacked bar ...
0
votes
1
answer
13
views
sum cells based on corresponding values in a data set in excel
Can someone kindly help with the following please, I would like to calculate the sum for each person if it says yes in the columns with the corresponding number
Person
Car
House
Job
Holiday
Sum
1
...
0
votes
1
answer
17
views
How to sum values based on unique values in other column when filter is applied
I have the following problem. There are order numbers in column A which are duplicated due to a different products in column B. What I need is to sum order values in column C only for unique order ...
0
votes
1
answer
96
views
how can a cell be mirrored or flipped in excel
Let's suppose I have cells in Excel with time duration data from a website, copied and pasted in a text file. The format is (hh:mm:ss), like 00:16:30 (equivalent to 0 hours, 16 minutes, and 30 seconds)...
0
votes
0
answers
27
views
I would like to automatically filter a large dataset for reference elsewhere based on the filters selected in a PivotTable
I would like to take this dataset and put it into a pivot table where it will be sorted into the items I want to select. I then want that to update the table with the dataset so that I can reference ...
0
votes
2
answers
52
views
How can I associate, group, or connect rows in Excel?
This might be a niche question so I'll try to generalize it as much as possible.
Upon extracting data from a folder with PDF files and after some data cleaning, I have the following in PowerQuery:
...
3
votes
2
answers
57
views
Can you combine stacked and clustered columns in an excel chart?
I am analysing failure modes of a machine using pareto analysis, but I keep adding more data and struggling to represent it correctly on the chart.
In the image linked below, the three bars represent ...
1
vote
0
answers
71
views
Strange Excel 365 font behavior while editing in cell after Aptos update [closed]
My Microsoft 365 installation just got updated to use the new Aptos fonts. Excel is now using Aptos Narrow (11 pt) as its default font. This is not a question about the merits, or lack thereof, of ...