Grouping data with PivotTable, SUMIF, Consolidate - Mlumatlar qrupladrmaq

Uploaded By: Myvideo

Published on

2 Jan 2024

1 view

0

0 votes

0

About Share Download Add to

Əgər cədvəlimizdə məhsulların adları təkrarlanırsa, məsələn onlarla sətir olan cədvəl əslində 4-5 məhsuldan ibarətdir. Bu zaman cədvəlimizi qruplaşdırmaq lazım gələcək. Exceldə bunun əsas 3 yolu var: 1. PivotTable ilə qruplaşdırmaq. 2. SUMIF Funksiyası ilə qruplaşdırmaq. 3. Consolidate altmenyusu ilə qruplaşdırmaq. Belə olduğu halda cədvəlimiz daha vizual və yığcam görünəcək.@misterexcel

Share with your friends

Link:

Embed:

<iframe width="640" height="360" src="//myvideo.cc/embed/MFh3SG1FOHdkY3RBdGpPK1J5ay9KZ0ZtSjgwVzF1NUxuenl5ZFNFZjM0ST0" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>

Video Size:

Custom size:

x

Autoplay video

Hide player controls

Hide resume playing

Add to Playlist:

Favorites

My Playlist

Watch Later

Objective control of the destruction of an infantry fighting vehicle of the Ukrainian Armed Forces by servicemen of the Sever gr

2 hours ago

00:00:12

Objective control of the destruction of an infantry fighting vehicle of the Ukrainian Armed Forces by servicemen of the Sever gr

1 8%

A 122-mm 2S1 Gvozdika self-propelled gun crew from a separate motorized rifle brigade of the Southern Group of Forces destroyed

5 hours ago

00:00:40

A 122-mm 2S1 Gvozdika self-propelled gun crew from a separate motorized rifle brigade of the Southern Group of Forces destroyed

1 15%

Отчёты Яндекс.Data Lens на основе данных Битрикс24

6 hours ago

00:03:56

Отчёты Яндекс.Data Lens на основе данных Битрикс24

2 28%

Objective monitoring of the results of the work of artillery crews of the Guards Artillery Brigade of the Southern Group of Forc

7 hours ago

00:00:10

Objective monitoring of the results of the work of artillery crews of the Guards Artillery Brigade of the Southern Group of Forc

1 83%

Видео Встреча в Концертной студии Останкино с врачом-психотерапевтом А.Кашпировским (1989) |

7 hours ago

00:59:56

Видео Встреча в Концертной студии Останкино с врачом-психотерапевтом А.Кашпировским (1989) |

1 62%

The crew of the self-propelled howitzer Akatsiya of the artillery of the East group of forces destroyed a permanent firing p

8 hours ago

00:01:26

The crew of the self-propelled howitzer Akatsiya of the artillery of the East group of forces destroyed a permanent firing p

1 86%

RDS GP Шинная Борьба (Season 2) Эпизод 2 Супергерои

13 hours ago

00:39:46

RDS GP Шинная Борьба (Season 2) Эпизод 2 Супергерои

7 18%

The destruction of a Ukrainian combat armored vehicle by a crew of FPV attack drones from the North military group in the Kharko

1 day ago

00:00:17

The destruction of a Ukrainian combat armored vehicle by a crew of FPV attack drones from the North military group in the Kharko

3 63%

The destruction of an enemy pickup truck by servicemen of the West group of troops during a rotation at Ukrainian Armed Forces p

1 day ago

00:00:14

The destruction of an enemy pickup truck by servicemen of the West group of troops during a rotation at Ukrainian Armed Forces p

1 82%

Zenless Zone Zero - Виртуальная месть - промокод - SGJADSHBF

1 day ago

09:46:02

Zenless Zone Zero - Виртуальная месть - промокод - SGJADSHBF

222 84%

Combat work of the crews of the 152-mm 2A36 Giatsint-B guns of the Airborne Forces artillery unit

1 day ago

00:00:53

Combat work of the crews of the 152-mm 2A36 Giatsint-B guns of the Airborne Forces artillery unit

2 29%

Осень любви - Борис Сонис и Инна Лобанова

2 days ago

00:04:22

Осень любви - Борис Сонис и Инна Лобанова

23 6%

Zenless Zone Zero - Виртуальная месть

2 days ago

10:19:27

Zenless Zone Zero - Виртуальная месть

37 54%

Guards paratroopers of the Ivanovo Airborne Forces unit on combat missions and training grounds of the special military operatio

2 days ago

00:02:06

Guards paratroopers of the Ivanovo Airborne Forces unit on combat missions and training grounds of the special military operatio

3 46%

Zenless Zone Zero 1.2 Инферно-кросс 3

11 hours ago

01:00:34

Zenless Zone Zero 1.2 Инферно-кросс 3

4 23%

Zenless Zone Zero 1.2 Инферно-кросс 2

1 day ago

00:56:57

Zenless Zone Zero 1.2 Инферно-кросс 2

5 70%

Zenless Zone Zero 1.2 Инферно-кросс 1

2 days ago

01:01:58

Zenless Zone Zero 1.2 Инферно-кросс 1

9 30%

Режим Снайперы. Карта Кладбище. Игра Kuboom 3D: FPS Shooter на Android

3 days ago

00:06:55

Режим Снайперы. Карта Кладбище. Игра Kuboom 3D: FPS Shooter на Android

5 78%

Objective control of the destruction of a D-30 howitzer of the Ukrainian Armed Forces by a high-precision munition Krasnopol i

3 days ago

00:00:10

Objective control of the destruction of a D-30 howitzer of the Ukrainian Armed Forces by a high-precision munition Krasnopol i

3 44%

Vomigan ЭТА СБОРКА ЗАСТАВИТ ПОТЕТЬ ДАЖЕ ГУБКУ (Vomigan 3.0)

3 days ago

00:23:45

Vomigan ЭТА СБОРКА ЗАСТАВИТ ПОТЕТЬ ДАЖЕ ГУБКУ (Vomigan 3.0)

41 68%

Изменения в нормативно-правовых актах, регулирующих бухгалтерский учет в бюджетной сфере

3 days ago

00:43:26

Изменения в нормативно-правовых актах, регулирующих бухгалтерский учет в бюджетной сфере

4 37%

(G)I-DLE - OMG dance cover by HAZEN ODC Dance Cover Battle ()

3 days ago

00:03:53

(G)I-DLE - OMG dance cover by HAZEN ODC Dance Cover Battle ()

3 57%

SX3 (G)I-DLE - OMG dance cover by HAZEN ODC Dance Cover Battle ()

3 days ago

00:03:53

SX3 (G)I-DLE - OMG dance cover by HAZEN ODC Dance Cover Battle ()

1 39%

Combat work of T-80BVM tank crews of the East force group

3 days ago

00:02:41

Combat work of T-80BVM tank crews of the East force group

1 36%

0 Comments

Guest