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,845
questions
1
vote
2
answers
57
views
How to paste Excel rows into Word as paragraph lines, not as a table?
I have a Word file consisting of text where each line is a link: free text with a URL behind it (Ctrl+K). I want to sort it, but Word refuses, maybe because the lines are links.
I copied it and ...
0
votes
0
answers
10
views
How to stack all non blank cells from a column in Google sheet? [migrated]
Here is the same question and its answer for Excel. I want this method for Google sheets.
How can I stack all non-blank cells from a column?
I am looking for a formula that will take all non-blank ...
0
votes
1
answer
62
views
Replace with wildcards in Excel or batch edit some wrapping formula
I'm only trying to delete some CONCATENATE() function from some formulas in Excel.
What I have; here 'Something' could be a lot of things (digits, <, >, texts, etc…
CONCATENATE("Something = ...
0
votes
1
answer
76
views
Trying to set up a exchanger formula in MS Excel
I'm working on a spreadsheet which helps me reformat data to include certain criteria based on Intellectual Property.
In my excel I have column A which includes a Country that indexes to column L and ...
2
votes
1
answer
120
views
Excel count if sum of other values <0.5
I want to count the number of employees that work less than 50% by department. Employees are identifiable by a number. One employee can have different jobs within a department made up of 3 times 20%....
0
votes
0
answers
6
views
How do I make a cells value equal the subtotal of a filterable column in a pivot table without including the autocalculated total value at the bottom
I'm trying to link a cell to display the subtotal of a column within a pivot table. I want to be able to filter using a slicer and have the number change along with the data, however it keeps adding ...
0
votes
0
answers
31
views
Macro for compressing/expanding formulas in Excel [duplicate]
I have looked for a while but haven't come across something that does what I am looking for. I'm not that proficient in writing macros and if this isn't possible I will find a different solution to my ...
0
votes
1
answer
52
views
Is there a way to list the names of excel sheets that contain a value?
I have an excel workbook with several sheets. The first sheet is called Master sheet and there I have a table with several names on column B (with a title first "Name").
Some of these names ...
0
votes
0
answers
51
views
Linking columns on different sheets
I'm very new to VBA coding (only dabbling for this specific project), so I would really appreciate any advice on an issue I'm having. I'm attempting to link a column range (A2:A300) on Sheet1 to a ...
0
votes
2
answers
63
views
Excel - Can you use both Relative R1C1 Reference Notation and A1 Reference Notation in the Same Excel File?
The question is straight forward. Can I use both Relative R1C1 Reference Notation and A1 Reference Notation in the Same Excel File?
I know that I can change between A1 and R1C1 Reference Style from ...
0
votes
1
answer
48
views
Excel - Get R1C1 Reference Style Option in Quick Access Toolbar (QAT Bar)?
Is it possible to get R1C1 Reference Style Option in Quick Access Toolbar (QAT) Bar in Microsoft Excel?
1
vote
1
answer
74
views
How do I know if I'm using Excel 2021 or Excel 365?
My Microsoft account has both Office 365 and Office 2021 which I bought recently for a new Win 11 PC. When I first installed 2021 and opened Excel I clicked on File, Account and it showed Office 2021.
...
0
votes
1
answer
34
views
Excel formulas for autofil
I am trying to autofill a cell based on a date selected in a column. Ideally I would like the date selected in the start column to be presented as a filled cell within the correlating column.
-1
votes
1
answer
59
views
Returning value within two column when it match 3 criteria
I would like to return a value 4.42295, if i choose MYR. If I choose SGD will return 1.32963 as picture show below. I had tried some formula in the picture but seem like cannot solve what i need. ...
0
votes
0
answers
60
views
Highlighting duplicates in Excel with VBA, multiple sheets
I have a workbook set up with a sheet for every month and then a summary sheet, so 13 sheets total. Each sheet, other than my summary page, have two sets of tables set up. A table for each week in ...
1
vote
1
answer
62
views
Macro for using Goal Seek over a range of cells
I'm trying to automate the GoalSeek function over a range of cells. Each cell in Columns I and J calculates a quantity of interest using two different methods, and the results must agree.
Each cell in ...
0
votes
2
answers
35
views
Compare data across rows in range
I am trying to solve the following problem in MS Excel:
There are two columns of data, one for types of food and one for how many of them are (in an inventory, say). I want a SINGLE formula that will ...
-2
votes
1
answer
80
views
Unraveling a nested IF statement to make it more user friendly
I'm trying to streamline a nested IF statement that my lab uses on a spreadsheet for keeping track of what we make every day for testing - it's a ridiculously complex statement that reads the value of ...
0
votes
1
answer
26
views
Protect Excel workbook WITH password AND share with NON-DEFAULT advanced parameters
In Excel 2007 it seems like I can do one of the two things separately, but not together:
I can share the workbook with non-default advanced parameters but without a password protection (Review->...
0
votes
1
answer
37
views
Sum specific cells from a column based on criteria from another sheet
I have three sheets. ScoreInputs, RawScores and ScoreMatrix.
ScoreInputs is basically a single column of raw input scores. Score Inputs
In ScoreMatrix, the first row is a list of score categories, ...
0
votes
1
answer
40
views
Adding date and time to excel document quickly
I am making a log and need to keep track of multiple items parsing through different stages. For further statistical analysis I need to have date and time added to each stage for the particular item. ...
0
votes
0
answers
49
views
Excel Vlookup Where Column to Search is identified in Preceding column
I am trying to figure out if there is a way to write a formula such that the Table_Array of a vLookup is based on a value from another column. Basically, I want the Vlookup to search on another sheet ...
0
votes
2
answers
44
views
Dynamic Drop Down List in Excel 365
I've created a spreadsheet that has a drop down menu of names to choose from.
The names are stored in a series of cells on a worksheet.
Each name has a priority number in an adjacent cell.
From those ...
0
votes
2
answers
47
views
Count number of instances that occur in a range across a month
I am looking to try and work out how many times across a month a message was posted between specific times, but not a specific date. Messages can be sent at any time, and I need to calculate how many ...
-1
votes
1
answer
69
views
Create a formula to sum all values number between two ranges
enter image description hereenter image description hereI would like to create a excel formula to sum up all values between two ranges when i choose the "cell range" for example between P-2 ...
0
votes
0
answers
17
views
Using excel to reference other workbooks, but using a cell to tell excel which other workbook to reference
I am trying to input data into a cell, and have the cell next to it reference data in a separate file to tell if if there is a match in a specific column in that other file. The goal is to use this ...
0
votes
0
answers
39
views
Searching a large list of strings for a set of strings that may or may not be present
I've looked up similar questions but the answers there don't quite fit my situation, which I think is more simplified.
I have a custom application that can export an .xlsx file listing feature codes ...
1
vote
1
answer
64
views
Adding formula to all existing formulas in an Excel sheet
I'm setting up a monthly call tracker for sales and customer service. I have almost everything built out, but I'm looking to add the IFERROR function to all cells in the sheet that have a formula in ...
1
vote
2
answers
50
views
Skip selecting single cells in column using keyboard shortcuts only
I'll try to articulate this as best as I'm able. Using Excel, I need to select a couple of cells in a column, skip one, then select a couple more, then skip one, etc. I know there's a keyboard ...
0
votes
1
answer
43
views
Ordering columns of string alphabetically
I have 3 columns of names that are several thousand rows long.
I need to arrange them in alphabetical order.
I attached a simplified image of the data (the sample table is on the left side of the ...
0
votes
1
answer
33
views
Need the formula for a holiday pay of 8 hours on 1/1
I need help with a formula please.
If cell c2 is a date of 1/1/2024 than cell L = 8.
Please help write this formula.
0
votes
0
answers
27
views
Excel history not showing full change
I have an Excel file saved in a locally-synced O365 directory. I opened it in the Excel for Mac desktop app today, and noticed the data in 3 columns were not in the correct rows.
I know this happens ...
1
vote
1
answer
37
views
Show a list where min. number > 5 in worksheet forumula
I'm trying to return a list with a given criteria
My current data looks like
A B
1 Anna 4
2 Brad 6
3 Claire 2
4 Dan 5
4 Evie 2
I want to select ...
0
votes
1
answer
55
views
Getting IFERROR to move to next row if I paste a value in the previous row
Not sure if the title sums up my problem enough. Basically, I am attempting to streamline my data entry by using formulas. How my data is set up is I have three tabs (Sheet 1, Sheet 2, and Sheet 3). ...
0
votes
2
answers
57
views
Looking to return a number based on the date that is entered
I am looking to try and work out how to get a return from a table, depending on what it is that you enter. As an example I have included an image of how the table might look. I have a range of 5 ...
0
votes
0
answers
26
views
Importing a range of formulas from csv or txt file starts with ' in excel and sheets [duplicate]
I am generating some image URLs with a python script and converting them to a formula. I have tried saving it to both a CSV and a TXT file as others suggested, but both lead to the same problem:
After ...
0
votes
3
answers
105
views
Excel: Sum all numbers in a column between two delimiters>
Let's say I had about 50 cells similar to the below. I want to sum only the numbers after the OT: and before the ). Some cells will not have OT: or numbers and thus should not be included in the sum....
0
votes
2
answers
40
views
VLOOKUP displaying wrong information in Excel
new to excel, and trying to do a simple task, where depending on the months in a month range, some percentage will be displayed. However, it's always displaying 0.
Here's a picture to help you ...
0
votes
1
answer
37
views
Microsoft Excel Conditionally Formatting Multiple Columns based on Adjacent Cell Text
Hello all, I have a question about how to apply a conditional format (cell color) based on (partial) text in the adjacent column. In the screenshot, you will see Column E has a list of zones. Listed ...
1
vote
1
answer
42
views
How to make excel clipboard copy formatting for more than 250 cells
When copying more than 250 cells and pasting via the excel clipboard, the formatting (like fill colour) doesn't carry over, but on the first ever use of the clipboard, formatting was copy-pasted ...
0
votes
0
answers
19
views
INDEX MATCH repeats last valid result
I've searched for this issue and I've found some that were close, but not quite, so forgive me if it has been asked and answered.
When using INDEX/MATCH, all my results are correct, except that the ...
0
votes
0
answers
12
views
Excel - populate pivottable axis dates for trendline
I have the following pivot table, showing products in the following level of details (LOD)
1- Year
2- name
3- type
The following picture shows them at LOD 1:
I want the chart to populate the missing ...
-1
votes
1
answer
20
views
how to use SUMIF to calculate a cell from the figures in 2 other cells based on the date
I have one cell that calculates a figure based on 2 cells, so for example target quantity is in C6 then the completed quantity is in D6 so cell E6 is "=D6-C6" but i only want it to ...
1
vote
0
answers
62
views
Replace ** to NULL in Excel
I have excel which contain ** as value along with other values across between Rows and Column. I'm trying to replace ** with NULL but using Find & Replace it's Replacing everything as it's taking *...
0
votes
1
answer
63
views
Matrix Multiplication
See screenshot of Excel operation
Is there a simpler way to perform this operation as seen in screenshot?
Distributive multiplication for multiple columns that is then summed together. Is there an ...
0
votes
0
answers
52
views
excel requires one date format for cell entry but shows another
In Excel (2023) for Mac I have formatted a few fields as Date dd.m.yy. And it displays the dates in those cells as such.
BUT, it requires me to enter the date with the format m/dd/yy.
So I prefer to ...
1
vote
1
answer
54
views
How to get value using row and column search
I made a budget spreadsheet I'd like to use and have plugged in some numbers to ensure I'm doing everything correctly. I have two sheets: 1. for the budget i.e. I'd like to spend max $1000 for rent ...
0
votes
2
answers
247
views
How to set MS-Excel as default program to a .csv file in Windows 11 pro?
I am not able to set MS-Excel as default program for a .csv file in Windows 11 pro. I have tried many ways, but not able to do it.
I have to either choose "open with" option or first open MS-...
0
votes
2
answers
47
views
Why are mat1, mat2, mat3, etc. defined and equal to 0?
I'm writing a formula in Excel (Microsoft 365) using the LAMBDA function and happened to name a variable mat1. This resulted in an error and I noticed that the name mat1 was a different colour. I ...
1
vote
0
answers
29
views
Having two modules on x-axis
I have a column chart on power bi with option OI against each strike and for each strike for all of the dates. So in short it has two layer in x-axis 1st layer is strike and 2nd layer is date.
For all ...