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
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 ...
Mark Colan's user avatar
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 ...
Khan Fah's user avatar
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 = ...
Seba99's user avatar
  • 101
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 ...
Stefan Högling's user avatar
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%....
Rasa's user avatar
  • 23
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 ...
user avatar
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 ...
Skrobbit Johnson's user avatar
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 ...
KansaiRobot's user avatar
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 ...
thtrmus's user avatar
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 ...
DigitalNomad's user avatar
  • 1,678
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?
DigitalNomad's user avatar
  • 1,678
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. ...
Phil's user avatar
  • 11
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.
Clairem's user avatar
-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. ...
Anakin Teow's user avatar
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 ...
Aisha Stayer's user avatar
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 ...
Alan's user avatar
  • 11
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 ...
zz20s's user avatar
  • 103
-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 ...
Martin Harding's user avatar
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->...
Regus Pregus's user avatar
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, ...
OverlordQ's user avatar
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. ...
Sharkcoder's user avatar
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 ...
bpep's user avatar
  • 1
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 ...
Adrian Eyre's user avatar
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 ...
PBA24's user avatar
  • 3
-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 ...
Wael's user avatar
  • 1
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 ...
Andrew's user avatar
  • 1
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 ...
Mark Barnes's user avatar
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 ...
jpheimer's user avatar
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 ...
Nico LeFae's user avatar
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 ...
Peter Thome's user avatar
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.
Brenda's user avatar
  • 1
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 ...
ChrisW's user avatar
  • 419
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 ...
MyDaftQuestions's user avatar
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). ...
Jasmine's user avatar
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 ...
PBA24's user avatar
  • 3
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 ...
dennisklad's user avatar
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....
htester's user avatar
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 ...
Juan Felipe Rubiano's user avatar
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 ...
Andy's Excel's user avatar
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 ...
Daniel Cho's user avatar
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 ...
Hiker Bro's user avatar
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 ...
Ali's user avatar
  • 41
-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 ...
Tracy's user avatar
  • 1
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 *...
pkd's user avatar
  • 145
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 ...
Dan's user avatar
  • 1
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 ...
megapixel's user avatar
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 ...
Nikki's user avatar
  • 11
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-...
Ajay Kumawat's user avatar
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 ...
David's user avatar
  • 103
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 ...
yusuf shikder's user avatar