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,565
questions
0
votes
1
answer
23
views
EXCEL - Moving a multiline address in a cell to multiple cells for a set of data
I have hundreds of postal addresses formatted into single cells and I want to take each line of the address and have it put into its own cell in the row so that street address, city, post/zipcode etc ...
- 3
2
votes
1
answer
26
views
Separately color all rows for unique clients listed in one column
I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help.
I have an enormous data set that ...
- 23
0
votes
0
answers
30
views
Create a hierarchy between tables following relationship
I am confused with pivot tables, and it's a recurring issue! Say I have put 2 tables in my data model (classes and students):
tables classes and students
My model is this one:
enter image description ...
- 3
-1
votes
1
answer
39
views
How to insert data from notepad to MS Excel?
I have text written in Notepad (Every statement is in a new line). I want to put the text in cells in Excel without losing any data. I want the lines to spread in cells rather than pasting them all in ...
- 21
0
votes
1
answer
43
views
How to convert % to decimal in excel/ Libre Office Calc formula?
I am having trouble to calculate the compounding trade lot size as it should multiply the keyed value such as 0.01 x the % gain entered. But if I put 100% gain and do starting value*100% value it ...
0
votes
1
answer
16
views
Trying to Use Solver with Different Constraints
I want to give instruction to an Excel to give me a sum of certain amount by changing only Quantities. In the pictures, let say I want to get the sum of 250 (cell H16) by changing cells G5:G15. I can ...
0
votes
1
answer
29
views
How to expand the dataset with 0.5 day in power query?
I have a excel dataset with the following format:
I would like to generate Dates between Start and End Date. However, there can have non integer days in the duration column. How to expand the row if ...
- 157
0
votes
1
answer
52
views
How to handle protected view errors in Excel VBA macro
Introduction. I have a local website, and one of its pages is used for downloading an Excel report by several users on their PCs. The file is automatically generated with some data from our database ...
0
votes
1
answer
21
views
Excel - Target Line on Graph from just 1 Data Point
I am trying to chart out actual (performance) data points against target on a graph. Is there a way to produce the target line from just 1 value? It would be assumed all the performance variables ...
0
votes
0
answers
42
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
42
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
2
votes
2
answers
51
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 =
{...
- 157
0
votes
1
answer
49
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
59
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
54
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
33
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
56
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
26
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
61
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
89
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
570
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
64
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
39
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
64
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
47
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
34
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
22
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 ...
- 151
0
votes
0
answers
49
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 ...
- 151
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
42
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
45
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
96
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
33
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
40
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,748
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
20
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