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,130
questions
0
votes
2
answers
48
views
How to maintain auxillary calculations on separate sheet in Excel?
In Excel, I'm trying to maintain some auxiliary calculations on a separate sheet.
But each time I add a row or column in the main sheet, Excel keeps updating the formulas on the "side-sheet"....
- 101
0
votes
1
answer
22
views
How do I change the vertical axis on an Excel graph to display significant time periods? The gridlines are set at odd times
I would like the chart to reflect a 24 hour period and be able to choose the times displayed in the vertical axis
- 1
0
votes
2
answers
15
views
Can the Lookup_range and result_range of an X-Lookup refer to a column name (column_name) instead of the column range(A:A)?
hoping an excel wizard see's this and can help me. I want to do an Xlookup[XLOOKUP(search_key, lookup_range, result_range)] but instead of defining the lookup_range and result_range as 'A:A' for ...
0
votes
1
answer
26
views
Auto Stoplight Colored Chart
Does anyone have code that will automatically color a traffic light-type icon for a red-yellow-green status? The only way I know how to do this is with multiple steps that have to be replicated each ...
- 1
0
votes
2
answers
47
views
Split cell into three columns without losing leading zero
I have a column with a phone numbers without hyphens. I am using text to columns to latter recombine the numbers with hyphens but it's dropping leading zeros in the last cell.
You are seeing leading ...
0
votes
1
answer
50
views
MS Excel graphs do not follow decimal separator setting
On my computer, I use a dot as a decimal separator. However, in one Excel sheet, I have to use comma as the separator. Therefore, I wrote a simple VBA script using events on opening and closing the ...
- 101
0
votes
0
answers
53
views
Excel Discrete column-wise selection from area
I'd like to be able to select an area column-wise (as individual columns). Manually holding down CTRL works fine for a few columns but when you've got 200 to select it becomes tedious. I'd like to be ...
0
votes
0
answers
9
views
Google Sheets: Return a list of names if a column in the same row is empty [migrated]
I have the following values in Sheet A:
A B
1 Josh Awarded XP
2 Jane (blank)
3 Peter (blank)
4 Mary (blank)
5 Josh (blank)
6 Peter (blank)
I want to reflect the above ...
- 101
0
votes
3
answers
63
views
calculating the average of column that is not a number
So I have 2 sheet, the first one contains student's name, subject, and their grade.
Sheet1 :
A
B
C
Mark
Math
A
Dave
Physic
C
Carol
Math
B
Dave
P.E
B
Carol
Physic
A
Mark
Physic
A
The second one ...
0
votes
0
answers
20
views
Syncing Excel cells with Word table cells on SharePoint - Possible?
I have some Microsoft Office files on SharePoint:
An Excel file (.xlsm)
A Word document (.docx)
I want to create a table in the Word doc and have a block of its cells automatically sync with a ...
- 682
0
votes
0
answers
25
views
Highlight a cell if a another has a greater value than a different cell
I am looking to have cell A1 turn green if the value of A2 is greater than the value of A3. Is there any way to make this happen with conditional formatting?
- 1
-1
votes
1
answer
37
views
How to count cells that are within specified tolerance with Excel?
I am trying to count the number of cells that are within a certain tolerance using =COUNTIF(). The +/- tolerances are in different columns and I need to apply this formula to multiple rows that have ...
- 1
1
vote
0
answers
33
views
Excel refresh to import external data
I have a lot Excel files containing external data connections to a local database. I have sql queries to extract data. Since few weeks refresh is not working sometimes to one user.
I discovered what ...
- 11
0
votes
0
answers
41
views
Pdf table pasted into excel via word but there is hidden text i dont want. I cannot find how to remove
My excel data appears to be cells like 200.00 BUT I cannot add up because the actual cell content is Money in (£) 200.00. So it has text at start and . at end that I don't see in the display. I just ...
1
vote
1
answer
18
views
Calculate duration between 2 milestones based on criteria
Given the following problem: An ice truck is rented for a certain duration with a start date "x" and an end date "y".
Example:
rental start date in cell b1 = 27/05/2025
rental end ...
- 13