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.
8,809
questions with no upvoted or accepted answers
0
votes
0
answers
69
views
How to tell Excel what date format to read cells as WITHOUT changing the cell content?
I'm opening a CSV file which contains dates in the European format, dd/mm/yyyy. When opening it with Excel, Excel thinks they are in the American mm/dd/yyyy format, which makes sorting/filtering just ...
0
votes
0
answers
28
views
Find a chart by his title in Excel spreadsheet
I have an Excel document with numerous charts on one of its sheets. I need to locate a specific chart by its title. Is there a method, similar to using the search and replace tool, to easily find the ...
0
votes
1
answer
86
views
Freezing Row and Column both same time in Microsoft Excel
I have been trying to freeze Row (A2) and Column (B1) same
time by View > Freeze panes
but unable to do. Please let me know, how to do?
With Regards
EinfoMail
0
votes
2
answers
88
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
0
votes
0
answers
255
views
Microsoft Excel for calculating overtime based off daily AND weekly values
I’m trying to create an expense/income spreadsheet but my hours vary from week to week, therefore as part of the income section I have a place to enter my daily hours, call it the “Hours cell”. The ...
0
votes
0
answers
18
views
2 way link between cells of already linked worksheets
I have a Work In Progress (WIP) workbook where all the projects are in different states of repair and the data linked to other sheets based on the state of repair it's in. (Tear Down, In Quoting, WF ...
0
votes
1
answer
113
views
How to open nested tables from power query, in new sheets?
In excel, I have a power query which loads a table with nested tables. In the query editor window, I can click the Table and drill down which is great.
Problem is, when I do save and close, and return ...
0
votes
0
answers
32
views
Strange excel copy/paste behavior
My spreadsheet (in Excel online) produces the following behavior when copying the formula "=max(A2,2)" from cell B2:
You can see that Excel has adjusted the reference from A2 to A3 ...
0
votes
0
answers
96
views
Why don't Word and Excel save files on exit?
Why don't Word and Excel save files on exit?
It started about a month ago. Whenever I exit either Excel or Word, they offer to save the changes and I select Yes. Yet the files remain unchanged.
If I ...
0
votes
0
answers
94
views
Suming up data based on Unique ID
So I have a ledger on Sheet 2 with a Unique ID in Column B, In Column G I have the amount of the check. I am trying to get the values of Column G to Automatically fill to the corresponding Unique ID's ...
0
votes
1
answer
71
views
Hidden Personal Macro Workbook Opens upon running macro to close ActiveWorkbook
I have a macro that I have coded to close the activeworkbook after running a series of formatting and saving it as a PDF. However, it opens a hidden version of the personal macro workbook immediately ...
0
votes
0
answers
51
views
How can I write an excel formula which looks at data in one range and produces a new cell with its corresponding calls?
and thanks,
It is hard to describe but easy to understand with an example,
I would like to make Table 2 from the data in Table 1 like in this example
I have tried a combination of TEXTJOIN and ...
0
votes
0
answers
307
views
An error occurred but no ODBC error information was available
I have an odd issue with Excel 365 v16.0.16827.20278 installed on a host machine. When trying to access an ODBC source, used successfully by several other individuals, Excel throws the error
An error ...
0
votes
0
answers
41
views
Old Excel temp files appearing when copying folder (Google Drive)
I use Google Drive on Windows 10.
I have a template folder in a Google Drive for Desktop (formerly file-stream) folder with an Excel spreadsheet in it. I occasionally update this spreadsheet and give ...
0
votes
0
answers
35
views
Export and edit XML metadata in Diagrams.net?
I have a large UML class diagram which I can open in diagrams.net. I also have an Excel file containing metadata for each of those classes. I would like to add the metadata from the Excel file to the ...
0
votes
1
answer
78
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 ...
0
votes
1
answer
88
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
2
answers
107
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
2
answers
219
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
0
answers
47
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 ...
0
votes
1
answer
465
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 ...
0
votes
1
answer
43
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 ...
0
votes
0
answers
26
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 ...
0
votes
1
answer
35
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. ...
0
votes
0
answers
21
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
1
answer
47
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 ...
0
votes
0
answers
44
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 ...
0
votes
0
answers
36
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 ...
0
votes
1
answer
94
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/...
0
votes
0
answers
76
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 ...
0
votes
0
answers
649
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 ...
0
votes
0
answers
64
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 ...
0
votes
1
answer
70
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
91
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
225
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 "...
0
votes
0
answers
59
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 "...
0
votes
1
answer
110
views
Need help for identifying common rows based on multiple column match data in 2 excel files
I have 2 excel files. I want to compare the sheet1 of file-1 and sheet1 of file2 and then get all the common/matching rows. Rows in 2 separate files can be in different row positions
1st XL file
...
0
votes
1
answer
53
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
0
votes
0
answers
112
views
How to create Excel histogram from frequency table?
I have an Excel table with two rows.
One header row with positive integers representing different event properties and another row with the frequency of events with said property number.
Here's a ...
0
votes
0
answers
69
views
Power Query: Working Query Fails if Moved Out of Workbook into External File
I am using Power Query in Excel for Microsoft 365.
This post is a follow-on to this one:
Power Query: Combine Subset of List of Tables that Exist
The Power Query shown below is not the solution I ...
0
votes
2
answers
55
views
xlsx table entry displays as a number like 20.41, but the actual is 2/2/1900 12:00:20 PM
How do I just get the number value? Whenever I click on it, it just returns to date form and loses the exact value it was before. For the example included, after clicking on it it turns into date ...
0
votes
1
answer
60
views
Not sure what function to use?
I am trying to make a table to do some easier real estate math.
I am going to have a drop down list for my categories, and a drop down list for my number of bedrooms.
I want Excel to look at the ...
0
votes
0
answers
42
views
Vlookup with radar graph
i have a simple radar graph setup, 1 column for headings and 1 column for results. The graph works as normal until…
Id like the ‘results’ column to be auto filled using a simple vlookup formula. Such ...
0
votes
0
answers
52
views
Creating a dropdown menu from a list in excel
I have a column in excel of the following form:
Column 1
['a', 'b', 'c']
['d', 'e', 'f']
I want to create a dropdown menu in each cell of the column where the possible options are the elements in ...
0
votes
1
answer
59
views
Excel Line & Scatter Graph - Plotting Scatter Points
Firstly apologies if I miss anything or get anything wrong, I am more familiar with StackOverflow than SuperUser. So please don't hesitate to ask for more details or to improve my question.
I am ...
0
votes
0
answers
30
views
Removing the unwanted data from Scattered plot using Excel
I want to keep the portion in the
black and remove all the other data .how can i do so please help me here.
0
votes
2
answers
75
views
Excel - concatenate from reference columns 2 across entire table
I have a data set that looks like this:
161 169 181 193 241 253 238 238
165 173 181 191 253 271 232 238
And I'd like to reference the data set in a new table that ...
0
votes
0
answers
92
views
How to add values under the same group in Pivot Table?
I have a Pivot table that has several fields as attached in the picture. I would like to add all the quantities under the same ID 1, I have tried to moved this field into "Values" are but I ...
0
votes
1
answer
36
views
Trying to sum cells depending on text at the top of a column and beginning of a row
I'm trying to create a budget template in Excel that can be easily expanded without needing to update formulas to include new additions. On the summary sheet of the workbook, I have two columns for ...
0
votes
0
answers
55
views
Need Help Preventing Excel from Auto-Transforming CSV Column Data
I'm encountering an issue when opening a .csv file in Excel it automatically transforms some data in it from string to number and it ruins the data.
Currently the CSV looks like:
names,Ids
John,Adam,...