Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
5 answers
Need a formula
Need a formula to find a cell with text in a worksheet and copy the numeric value to the right of that cell into another worksheet
Excel
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,061 questions
asked 2023-01-05T11:20:35.53+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, 14.000000000000002%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Maurizio5
6
Reputation points
edited the question 2023-02-13T09:40:23.6466667+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
One of the answers was accepted by the question author.
Chinese displays as '?'
Dear All, When I export data from VFP9 to a text file with the following command copy to _trainer.xls delimited with tab My region setting of my Windows is as follows: If I open the file (_trainer.xls) in Notepad, the Chinese characters appear…
asked 2023-01-10T04:36:23.53+00:00
BenTam
1,621
Reputation points
edited the question 2023-02-13T09:38:30.47+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
How to fix excel corrupted files for excel? I have save the file in seagate harddisk? I am currently using window 11.
How to fix excel corrupted files for excel? I have save the file in seagate harddisk? I am currently using window 11.
asked 2023-01-11T06:00:18.5833333+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(105.60000000000001, 82%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Karen Lim
0
Reputation points
edited the question 2023-02-13T09:37:22.93+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
Have Recon with only 2 columns but might have several rows on other to match, how can I find Matches?
Have a general Ledger account debit / credit but sometimes/most it several credits to match one debit, i have been doing by adding subtracting and takes a long long time. Plus they don't really have a unique name that would match the debit to credits,…
asked 2023-01-14T18:58:32.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(147.20000000000002, 70%, 24%)' 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)
J806
0
Reputation points
edited the question 2023-02-13T09:36:16.1733333+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
One of the answers was accepted by the question author.
Threaded comment support by Office professional version of Excel
Is threaded comment supported by Office professional Plus 2021 version of Excel? When I tried to edit the comments by it that are edited by Office Home and Business 2021 or Microsoft 365 enterprise version of Excel, every single comment shows an error…
asked 2023-01-14T07:39:16.0766667+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(124.80000000000001, 27%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Atsushi Ando
20
Reputation points
edited the question 2023-02-13T09:35:57.7366667+00:00
Emily Hua-MSFT
27,591
Reputation points
2 answers
Creating Excel and Word Objects in old Visual Basic 6 broken, again
Since mid January 2023 one of Microsoft Updates broke this functionnality. I need to support for at least one year old Visual Basic Applications for a client that uses VBA objects like Excel and Word. We are using Office 2016 32 bits edition. This was…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
746 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
907 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
asked 2023-01-31T15:17:10.2766667+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, 83%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Richard Tremblay
0
Reputation points
edited the question 2023-02-13T09:30:24.1833333+00:00
Emily Hua-MSFT
27,591
Reputation points
2 answers
2D Map Chart
I am using Office LTSC Pro Plus 2021 x64 Multilingual, installed a Week ago Issue: Data tab > Data Types > Geography is not available in MSEXCEL and I am unable to create city name wise 2D Map chart, currently its only Province Or State Or Country…
asked 2023-01-31T19:06:40.88+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(80, 0%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
Zeeshan Haider
0
Reputation points
edited the question 2023-02-13T09:28:14.69+00:00
Emily Hua-MSFT
27,591
Reputation points
4 answers
SqlBulkCopy , ASP.NET web forms, Stuck without error
Hello, I have three excel files, uploading data from asp.net webforms and inserting into database. I am reading data from excel files and then from datatable inserting to database using SqlBulkCopy, sometime it works perfectly and then next time it…
asked 2023-02-09T14:48:57.2866667+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(73.60000000000001, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tahir Shafique
21
Reputation points
commented 2023-02-13T08:30:46.5366667+00:00
Tahir Shafique
21
Reputation points
1 answer
Can I automatically get email subject lines and date and time into excel?
Whenever I receive an email in a specific folder in outlook I would like a new row to be added in an excel file. Date and time in column a and subject field in column b. Is that possible? And how? Thanks.
asked 2023-01-15T02:42:27.8333333+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(195.2, 33%, 28%)' 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)
Claus Nilsson
0
Reputation points
edited the question 2023-02-13T06:43:59.9166667+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(121.6, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChristyZhang-MSFT
22,181
Reputation points Microsoft Vendor
3 answers
No Tables or Views when Connecting to Excel file in SSIS
Seriously, why in God's name is it SO HARD to connect to Excel!?! Visual Studio 2019 Excel 365 64-bit I added a Data Flow Task to my Control Flow Added Excel Source to the Data Flow Opened the Excel Source and clicked "New" to create a new…
asked 2023-02-11T00:54:32.5466667+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(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sean Hull
15
Reputation points
answered 2023-02-13T06:07:22.6066667+00:00
ZoeHui-MSFT
35,226
Reputation points
1 answer
Excel - sort multiple rows as groups
I have the following data: I want sort it by Asset Ranking so rows 6,7, and 8 will be on the top. Is it possible? Thanks
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
asked 2023-02-10T12:59:18.24+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(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
mark goldin
691
Reputation points
edited the question 2023-02-13T05:46:11.0633333+00:00
Emi Zhang-MSFT
23,736
Reputation points Microsoft Vendor
0 answers
Office Script; Excel online; Pivot Table; DataHierarchy field title
I would like to change the title for a Pivot Table DataHierarchy field. I cannot find any documentation. Specifically, I'd like to change the field name from "Sum of aDate" to "aDate" I'm using Office Script/Java Script. I tried…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,458 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
asked 2023-02-10T20:28:16.0866667+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(211.20000000000002, 95%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jenny Charlton
0
Reputation points
edited the question 2023-02-13T01:57:17.7466667+00:00
Emily Hua-MSFT
27,591
Reputation points
0 answers
Type Mismatch - shape properties vs cells value
Hiya, VBA is giving me type mismatch error when calculating value from excel range/cells value vs shape properties. Is there a way to resolve this error please? Initially Range "A1" was a formula which I'd changed to a number (format cell as…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
asked 2023-02-10T15:48:54.9333333+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(307.2, 97%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LYoong
0
Reputation points
edited the question 2023-02-13T01:56:10.52+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
Getting Runtime Errors When Trying to Refresh Excel in SSIS Script Task
I am trying to refresh queries in an Excel via using SSIS. I created a script task as follows: using System; using System.Data; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.Office.Interop.Excel; using System.Threading; using…
2 answers
One of the answers was accepted by the question author.
Why doesn't table connection for Excel pivot table work?
Hello, I'm creating a pivot table based on two Excel tables: Sales and Orders. The unique field is the OrderDetailNumber. The OrderDetailNumber exists only one time in both tables. It's origin is in the Orders table and it shows up (is put) in the Sales…
asked 2023-02-01T16:00:45.3166667+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(240, 6%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jan Sijben
20
Reputation points
accepted 2023-02-10T16:18:22.9233333+00:00
Jan Sijben
20
Reputation points
1 answer
Problem with Excel file on network share and edit queue
Hello. There is an Excel file on the network share. It needs to be opened and edited by multiple people. Accordingly, when the first user opens for editing, he is blocked for the rest and when trying to open it, Excel will inform them about it and give…
asked 2023-02-09T12:02:55.0766667+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(105.60000000000001, 30%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pavel.Dyachuk
251
Reputation points
commented 2023-02-10T12:22:30.4433333+00:00
Pavel.Dyachuk
251
Reputation points
1 answer
How do I protect part of a worksheet in an Excel workbook?
Hi, I am trying to protect a tab within an Excel worksheet. Intent is to protect so that no one can change formatting, enter columns, delete information, etc. However, I do want individuals to be able to enter new rows and/or edit data in cells on…
asked 2023-02-06T14:09:33.7433333+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(76.8, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Brooks, Suzanne
0
Reputation points
commented 2023-02-10T09:37:46.7+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
How can i use an sql query to bring data into a table in excel?
Im using an ODBC connection with mysql.
asked 2023-02-09T17:22:36.94+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(243.2, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Rubén Gamboa
0
Reputation points
answered 2023-02-09T17:31:25.7933333+00:00
Rubén Gamboa
0
Reputation points
3 answers
Do not open file with VBA in Excel
I have problem with open file .xlsb .xlsm in Excel (Office 365). After open file with start macros VBA code, file automatic close. In logs: Назва аварійного застосунку: EXCEL.EXE, версія: 16.0.15928.20216, позначка часу: 0x63b610f9 Назва аварійного…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
asked 2023-01-20T20:42:33.32+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(316.8, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TVY
5
Reputation points
commented 2023-02-09T09:06:07.2466667+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
One of the answers was accepted by the question author.
MATCH the result
I need the Column J result:
![](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(134.4, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)