Finding Ujjwala Customer who haven't Taken Free Refill Yet in SDMS
Автор: Indane TVM
Загружено: 2020-04-24
Просмотров: 2580
Описание:
Finding Ujjwala Customers, who haven't uplifted free Refill yet...
It requires two files...
You can download them from
https://reports.px.indianoil.in/
Goto dashborad ...
Download Customer Register
Delivery Register report dated from 01-04-2020 till today...
Once Both Files are downloaded ...
Follow the steps in this Video on how to Sort them...
Follow them step by step...
First Sort the Customer Register File by Sceheme Type to find Ujjwala Customer ..
Once Sorted Copy the Sorted Values and paste them in new sheet, these are Ujjwala Customers
Do the same with Delivery Register File, Sort by Consumer Priority Field, Select Ujjwala Customers...
The Formula in Excel is =ISNUMBER(MATCH(D2,$H$2:$H$282,0))
Then Sort the Cyl Taken field and select FALSE, this will give you customer who have not yet taken Cyl
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: