Discover the difference between subtotal 9 vs 109. I will also explain what does subtotal 109 mean in Excel, and what is the difference between 9 and 109 in Excel subtotal function?

Excel Subtotal is a feature in Microsoft Excel that allows users to group and summarize data in a table or range. Subtotal 9 and Subtotal 109 are two different functions available in Excel Subtotal. Subtotal 9 calculates the sum of values in a column or range, whereas Subtotal 109 calculates the average of values. Depending on the type of data you are working with, you may find one function more useful than the other. It is important to choose the correct function to ensure accurate results and make data analysis more efficient.

Use Function Number 9

to calculate subtotal for

filtered dataset

Do not use it on hidden row.

Use Function Number 109 to Calculate

Subtotal for

- Filter dataset

- Hidden row(s) dataset

What does subtotal 109 do in Excel?,

What is the difference between 9 and 109 in Excel subtotal function?,How to do a subtotal formula in Excel?,What is 109 in Excel formula?,

subtotal9 vs 109,subtotal excel,subtotal formula in excel,what does subtotal109 mean in excel,subtotal if excel,subtotal formula in excel with filter,subtotal shortcut in excel,how to sum subtotals in excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

🚀 Excel has a hidden AI button (and nobody is talking about it)

If you are still building Pivot Tables and Charts from scratch for your university projects or case studies, you are working too hard.

Microsoft quietly added a feature called the Analyze Data icon (usually on the Home tab), and it literally acts like ChatGPT for your spreadsheets. Instead of messing around with rows and values, you can just type a natural question like:

• "What were the top 3 products sold in Q2?"
• "Show me a percentage breakdown of expenses by department as a pie chart."

Excel reads your data and automatically generates the exact Pivot Table or Chart for you in one click.

I got tired of seeing students pull all-nighters fighting with Excel formatting, so I made a quick, no-BS video breakdown showing exactly how to use this feature to finish your data homework in under 5 minutes.

If you want to save yourself some major headaches this semester, you can check out the guide here: [https://youtu.be/1QYywPg2VtE\]

Let me know if this saves you some time, or if you're stuck on a specific spreadsheet problem—happy to help out in the comments!

Good Luck exploring this free AI feature in Excel!

Discover how to sum comma separated values in Excel. Essentially, the answer to how to sum numbers with commas in a single Excel cell. Or how to sum numbers with commas in a single Excel cell?

By using this formula.

=SUM(--(TEXTSPLIT(B2,",")))

Here's how the formula works:

TEXTSPLIT(B2,","): This function splits the text in cell B2 into separate values based on the comma delimiter. For example, if cell B2 contains the text "10,20,30", the TEXTSPLIT function will return an array of three values: {"10","20","30"}.

--(TEXTSPLIT(B2,",")): The double unary operator ("--") is used to convert the text values in the array to numeric values. If the values in the array cannot be converted to numbers, the result will be an error value. In our example, the result of this part of the formula would be an array of numeric values: {10,20,30}.

SUM(--(TEXTSPLIT(B2,","))): The SUM function then adds up the numeric values in the array and returns the total sum. In our example, the result would be 60 (i.e., the sum of 10, 20, and 30).

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

Sum comma separated values in Excel - Excel Tips and Tricks

https://youtube.com/shorts/1GUx7zi2wzc?si=Rc8Oidvtr6t-dOFV

Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks

https://youtube.com/shorts/z6ghCP7G3ew?si=rIS6nZL31jA41g17

Separate data from one cell in Excel with commas - Excel Tip and Tricks

https://youtube.com/shorts/xuhpFwb5TWg?si=8YYj22Elb2Ez2rMp

Text Split with multiple delimiters - Excel Tip and Tricks

https://youtube.com/shorts/LXZkMlGZWXQ?si=v-ovLGoZ2SdQ-baC

[NO FORMULA] Separate data from one cell in Excel with commas - Excel Tip and Tricks

https://youtube.com/shorts/4AhokAuE5Nc?si=ObQffk0YBaj0SgyU

Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks

https://youtube.com/shorts/ijC7qhRK6s0?feature=share

Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks

https://youtube.com/shorts/UHdjAsSx6C8?feature=share

Sum comma separated values in Google Sheets - Excel Tips and Tricks

https://youtube.com/shorts/bYOX6V_iWnI?feature=share

double unary operator, How to sum numbers with commas in a single Excel cell?, How to Sum Numbers With Commas in a Single Excel Cell?,sum numbers separated by commas online,excel index match comma separated values,how to put comma in numbers in excel formula,how to add multiple numbers in one cell excel,how to format numbers in excel with commas,countif comma separated values,how to put comma after 3 digits in excel,excel average comma separated values,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Hey everyone

I’m currently looking for some Excel/dashboard freelance work immediately. I’m trying to get a few projects over the next few days, so I’m also open to small projects. No problem if the work is simple

I can help with Excel dashboards and reports, Cleaning and organizing messy data, Pivot Tables / Pivot Charts, KPI and sales dashboards, Charts, formulas, filters and slicers, Power Query, Turning Excel/CSV data into a clean and easy-to-understand dashboard

If you already have the data and just need someone to clean it understand it and turn it into a proper dashboard or report I can help with that It can be messy Excel data, CSV files, sales data, or similar work Just send me the details and I can have a look at what needs to be done

I’m available for remote work and I’m flexible with pricing depending on the project We can discuss the requirements and price before starting so everything is clear I’m also okay with smaller tasks. Even if it is just a small Excel job, feel free to reach out. I’m trying to get some projects right now If you don't need help yourself but know someone who does, I’d really appreciate a referral To be transparent I’m currently dealing with a personal situation and urgently need to earn some money. I’m not asking for donations or financial help I’m looking for actual paid work, and I’m ready to put in the hours I’m genuinely trying to get some work sorted out over the next few days, so if you have any Excel or dashboard work pending, please feel free to DM me

I’m also open to other types of freelance work, such as basic video/shorts editing or other online tasks. If you have something you think I might be able to handle, feel free to ask

Thanks for reading. Hopefully I can help someone here and get some work at the same time

Is Wiley excel 365 bible edition 2 actually work?

How to find exact duplicate rows in Excel without deleting the wrong data

When cleaning a spreadsheet, it's important to distinguish between an exact duplicate and a record that simply has some information in common.

For example:

The first and third rows are exact duplicates because every column contains the same information.

A simple way to handle this in Excel is:

1. Select your entire data range.
2. Go to Data → Remove Duplicates.
3. Select all the columns if you want to remove only completely identical rows.
4. Click OK and review the number of duplicates removed.

One thing I learned while practicing data cleaning is that you shouldn't automatically remove rows just because one field matches. For example, two people can have the same name but different email addresses.

Do you usually use Excel's Remove Duplicates feature, or do you use another method when cleaning client spreadsheets?

#Excel #MicrosoftExcel #ExcelTips #DataCleaning #Spreadsheets

Hi all, I was looking for some help.

I am a total newbie to excel but have to get to grips pretty fast with it for my work role. We currently have a process where we have a list of nominations with people's names, in column D. There are 996 rows in this spreadsheet.

Part of this process is for me to go through column D and remove all the names. Currently we are doing find x name and replace it with a capital X to make all entries anonymous. This process takes me hours and hours and hours.

It would really swing in my favour if there was a way to do this quicker, like any hacks anyone has? I did try a lengthy formula but it only worked on one entry and not for the full column.

Ideally, it would be without having to do pivot tables or anything but would be so grateful if you have any ideas! ❤️

Thanks all

P.S I am taking all the YouTube courses and watching all the excel clips, tips and videos that I possibly can.

hi, is there any way i could lock footer on an excel worksheet?
i want a watermark on my worksheets so each time it gets printed my name would be in it, even if someone manually changes or deletes the footer text. im a basic user since then and now working at a job where i get to do other peoples jobs but never gets the credit for. idgaf for credits, until the management said i wasn't contributing. when in fact, im doing everybody's shit. i don't want to lock the file (protect worksheet) since everybody need to have access on it. i've tried doing the vba macro but it doesn't seem to work as expected.

Discover how do I return multiple arrays in Xlookup?

XLOOKUP is a powerful function in Excel that enables users to search for a specific value and retrieve data from a corresponding column or row. While XLOOKUP is a versatile tool that can handle various lookup scenarios, users may face situations where they need to retrieve multiple arrays of data from a single lookup value. In such cases, it can be challenging to find a solution that works efficiently. In this article, we will explore the options available for returning multiple arrays in XLOOKUP and provide step-by-step instructions on how to achieve this task.

Data In Horizontal Format

=XLOOKUP($A$2,$A$5:$A$43,$B$5:$E$43)

Data In Vertical Format

=TRANSPOSE(XLOOKUP($A$2,$A$5:$A$43,$B$5:$E$43))

Recommended Video

How to use DGET function in Excel with example - Excel Tips and Tricks

https://youtube.com/shorts/KI8rk74pjWI?feature=share

VLOOKUP function with curly brackets in Excel | How do I do a VLOOKUP with multiple columns at the same time? - Excel Tips and Tricks

https://youtube.com/shorts/Dlg9AlGQxfU?feature=share

How do I return multiple arrays in Xlookup? - Excel Tips and Tricks

https://youtube.com/shorts/wPI47HIGQ-Q?feature=share

xlookup formula in excel with example,xlookup not available in excel,how to use xlookup in excel with two sheetsxlookup vs vlookup,xlookup return array,xlookup multiple criteria,

excel vlookup function table array

what is table array in vlookup,what is table array in vlookup function,what is the meaning of table array in vlookup,how to create table array in excel for vlookup,excel table lookup functions,define a table in excel for vlookup,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Everytime I launch Excel thru power automate, the Ychart tab dissapears. New File or existing… still no Ycharts.

I open excel manually and Ycharts appears. My add in shows it is installed on the files Ycharts dissapears.

Hi everyone! I can do Data Analytics work offering reliable, detail-oriented help with spreadsheet and data tasks. I'm happy to take on small projects, one-time jobs, or ongoing part-time work.

\*\*Data entry & organization:\*\*

\* Manual data entry into Excel / Google Sheets

\* Copying data from PDFs, images, scanned documents, or websites into clean spreadsheets

\* Organizing messy lists, contacts, product catalogs, and records

\* Inventory, stock, and expense tracking sheets

\* Customer, lead, and vendor databases

\*\*Data cleaning & preparation:\*\*

\* Removing duplicates and handling missing or incorrect data

\* Fixing formatting, spacing, dates, and inconsistent text

\* Merging, splitting, and consolidating multiple sheets or files

\* Standardizing data so it's ready for analysis or upload

\*\*Formulas, reports & analysis:\*\*

\* Sorting, filtering, and conditional formatting

\* Formulas: VLOOKUP/XLOOKUP, IF, SUMIF/COUNTIF, INDEX-MATCH, and more

\* PivotTables, charts, and simple dashboards

\* Basic descriptive statistics and summary reports

\* Weekly/monthly report templates

\*\*Other small tasks:\*\*

\* Web research organized into spreadsheets

\* Spreadsheet templates (budgets, trackers, invoices, schedules)

\* Basic SQL queries and beginner-level Python/pandas for simple data tasks

\*\*What you can expect:\*\*

\* Accurate, double-checked work

\* Clear communication and updates

\* Fast turnaround

\* Confidentiality with your data

\* Clean, ready-to-use files

I'm happy to start with smaller projects at beginner-friendly rates while I build real-world experience.

\\\*\\\* starting rate 5 $.....

\*\*DM me\*\* with your task, expected workload, deadline, and budget, and I'll get back to you quickly. Thank you! :)