match with criteria (and or) if condition.

[bhasoriya]

searching one formula for match with criteria (and or) if condition.


have some 17 columns and around 5000 rows..

For example.

Col A = In date (has many dates)

col B = Order number. (has many order numbers)

col C = Order type. (type of order, Either New order Or Change)

col D = Out date.. (In dated order completion date)


Can't explain here very well.

Please download file from below given link

downloadlink;

https://rapidshare.com/files/3902136358/Daily_Report_New_1.xlsx;


Thanks

 

[mrzoogle]

Hi bhasoriya,


Is it possible for you to create a dummy data sheet and upload here so everyone can help you with your request ?


Regards,


Z.

 

[Luke M]

It also sounds like you might be able to just use an AutoFilter and filter down on the criteria you have to get what you need.

 

[bhasoriya]

Yes, please download from below given link


downloadlink;

https://rapidshare.com/files/3902136358/Daily_Report_New_1.xlsx;

 

[Hui]

Change :


D2: =IF(C2="Change Advt","CHG PROCESS","NEW PROCESS")

E2: =SUMPRODUCT((Report!B:B=Sheet2!D2)*(Report!C:C=Sheet2!B2),(Report!N:N))


Then copy both down

 

[bhasoriya]

Thanks Hui,

Both Formula is working perfectly. Thanks a lot..