# 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.

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.

24,714
questions

0
votes

0
answers

5
views

hoping I explain this correctly:
I have a large spreadsheet like the below
enter image description here
I need to collapse multiple rows (with same order number) and total the individual cost prices ...

0
votes

0
answers

7
views

I currently have my data in different columns after using a Text To Columns feature. Now what I want to do is to put them all into one column. Can you please advise what formula to use or is there a ...

0
votes

0
answers

11
views

My data is reading horizontally right now but I want my data to read vertically (e.g. I have an 'x' column with data below it and likewise for 'y' so I can plot with vertical data instead of my ...

0
votes

0
answers

2
views

In Excel 2013, I used to be able to specify a sheet to Data Refresh and at the time of creating a linked csv file, I could prompt for the location or file with every Data Refresh. In Excel 2016, I am ...

0
votes

0
answers

16
views

I am using excel to perform some analysis.
I have a spreadsheet(Base) that contains the fields: ID Number Type Roles
and another spreadsheet (Results) that contains the fields: ID Number
How Can I add ...

0
votes

0
answers

7
views

I am working on an Excel Book and I want to share it with some people.
All the Sheets are linked to another Excel Files, so I need some help with sharing this Excel without any #REF or ERROR in the ...

0
votes

1
answer

11
views

Is there a way with VBA to hide or disable "Show Hidden" button in Power Pivot? So no one can see the raw data.

0
votes

0
answers

12
views

Source data :
Result I am looking for :
I would like a formula to do this for thousand of occurrences (always by pair, it is flow data). The smallest value should be subtracted from the larger. The ...

1
vote

0
answers

23
views

=IF([@[Amani''s Taxable Income (by bracket)]]=0,0,IF(([@[Amani''s Taxable Income (by bracket)]]+[@[If taxable income is over:]]+1)>=[@[but not over:]],D8,[@[Tax rate]]))
The system said there was a ...

0
votes

0
answers

16
views

I can see there are solutions to fix, but I cannot go and change hundreds of documents manually. I never experienced this problem in nearly 30 years of using Word and Excel. It started last fall or ...

2
votes

1
answer

143
views

I have a spreadsheet with 10,000 rows, and in one column, I have an incrementing value:
1
2
3
...
10000
Now I want to format this so that the cell with the value is always 32 characters long by ...

0
votes

0
answers

19
views

The purpose is to determine how many sampling cycle (with probability 99.9%) is necessary in order to obtain that each of the 13 items in the population have been sampled at least once. I have an R ...

0
votes

0
answers

15
views

Hi good internet people,
I wonder if someone might be able to help me figure this out. My excel knowledge is very basic.
Using an end date (Fully Grown) and subtracting a caluculated number of days I ...

0
votes

0
answers

17
views

I am trying to something that I feel should be simple VLOOKUP or XLOOKUP and have tried looking it up online with no success.
I have the following dataset:
Group
Code_Present
Code_Missing
Description
...

0
votes

0
answers

23
views

I have an excel sheet where I enter the start and finishing times of each shift. But during night shift you will earn 25% more, so I need to calculate the number of working hours which counts as night ...

1
vote

0
answers

11
views

I have a PivotChart in Excel 2016 that is currently based on PivotTable-A.
PivotTables A and B are identical, other than the fact that they have different data sources:
A's data source is an ...

0
votes

0
answers

19
views

Is there a way to have data on the left side of a sheet and a chart on the right that is always visible? ie.. the chart is 'pinned' so that while you're scrolling through the data you can always see ...

0
votes

0
answers

19
views

I have a solar system and am looking to calculate the projected time to pay back the initial cost from the monthly savings.
I.E. I have paid back 0.15% in 1 month, how do I show the years, months and ...

0
votes

0
answers

8
views

In Excel, I can create a table (n.b., not a Pivot Table) through Insert > Table with headers where I can sort and filter the table among other functions.
Is there a similar functionality in Google ...

2
votes

0
answers

22
views

In Excel 2016, I have several PivotTables (and corresponding PivotCharts) that use external data sources. The data sources were created via Microsoft Query (an Excel mechanism) and have complex SQL ...

-1
votes

1
answer

41
views

I have an Excel spreadsheet.
The columns in my sheet are
CaseID,EmployeeNumber,FirstName,LastName,Status
The case ID are used multiple times so it is not unique.
I wanted to find out how many records ...

0
votes

0
answers

19
views

Essentially, I am trying to fill information into Sheet A (SA) using =SUMIFS but the information that it is pulling into the actual formula comes from Sheet B (SB) and is organised in horizontal form.
...

0
votes

1
answer

17
views

I am an educator writing an exam on basic excel usage. I ask students to set print area. I would like to have a single cell that displays the cell range they have selected as their print area.
Print ...

0
votes

0
answers

14
views

I want to use the tab key for expediency and type a time value to look like the image below with a combobox, so an hour can be typed, [tab key] a minute can be typed [tab key] and a default value of ...

0
votes

0
answers

9
views

My understanding is that Microsoft Excel for Windows has a 'Speak Cell' button in the Quick Access Toolbar. However, the Mac version of Excel doesn't have this. Instead, it has a 'Speak Selection' ...

0
votes

1
answer

24
views

So Let's say I have a spreadsheet
No
Name
Class
Gender
1
Jack
Science
Male
2
Rose
Science
Female
3
Kevin
Social
Male
4
Olive
Social
Female
and I have template
No
Name
Gender
1
2
3
4
How to ...

0
votes

1
answer

42
views

I have this generated data to excel and want it to sort it like in the image below:
I will be grateful if anyone will help me find a solution.
I'm new to excel.

1
vote

1
answer

24
views

I have a vehicle data spreadsheet with 3 columns to record the Odometer.
Odometer during repair service or fueling
Odometer at the Beginning of a trip
Odometer at the End of a trip
There are gaps ...

0
votes

1
answer

31
views

In an Excel spread sheet, I have a row containing all dates of the year, and also a list of UK bank holidays. I wish to use conditional formatting to highlight dates that fall on a bank holiday.
When ...

-1
votes

0
answers

23
views

I need to send weekly scorecards containing data that is stored in excel tables. The tables are currently created in word with a .csv file as the source. It is a lengthy process to combine the data ...

0
votes

1
answer

32
views

Since today I suddenly have _xlfn. appearing for certain functions and I get the #name error. It seems to have to do with using new functions in older excel versions.
I just use Office 2021 (Version ...

0
votes

0
answers

16
views

I want to set up a pivot graph who only shows values based on the fill colour of the cell.
The graph should should the amount of cells with (e.g.) green, yellow, and red cells.
Can someone advise on ...

0
votes

1
answer

18
views

I have 2 sheets, the first sheet contains a coulm of Emails and the second sheet contains 2 columns ( Some Emails & Status). How to make excel get the status of each email from sheet 2 into sheet ...

-1
votes

0
answers

11
views

Because Office 365 Enterprise Apps have yet attained sufficient quality when getting Table from Image, I found a online OCR Service who provide much accurate Table from Image but unfortunately in ...

0
votes

1
answer

29
views

I feel silly, because this should be easy, but I can't figure this out.
I have a series of columns of data. It always starts at row number 11, and is always in columns E,F,G,H,I, and K. The problem is ...

0
votes

0
answers

22
views

Don't know the exact wording, so apologises if title seems confusing.
In short I'm doing up a small data input table for my local swimming club whereby they can enter in the raw data of the competing ...

0
votes

0
answers

31
views

I have my 2022 dec dates as well as my 2023 dates in my table. When I plot it on a Pivot graph, the jan 2023 dates acts like 2022 dates and it comes before my dec 2022 dates. Is there a way I can fix ...

1
vote

1
answer

26
views

I am using O365 and am having trouble with this formula looking at two cells and returning the appropriate value based on those cell's values.
I have two columns: Vendors and Amount. Vendors will ...

0
votes

2
answers

46
views

I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...

0
votes

0
answers

12
views

I am trying to think through how I can chart complex prescription data in Excel. I am trying to understand the amount of each drug that was prescribed over time. I have the a spreadsheet that contains ...

0
votes

0
answers

9
views

im trying to create a pivot table that has documents received in a particular week and documents replied in that particular week. In data source, documents replied column has some empty cells since ...

0
votes

1
answer

27
views

Attempting to create a correlation matrix in excel, I made the following formula:
=CORREL(OFFSET(A2:A1001,0,ROW()-ROW(G2)),OFFSET(A2:A1001,0,COLUMN()-COLUMN(G2)))
ROW()-ROW(G2) and COLUMN()-COLUMN(G2)...

0
votes

0
answers

16
views

Trying to create an Outlook email that has Excel ranges pasted as jpg in the email, along with text before and after. Something like:
Text
Image 1
Image 2
More Text
However, I cannot figure out how to ...

0
votes

1
answer

22
views

I have these data in Excel:
I created a pivot table that is supposed to calculate the percent of each state's counties that qualify for a certain government program (this is artificial data, though).
...

0
votes

1
answer

16
views

I have a dynamic set of data that is filtered in from a table, with different arrays of data assigned to potentially overlapping dates, shown here Data Input from Filter Formula (the dates and data ...

1
vote

0
answers

13
views

I have always experienced a frustrating problem when plotting line graphs. The plotted lines are smooth as they should be, but I would still need to tweak the horizontal axis to Date in order to show ...

0
votes

1
answer

14
views

I have the above table, but however I try I cannot get the evidence gap to appear as individual series.
In this example there should be a total of 4 points with the legend of the points being Test, ...

0
votes

1
answer

12
views

I have a table that I want to get a percentage from but I want it to be a rolling percentage so that when I highlight a cell the percentage changes. There's no values in the cells that I want to ...

1
vote

2
answers

20
views

I created a 17 tab worksheet for company locations to track monthly performance metrics against a budget. I used a reference cell as a condition to control conditional formatting of cells as well as ...

0
votes

1
answer

57
views

I have a table of which every value is a formula.
I have the following XLOOKUP: =XLOOKUP(G3,C3:C28,E3:E28,"").
The C column are percentages calculated by formulas. This column is designated ...