Mastering Excel: Extract Unique Locations and Calculate Total Sales #exceltips

preview_player
Показать описание
#excelshorts #exceltricks #excelformula

Hello Friends,

In this video, we have explained how to extract Unique Locations and Calculate Total Sales from the description and sales data. We have used TEXTAFTER, UNIQUE and SUMIF with wildcard function.

Subscribe our new YouTube Channel:

Click here to download the practice file:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store
Рекомендации по теме
Комментарии
Автор

Thank you so much sharing, it's helpful.

knvishnu
Автор

Looks good but you would SUMIF for example Delhi and New Delhi together. You were supposed to use "*-"&E2 to match it only after the delimiter.

paulgummerson