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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 views

Cut and paste function changes formulas in spreadsheet

I'm trying to sum the total number of hours within a set of rows. I've created formulas that calculate the total number of hours based on a weighted probability. At times, totals within cells will ...
hilbig09's user avatar
0 votes
0 answers
23 views

How to remove values in conditional formatting

I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...
sc222's user avatar
  • 1
0 votes
1 answer
27 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 ...
SkyGuy15's user avatar
2 votes
1 answer
28 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 ...
alm's user avatar
  • 23
0 votes
1 answer
41 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 ...
jgran's user avatar
  • 3
-1 votes
1 answer
40 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 ...
Hasan's user avatar
  • 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 ...
John Boyd's user avatar
0 votes
1 answer
17 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 ...
Mr.Fatality's user avatar
0 votes
1 answer
30 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 ...
doraemon's user avatar
  • 157
0 votes
2 answers
64 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 ...
Garry Gorn's user avatar
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 ...
S_Pochedly's user avatar
0 votes
0 answers
48 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 ...
Choufleur235's user avatar
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 ...
Dominique's user avatar
  • 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 = {...
doraemon's user avatar
  • 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 ...
SottoVoce's user avatar
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 ...
gee_enn's user avatar
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 ...
Nick P's user avatar
  • 1
0 votes
2 answers
34 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) ...
ludicrous's user avatar
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 ...
Panki's user avatar
  • 152
0 votes
0 answers
27 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 ...
Edward Xu's user avatar
-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 ...
Christy Weber's user avatar
0 votes
1 answer
92 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 +...
Earl John Delos Santos's user avatar
2 votes
2 answers
572 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 ...
Jason Thien's user avatar
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 ...
provocative's user avatar
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) ...
Magoo's user avatar
  • 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$...
Abdullah Al Mahmud's user avatar
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 ...
Damir Tenishev's user avatar
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 ...
matt's user avatar
  • 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 ...
Carlos's user avatar
  • 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 ...
miken32's user avatar
  • 549
0 votes
1 answer
33 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. ...
SD-1908's user avatar
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 ...
Apollo's user avatar
  • 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 ...
Apollo's user avatar
  • 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 ...
Alan Frame's user avatar
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 ...
matt's user avatar
  • 3
0 votes
1 answer
60 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....
user93353's user avatar
  • 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 ...
DaveG's user avatar
  • 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 ...
DeNaeL's user avatar
  • 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 ...
timucin pusat's user avatar
-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 ...
Niklas E.'s user avatar
  • 288
0 votes
1 answer
98 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 ...
Michael Lakner's user avatar
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 ...
Steve's user avatar
  • 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 ...
JM63's user avatar
  • 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 ...
NickHallick's user avatar
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 ...
scorpdaddy's user avatar
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/...
KSPR's user avatar
  • 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, ...
Basj's user avatar
  • 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 ...
Barbara-Ann Coetzee's user avatar
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 ...
babipsylon's user avatar
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 ...
Alex Robinson's user avatar

1
2 3 4 5
512