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.
25,557
questions
0
votes
0
answers
17
views
Conditional formatting not formatting dates
The conditional formatting is not picking up all dates. The rule should be any which are less than today should be orange.
Any help appreciated
Rule's Formula : =F3<TODAY()
Applied to a whole ...
0
votes
2
answers
29
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
- 2,071
0
votes
0
answers
15
views
How to delete the first row from the list in a column in power query?
I have a table with a column called custom:
I would like to delete the first row of every list in the column:
Is there anyway to do this?
The code is as below:
let
StDt = [start],
AllDates =
{...
- 113
0
votes
0
answers
24
views
Seeking help in debugging a formula on Excel for Mac
The following is returning a #VALUE! error:
=SUMPRODUCT(IFNA(@OFFSET(AllFoodItems,MATCH(@DailyFoodItems,AllFoodItems,0)-1,MATCH($A12,Nutrients,0),1,1),0), OFFSET(DailyFoodItems,0,B$3))
My challenge ...
0
votes
2
answers
57
views
Trying to turn rows of data into 4 columns of data...with a twist in Excel 365
I'm trying to turn rows of data into 4 columns of data.
All data is currently in 1 Column and tens of thousands of
rows. Each user usually has 4 rows of data associated with them:
Username1
ID1
...
- 3
0
votes
1
answer
53
views
Stack Every "Nth" Column
I am trying to stack the data of every 5th column on top of each other leaving out rows with blanks.
I found an example that was using the same kinda logic, but it seems to cut off some off the bottom ...
- 1
0
votes
2
answers
26
views
How to add a keyboard shortcut for a macro in excel
I want to add a custom keyboard shortcut for a Macro (to zoom in and out) in MS Excel. It works very well with Word thanks to this answer, but on Excel (at least with Version 2310 that I'm running) ...
0
votes
1
answer
53
views
Active Directory - ß vs. ss
I'm trying to unify the streetaddress attribute of our users. In German, the character ß can also be represented as ss.
Some users have Examplestraße as streetaddress value, while others have ...
- 152
0
votes
0
answers
25
views
How to turn off the automatic alignment to cell borders in microsoft excel?
In microsoft excel, the page border always automatically stick to the border of cells.
I don't know how to exactly phrase this phenomena. We know that the area in which we are able to view the data ...
-1
votes
1
answer
60
views
How to convert a column with multiple values into a single row with many columns
My excel file has 213,262 records - approximately 43k claims. There are multiple CPT codes for each claim listed in a single column. I need to convert each claim to 1 row with multiple columns, a ...
0
votes
1
answer
71
views
I want to create a folder that what I put in the name textbox is the name of the created folder
Private Sub cmdSave_Click()
Dim msgValue As VbMsgBoxResult
Dim startPath As String
Dim myName1 As String
msgValue = MsgBox("Do you want to save the data?", vbYesNo +...
2
votes
2
answers
561
views
Dragging cell values in fixed increments
I'm using Microsoft Excel 2021
I wish to be able to drag the cells in a column down in increments of 22 for example I typed in this in a column
L25
L47
and ideally, when I drag this it turns into
L25
...
- 21
0
votes
3
answers
56
views
Using Excel to separate complex many-to-many relationships
I have a set of data in excel that follows the below format:
Table displaying data and its attributes/relationships
Image displaying relationships between High, Medium and Low level attributes
I need ...
0
votes
0
answers
36
views
365 Spreadsheet locked for editing
OK - I know - there are hundreds of solutions out there - just use Google.
The very fact I'm posting indicates that those solutions haven't worked for me.
I'm running Win 11 (updated a few hours ago) ...
- 241
0
votes
2
answers
46
views
How to shorten Excel OR function for many conditions?
As shown in the data, I want to determine whether a student passed (failing if s/he gets less than 40% in any subject). I can do this using many OR's inside IF.
My formula: =if(or(b3/b$2<0.4,c3/c$...
0
votes
0
answers
17
views
Is there a way to duplicate cell from above in Android Excel? [migrated]
On Windows the Excel has shortcut Ctrl+D which copies the content of the cell from the cell above.
Is there any way to duplicate cell from above in Android Excel without copy/paste? Maybe a kind of ...
- 103
0
votes
1
answer
46
views
Using Filter Function and Dynamically Changing Column Based on Value in Another Field
I have an Excel table called "Participants". I want to filter out the delegation name (in this formula Participant[Delegation] and the name of an event. There a series of different events ...
- 3
0
votes
1
answer
31
views
Filtered list of items in column A if item x is in any column from B to X
I’m working on an Inventory system for a restaurant chain with a large number of recipes and their corresponding ingredients. I have an excel sheet with all the recipe names in column A, and columns ...
- 1
0
votes
0
answers
18
views
Determining SYLK error record number
I'm writing some code to build SYLK files and occasionally I'm getting an error message from Excel "Cannot read record X" where X is some mysterious number. I've tried counting records in a ...
- 549
0
votes
1
answer
32
views
Connecting to a hyperlink found in another workbook
Is is possible to create a usable hyperlink to a URL listed in another workbook?
I'm creating a dashboard link to a social media post with the most likes. The post's URL is listed in another workbook. ...
- 1
0
votes
1
answer
21
views
Can one use data already fetched by Apple Stocks?
I have this Home Office edition of MS Excel for Mac and I was playing with Google Sheets earlier, chiefly with the GOOGLEFINANCE function, when it occurred to me that Apple Numbers might have a ...
- 141
0
votes
0
answers
48
views
Apple Stocks data on MS Excel? [closed]
I have this Home Office edition of MS Excel for Mac and I was playing with Google Sheets earlier, chiefly with the GOOGLEFINANCE function, when it occurred to me that Apple Numbers might have a ...
- 141
0
votes
0
answers
16
views
Graphs from Table with multiple time series
I wish to create multiple graphs from the table below. Each graph should be based on the
value in Column2. I.e. 1 graph for CXC4012144 one for CXC4012234 etc and plot the values in Column 8 and 9 as ...
0
votes
2
answers
39
views
How to properly count multiple criteria from ranges in a separate sheet?
I have a master data table in a worksheet (worksheet name 'Data'; table range called 'MasterData'). This includes data about participants in a conference (name, nationality, etc.) and whether each ...
- 3
0
votes
1
answer
59
views
Microsoft Office: Your account has multiple licenses
So I have an older laptop which came with Office Home & Student 2016 for PC. I now got a new laptop with Office Home & Student 2021.
Both laptops use the same live.com account for the licenses....
- 561
1
vote
1
answer
40
views
Convert column of data to comma separated cells of data based on record file presence
I have to migrate a database from one format to another.
The servers accept the data in different formats.
The current issue is image URL files.
DATA BASE 1) = WHERE IMAGES WERE DOWNLOADED FROM
DATA ...
- 11
0
votes
2
answers
44
views
Excel 365 - retain all changes to a file beyond 60 days
Our order review process requires that we be able to tell when a company rep has corrected or changed anything on an order form. The order form is currently an Excel 365 spreadsheet.
A recent revision ...
- 171
1
vote
1
answer
34
views
Copying to Microsoft Excel with specs of text
When I copy text from another program to Excel, it does not preserve the properties of the text, such as being bold or italic. It pastes it as a plain text. Is there any way to save the text to Excel ...
-1
votes
1
answer
71
views
wrap text feature in Excel changed / inconsistent behaviour
Excel's "wrap text" (german: Textumbruch) behaviour seems to have changed.
Whitespace at the end of the cell used to be cut off (not transferred to the new line) if "wrap text" is ...
- 288
0
votes
1
answer
89
views
Average SumIf, differentiate between Zero and Blank
I need some help from the almighty community here.
I have a sample set of data here. I am trying to sumif some data and then average it. the goal being to get a running average of my budget but only ...
0
votes
1
answer
44
views
Looking for suggestions for more efficient Excel FILTER solution
I'm creating a dashboard that will return data based on a user selection of two criteria, in this case the agencies that made a referral will be returned based on the quarter and program they referred ...
- 1
-1
votes
0
answers
32
views
EXCEL Functions
Is there an EXCEL function that I can use to round a cell's value UP to the next whole number but also require a minimum value to be entered in the cell?
Example
Children in Ms. Schmoe's class need to ...
- 1
0
votes
0
answers
39
views
Mouse tilt buttons only work when window is not "active"?
For some reason I have a window where when it is active and I am working within it the vertical scroll will work on my mouse but not horizontal. When I click out of the window and mouseover it both ...
- 49
0
votes
0
answers
23
views
Excel not propagating values changed while file closed, not updating calculations, formulae
An xlsx file is essentially a zip of XML files and such. I have an xlsx file that is modified by another, not-Excel program. It updates values on sheet A. Sheet B has formulae based on values on ...
- 101
0
votes
1
answer
40
views
Excel Separators when importing from Web
There is this very cool function in excel where you can import a data source from a web url.
I want to import Tabular Data from a Wikipedia page: https://de.wikipedia.org/wiki/...
- 115
0
votes
1
answer
16
views
Autocomplete Excel formula with keyboard shortcut
When typing the beginning of a function name in a Excel formula, there is a list of suggestions:
How to accept the currently highlighted suggestion, and autocomplete it with a keyboard shortcut, ...
- 1,738
0
votes
1
answer
28
views
Windows 11, Excel
Is there perhaps a formaula that can combine the informations in multiple cells into one in another cell - I know I am not asking this correctly.
Please see below picture:
I need te information either ...
0
votes
0
answers
19
views
Microsoft excel: Queries and connections - option to update data manually is greyed out
For my link to other excel workbook table:
For some reason, the update: manual option is greyed out for this query link in excel Data --> edit links.
I don't want the data to update automatically ...
- 103
0
votes
2
answers
58
views
how to count a variable amount of numbers within a set that sum to a given fraction of the total sum
I have a dataset in the form of 8 columns (separated based on additional variables that aren't directly relevant here) that vary in size each week and each data point is an effectively random positive ...
- 117
0
votes
1
answer
121
views
Excel formula to calculate based on pieces required, pieces per box and shipments per day
I need a formula that will calclate the pieces required for each shipment as close to equally as possbile based on the amount of pieces in a box. I need it to calculate the shipments to match the ...
- 1
0
votes
2
answers
37
views
Excel formula, count cells up to the last higher than zero
I´m trying to find out a formula in excel which would count cells up to the last cell which contains value higher than zero.
Example row: 0,1,7,0,0,1,3,4,0,0. Here the output should be 8, because 8th ...
- 3
1
vote
1
answer
55
views
Why autofill with keyboard shortcut doesn't work in my Excel 2021?
According to this post, in order to do autofill with keyboard (without using double clicking on fill handle with mouse) one can select the cells and then press Ctrl + D to autofill down and I can ...
- 13
0
votes
0
answers
63
views
Windows 11: Issues with opening a text file containing accented characters
I'm having some issues in the way in Windows 11 Pro is handling text files. I live in a two language environment - English and French.
For several years I have been using a number of Excel VBA macros ...
- 43
0
votes
1
answer
78
views
Is it possible to turn off certain Excel functions related to conditional formatting and data validations?
I have come across a monstrosity of an Excel, while it does not make any sense in my opinion to have this Excel. Some of my colleagues at this large corporate are extremely fond of using it. ...
- 181
0
votes
0
answers
37
views
How do I fix Excel instability after using PowerQuery?
I've been working on some VBA code to import and parse PDF files using PowerQuery. The code itself is working fine, but after some column-related errors (I had more columns defined than some of the ...
- 1
0
votes
1
answer
32
views
How to use conditional formatting to progressively turn green to red as the distance between two dates increases
Cell B3 contains a date, under "Email Delivery Date". Cell C3 Contains a date as well. What is the formula or formulas that i am supposed to use in order to have those cells turn from green ...
0
votes
2
answers
60
views
Create a table from row values?
I have a table that looks like this,
Scenario 1A
Scenario 2
Scenario 3
Function 1
Function 1
Function 2
Function 2
Function 3
Function 3
I want a table that lists the scenarios by the functions ...
0
votes
0
answers
44
views
Some of my mouse buttons are not working in Excel
I am using Excel as part of Microsoft 365 Office 16. I am using a Logitech G502 mouse. The regular functionality of the mouse is working (right/left click & scroll up/down) but any of the "...
- 49
0
votes
0
answers
32
views
How to sum before average in a Pivot Table
I have a big report that contains the following columns:
timestamp,hostname,type,count
I have a line every 5 minutes for each node that represents the transaction the node managed, both of type "...
- 1
0
votes
1
answer
61
views
How to create a sorted table summary of the count of a categorical column in Excel?
I have a dataset like:
Animal fruit
cat apple
dog grape
cat cherry
cat pear
dog cherry
horse melon
cat lemon
I would like to create a summary table counting each occurance ...
- 103