How to combine rows with identical columns on Excel & Sheets (this is the most SECRET formula)

preview_player
Показать описание
SUBSCRIBE and hit the 🔔 for more like this!

Legit first I've ever found this!
If you have TWO unique sets of data sharing an identical column, this is the easiest solution. Watch closely!

📍 Formula in Pinned Comment

#exceltutorial #googlesheets #googlesheetstutorial #themarketerssecrettoolbox #secret #excel #exceltips #sheets

how to combine two sheets into one in excel
combine data from multiple sheets

*** MY GEAR ***

You'll notice how most or all my gear is at least a few years old. Is it because I'm a cheapskate? No. I like to maximize the lifespan and squeeze as much as I can out of these old sports for as long as I can, while not totally running them into the ground.

The MacBook Pro is a titan from early 2020 that's still chugging along quite well. It's the last of the Intel MBPs. Some apps, however, are now stressing the memory enough that it's time to upgrade to an M1 or M2 pretty soon. But that's a minority of apps.

*** DISCLAIMER ***
🔷 As an Amazon Associate I earn from qualifying purchases.

🔷 In addition to Amazon, video and description contain affiliate links for the products & apps I share. This means that if you click on one of the product links, I'll receive a small commission. This is at no extra cost to you, and in many cases include exclusive bonuses where applicable.

It's a gesture of appreciation from the product creators for my honest recommendation of their products -- based on my own real experience. This helps support the channel and allows me to continue to make free videos like this and provide value to those in need.

Thank you for the support! --
⭐️⭐️⭐️ SUPPORT THIS CHANNEL -- Here's My Business Tools ⭐️⭐️⭐️

⭐️⭐️⭐️ Social ⭐️⭐️⭐️
Рекомендации по теме
Комментарии
Автор

Here's the Secret Formula:
*=IF($B3="USD", N3, "")*

1. This assumes the string "USD" is in Column B (Data 2). You can replace "USD" with anything you want, and then you'll need to update the formula accordingly.
2. Replace N3 with whichever cell is BELOW the one you're entering the formula.

If this doesn't work, let me know and I'll be happy to help you!

TheMarketersSecretToolbox
Автор

Could you please create step by step walkthrough

gomqabnapolf
Автор

Ok this is all too complicated. I am just hiring an accountant.

JustSomeGuyNotAnAlien
visit shbcf.ru