Скачать или смотреть Finding Ujjwala Customer who haven't Taken Free Refill Yet in SDMS

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