Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
672 questions with Microsoft 365 and Office | Excel | Other | Other tags
3 answers
One of the answers was accepted by the question author.
To meet the first formula logic requirement and then apply the next formula
for a Quarterly data value, the monthly value is updated. Eg. For Q1, only after Mar data is entered the IF logic formula applied should compute and provide the value as output. However even if i put value for Jan, the output value is provided for Q1…
Microsoft 365 and Office | Excel | Other | Other
asked 2026-07-02T06:13:42.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 87%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Princess, Rachel
20
Reputation points
commented 2026-07-03T10:57:03.53+00:00
Princess, Rachel
20
Reputation points
5 answers
SPCX not available in Excel Stocks data type
When will SPCX (Space Exploration Technologies) be available in Excel Data Selector?
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-15T21:16:40.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Cary Newman
30
Reputation points
commented 2026-06-29T14:35:00.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 23%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
p W
0
Reputation points
2 answers
Need help with issue
why is my excel not working properly everytime i make a project it closes
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-19T14:37:44.3833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 80%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
laura H
0
Reputation points
edited the question 2026-06-27T22:24:01.37+00:00
Andreas Baumgarten
132.3K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
VBA Code to Consolidate Several Specific Sheets from Seperate Workbooks
I have to copy data from specific sheets that are from separate workbooks. The workbooks have the same first sheet, and the following sheets have the same title but a consecutive # gets added at the end. The first sheet's name is 'Results', the second…
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-23T21:16:19.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 38%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alejandro Ruiz Solano
20
Reputation points
commented 2026-06-24T16:16:19.8966667+00:00
Alejandro Ruiz Solano
20
Reputation points
2 answers
how to reset the excel. the Excel is not working. I am getting error issue
how to reset the excel. the Excel is not working. I am getting error issue
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
1 answer
https://www.google.com/search?q=sandbox:/mnt/data/Etut_Programi_Final.xlsx
https://www.google.com/search?q=sandbox:/mnt/data/Etut_Programi_Final.xlsx
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-03-08T15:04:25.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 54%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
İbrahim Tolunay
15
Reputation points
commented 2026-06-23T13:22:21.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chandhru, Kannappan
0
Reputation points
2 answers
split a file into individual tabs
how can i split a single excel sheet into its individual files
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-17T10:15:44.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 82%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Adrian Gray
0
Reputation points
answered 2026-06-17T10:53:00.27+00:00
DaveM121
898K
Reputation points
Independent Advisor
2 answers
Excel cannot save my files. It says "File not saved"
Excel cannot save my files. It says "File not saved"
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-15T10:43:01.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 50%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Antoinette Grundling
0
Reputation points
answered 2026-06-15T11:20:59.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 70%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Estrella721
41,630
Reputation points
Independent Advisor
1 answer
=EOMONTH(DATEVALUE("2011-01-01"),3)
4344년 4월 30일4344년 4월 30일=EOMONTH(DATEVALUE("2011-01-01"),3) 위 함수 결과가 위의 수치처럼 4천년대로 표기되는데 수정방법없나요? 웹엑셀입니다. above function shows the result(4344y) that is typed at the top of this page. Is there any fixs that I can apply to?
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-14T11:12:15.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 84%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
JIN GYU Bak
0
Reputation points
edited the question 2026-06-14T22:30:08.07+00:00
Gérard Oomens
125K
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
text to be uppersize in the cell
Hi Sir, The formula below is to link the tab name to cell. =MID(@CELL("filename",B1),FIND("]",@CELL("filename",B1))+1,256) I wish the text to be uppercase in the cell and keep the text in the tab to be lowercase. Kindly…
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 94%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
2 answers
Excel foemula
I want to show up to date stock value on existing spreadsheet both sheets have, part number ?
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-08T09:23:52.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 32%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lesley Rettie
0
Reputation points
commented 2026-06-09T07:52:26.5533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kai-H
20,935
Reputation points Microsoft External Staff
Moderator
2 answers
fix excel lost data
I have lost all access to my excel spreadsheet I have lost all access to my excel spreadsheet I have lost all access to my excel spreadsheet
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-06T07:00:36.0733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Karuna Dahya
0
Reputation points
commented 2026-06-09T07:47:48.69+00:00
Kai-H
20,935
Reputation points Microsoft External Staff
Moderator
2 answers
no puedo ver sandbox:/mnt/data/Anexo_Control_Facturacion_Exhaustivo.xlsx
Este excel no puedo verlo sandbox:/mnt/data/Anexo_Control_Facturacion_Exhaustivo.xlsx, que pasos tengo que seguir
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-01T18:53:58.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Fabian Di Donato
0
Reputation points
commented 2026-06-08T15:12:55.33+00:00
Fabian Di Donato
0
Reputation points
2 answers
Is there a way to subtotal columns within a table in excel? I know you can do it with a regular excel file (outside of the excel file in one drive) but the functionality within the MS file is different
I have an excel file that has been sorted on one specific column. I want subtotals added to the spreadsheet. so, for example Name type state amount Doe personal NY 5.00 Jones …
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-06-03T17:58:02.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 91%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ann Marie Herrman
0
Reputation points
answered 2026-06-03T18:05:46.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET5%3C/text%3E%3C/svg%3E)
triptotokyo-5840
36,686
Reputation points
Volunteer Moderator
1 answer
auto populate data to another sheet in a workbook based on a populated field
I have an excel workbook that contains numerous tabs. Each tab tracks data for a unit and i need to be able to copy an entire row from any of the tabs to a separate tab based on whether or not a date is populated in one of the columns. all of the…
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-05-27T20:06:21.2333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Miller, Shelly
0
Reputation points
commented 2026-05-28T23:03:40.2166667+00:00
Ashish Mathur
102.2K
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
why do my formulas look like this?
the format of all of my simple sum and avg formulas has changed this morning... they look like this: =(SUM(R[-1]C2:R[-1]C)*R27C2)/(((COUNT(R[-5]C2:R[-5]C)-3)R27C2)+18000) and I want them back to how they were yesterday!
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-05-27T13:16:07.6366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 60%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Thomas Maynard
20
Reputation points
accepted 2026-05-27T13:17:36.55+00:00
Thomas Maynard
20
Reputation points
1 answer
Microsoft keeps blocking MY access to MY Excel spreadsheets even after I have resolved the issue (the last time they did this)
Last night Microsoft graciously and gratuitously installed an update (without letting me know what it contained or helping me decide if I wanted to do this). As part of this unwanted update Microsoft decided that the code I had written for Excel was…
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-05-13T14:29:52.4566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 75%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUB%3C/text%3E%3C/svg%3E)
Unswayed By Assertions
5
Reputation points
commented 2026-05-15T00:32:00.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXD%3C/text%3E%3C/svg%3E)
Xavier-D
9,545
Reputation points Microsoft External Staff
Moderator
1 answer
Why can't I access Coursera files in excel
I am taking Coursera classes that require me to open samples spreadsheets. When I sign into my paid annual Microsoft account it cannot access their files. What am I doing wrong?
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-05-12T23:59:55.2066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
Wendy Saunders
0
Reputation points
commented 2026-05-13T04:55:03.5733333+00:00
Bulldog
2,745
Reputation points
2 answers
Excel related problem
How to repair my excel my excel is not working how to resolve it
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 11%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
I need some help creating the formula to extract data from a CSV data file
The CSV file produces the sample 2 lines of data I need a formula that will populate the following columns: Number Temp Number Type 2 R 1 M 1 Veg
Microsoft 365 and Office | Excel | Other | Other
Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
672 questions
asked 2026-05-10T05:00:18.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JoePerp
0
Reputation points
answered 2026-05-10T05:00:30.1633333+00:00
AI answer