Telegram Group & Telegram Channel
Маълум бир диапазонда уникал қийматлар (мисолда қайтарилмайдиган исмлар) сонини аниқлаш.

Бу масаламиз учун қуйидаги массив формуласидан фойдаланамиз.
=СУММ(1/СЧЁТЕСЛИ(A1:A10;A1:A10))

1️⃣ 👆🏻Формулани ўзингиз мисолингизда ишлатиш учун, диапазонга ўзингизни диапазонингизни киритинг.

2️⃣ Формулани киритгандан сўнг Ctrl + Shift + Enter бирикмасини босиб юборинг. (Шунда формула массив формуласи сифатида киритилади)


Каналга уланинг
👉: Excel Hacks | 🚀 Excel Hacks Videokursi
👍10👏71🔥1💯1



tg-me.com/excel_hacks/434
Create:
Last Update:

Маълум бир диапазонда уникал қийматлар (мисолда қайтарилмайдиган исмлар) сонини аниқлаш.

Бу масаламиз учун қуйидаги массив формуласидан фойдаланамиз.
=СУММ(1/СЧЁТЕСЛИ(A1:A10;A1:A10))

1️⃣ 👆🏻Формулани ўзингиз мисолингизда ишлатиш учун, диапазонга ўзингизни диапазонингизни киритинг.

2️⃣ Формулани киритгандан сўнг Ctrl + Shift + Enter бирикмасини босиб юборинг. (Шунда формула массив формуласи сифатида киритилади)


Каналга уланинг
👉: Excel Hacks | 🚀 Excel Hacks Videokursi

BY Excel Hacks




Share with your friend now:
tg-me.com/excel_hacks/434

View MORE
Open in Telegram


Excel Hacks Telegram | DID YOU KNOW?

Date: |

Dump Scam in Leaked Telegram Chat

A leaked Telegram discussion by 50 so-called crypto influencers has exposed the extraordinary steps they take in order to profit on the back off unsuspecting defi investors. According to a leaked screenshot of the chat, an elaborate plan to defraud defi investors using the worthless “$Few” tokens had been hatched. $Few tokens would be airdropped to some of the influencers who in turn promoted these to unsuspecting followers on Twitter.

How to Use Bitcoin?

n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”

Excel Hacks from us


Telegram Excel Hacks
FROM USA