C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,226 questions
0 answers
Create Excel template using C3
We have a requirement to create the Excel template with the below requirements: Give the unique ID for each column. Need to add the predefined formulae in a certain column, and if the user enters the value in the related column, the calculation…
C#
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,475 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,639 questions
asked 2024-02-13T07:59:33.8633333+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(297.6, 98%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ratan Kanade, Trupti
0
Reputation points
edited the question 2024-02-13T08:04:11.3233333+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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
31,516
Reputation points Microsoft Vendor
0 answers
Are there any plans aimed to facilitate the migration from COM to Office JS Add-ins?
Over the past year, we've enhanced our Office JS Add-in and we would like to migrate our users to the new technology. However, we're encountering challenges in encouraging adoption, the main reasons we have detected are: -Perception of Excel Web-Only…
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,475 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,639 questions
asked 2024-02-12T17:55:39.83+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, 61%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
Victor Herrera Silva
0
Reputation points
commented 2024-02-13T07:31:38.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(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor
4 answers
Unique, Filter and other functions are not available in Excel 2021
I am using Excel 2021 as part of Office LTSC 2021 but I cannot find functions like Unique, Filter and other functions. I tried repairing as well as uninstalling using Microsoft Support and Recovery Assistant and again reinstalling but without success. …
asked 2022-02-03T01:57:49.52+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(272, 72%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Manu Miglani
21
Reputation points
commented 2024-02-07T15:02:10.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(60.8, 87%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
rifa abdenour
0
Reputation points
3 answers
File From OneDrive keeps closing
I am trying to open an Excel Spreadsheet that is saved in Folder that is shared with me in One drive. The document opens and then seems to automatically scroll down and then close itself. If i copy the file to my desktop it works fine, If I open in…
asked 2021-07-30T10:19:25.727+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(233.6, 68%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
David Ewer
71
Reputation points
commented 2024-02-07T11:32:15.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(227.2, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike H
0
Reputation points
1 answer
One of the answers was accepted by the question author.
We're sorry, but Excel has run into an error that is preventing it from working correctly.
I‘m using Office 365, when I start the Excel, it pops up: We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair now? Click Repair Now, after…
asked 2024-02-07T07:48:32.4966667+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(137.6, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
merry alen
40
Reputation points
accepted 2024-02-07T08:58:16.9166667+00:00
merry alen
40
Reputation points
1 answer
Generating an S-Curve in Excel
How can I generate an S-Curve in Excel? I have data that includes planned and completed dates with percentage progress, and I want the graph to be an S-Curve between those dates. Blank fields indicate when there is no data available. Here is an image of…
asked 2024-02-06T23:41:42.8566667+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, 11%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Ajish Daniel
0
Reputation points
answered 2024-02-07T06:32:53.6933333+00:00
Emi Zhang-MSFT
21,626
Reputation points Microsoft Vendor
23 answers
Excel "3D Map" feature error: 3D Maps encountered an error while contacting Microsoft Bing mapping services. Functionality may be limited. (Status Code: 4)
Hello, I am running into an issue with Excel application where I am no longer able to use the "3D Map" feature. I used to use the search bar to load the feature but now when i do that i am faced with the following error: 3D Maps…
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,475 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,639 questions
asked 2022-09-26T22:10:32.693+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, 13%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Said A
706
Reputation points
answered 2024-02-06T07:48:21.2666667+00:00
Sakorn_Roman
0
Reputation points
1 answer
Excel date, time, time zone extraction
I'm currently working with a several Excel sheets that have a column with mm/dd/yyyy hh:mm:ss MDT (time zone where it was created). Is there a way or formula to make the current column or a new column with just mm/dd/yyyy? I've tried selecting the column…
asked 2024-02-02T19:06:55.6533333+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(265.6, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Curious
0
Reputation points
commented 2024-02-05T06:20:15.5433333+00:00
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor
0 answers
Empty columns in Source excel file
Hi Team, As my source location is ADLS and Source file is Excel, with the Empty columns in the excel sheet my get Metadata activity gone failed. is there any solution approach to exclude Empty columns. Note : I am using this Get Metadata activity to get…
asked 2024-01-19T09:56:48.2733333+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(144, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Arshad Kotwal
0
Reputation points
edited the question 2024-02-03T10:37:54.0233333+00:00
Sumarigo-MSFT
43,411
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
PowerPoint how can I update linked excel data during a looping slideshow
I want to use Excel to keep scores and results in a sports tournament. The Excel spreadsheet is not very presentable, so I would like to present the results and score in a looping PowerPoint presentation with timed advancing slides through linked data…
asked 2022-03-05T19:15:39.117+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, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Alex Wilhelmsen
41
Reputation points
commented 2024-02-02T14:15:39.1633333+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(118.4, 47%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rob Poretti
0
Reputation points
0 answers
como repara el libro de macros personal
al momento de borrar un macro, se desconfiguró el libro personal de macros, lo cual intente arreglar y quedó peor de lo que estaba, ahora al abrir el excel como una hoja en blanco abre el libro personal de macros y tiene que estar abierto si o si para…
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,760 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,475 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,639 questions
asked 2024-02-01T13:13:13.9366667+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(108.80000000000001, 88%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cristian Zuñiga Carrillo
0
Reputation points
edited the question 2024-02-02T07:26:37.91+00:00
Emi Zhang-MSFT
21,626
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
What type of course should I sign up for
I am wondering what course I should take to gain Excel experince before i apply to entry level finance positions. It also looks like many of the courses are just an exam with no modules that I can learn from before taking the test.
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,046 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Windows 365 Business
Windows 365 Business
A Microsoft cloud operating system.
409 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,639 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, 18%, 23%)' 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)
2 answers
Moved worksheet to a book that doesn't exist
I wanted to move a worksheet to a new book. I clicked the Move or Copy button and chose to move to another book that showed up in the dropdown menu called Book1. I clicked on it, but now I'm trying to find it on my computer and turns out it's a phantom…
asked 2021-04-16T23:23:58.947+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(166.4, 11%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Christian Carrizo
1
Reputation point
edited an answer 2024-02-01T15:23:08.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(272, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pol Amar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Change cell data automatically to "Approved" once cells I5 and J5 have data added to them
I need my cell H5 to automatically change to "Approved" once my team enters their names in cells I5 and J5. This will be in the sharepoint and the cells are all data validation based from a setup tab. On the same note, I need it to remain…
![](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(153.6, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
4 answers
Microsoft Excel Support - Mapping a Candidate to a particular Position using a Job role
Hello All, I have attached the excel sheet. Basically, we need to map a candidate to a various position and map a Position to a various candidate. We have a list of candidates in "Candidates" sheet, we need to take a first candidate and if the…
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,475 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,639 questions
asked 2024-01-05T09:16:42.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(256, 2%, 34%)' 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)
Jaas Cal
0
Reputation points
answered 2024-01-30T07:35:13.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(172.8, 53%, 26%)' 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)
Barry Schwarz
1,946
Reputation points
0 answers
Excel closing by itself after executing recorded macro. How to fix?
Excel closing by itself after executing recorded macro. How to fix? (translated via Google Translate, there may be errors) Macro: Sub ClassiftLancamentosGerais() ' ' ClassiftLancamentosGerais Macro ' ' Range("tLancamentosGerais").Select …
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,475 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,639 questions
asked 2024-01-29T15:28:21.74+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(313.6, 78%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
Fabrício Amaral
0
Reputation points
edited the question 2024-01-30T01:56:06.03+00:00
Emi Zhang-MSFT
21,626
Reputation points Microsoft Vendor
4 answers
Microsoft Office 2016 - Somebody else is working in {File} / Excel cannot save to this location
We just suddenly started having this issue where Office 2016 (particularly Excel) can't save or overwritten files to/in a few specific folders on our SMB share. Issue Overview In Excel, you go to Save As, browse to one of the affected folders…
asked 2021-10-07T23:35:00.18+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(188.79999999999998, 12%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Seth Weber
41
Reputation points
commented 2024-01-29T16:25:48.63+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(153.6, 22%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Neil C
5
Reputation points
1 answer
Hello! I am trying to protect individual cells without having to protect the whole document in excel. How do I go about this?
Hello! I am trying to protect individual cells without having to protect the whole document in excel. How do I go about this? I only have the option to protect the entire workbook and not individual columns and/or separate sections. Please, help! #excel
asked 2024-01-18T00:00:06.8366667+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(6.4, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
S Google
0
Reputation points
commented 2024-01-26T08:23:04.8466667+00:00
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor
1 answer
How do I create a formula in one column to change by one each month ex: it January and Column one A DOB 2023-01-17 Column B is 12 when I change the month February I want column B to 13 so on and so on. Is this even possible?
How do I create a formula in one column to change by one each month ex: it January and Column one A DOB 2023-01-17 Column B is 12 when I change the month February I want column B to 13 so on and so on. Is this even possible? (Total newbie here)
asked 2024-01-17T21:43:57.47+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(294.40000000000003, 76%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sharron Ammann
0
Reputation points
commented 2024-01-26T08:22:10.99+00:00
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor
1 answer
COUNTIFS FORMULA FOR DECIMAL NUMBERS
Hi, I have a column containing a list of numbers, some of them are whole numbers and some others are decimals. For example, |NAMES||SCORES| |Kavitha||33| |Laila||42.5| |Sabeena||33.2| |Seema||40| |Sita||33.8| |Sybia||41| |Zameera||40.2| I want to count…
asked 2024-01-17T20:22:34.91+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(144, 34%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Christin Grace
0
Reputation points
commented 2024-01-26T08:21:21.7966667+00:00
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor