I have sheet with data, i want to get data in other sheet but with conditions.For ex:
This is sheet 1 data as above show. When i got order new row add in sheet with all details like Sku,Order_ID,Customer_ID ,Price ,Status ( D means delivered and R means return) .If Customer order product and we delivered it but if Customer return the product in sheet 1 new row added with return details .Please Login or Register to view this content.
I have data in sheet as above in ex:, Now i want values like bellow in my other sheet ex:
Now this is my sheet 2 given below. i want to get values from sheet 1 in my sheet 2 , as in sheet one i have lot of data . so i want to refine it in sheet 2. in sheet 1 if order status return formula must skip D values for same order id and get values for R . as i try to explain in my 2nd example below. in Sheet 1 order id 33 have two rows , With "D" and with "R" . now in 2nd sheet i want to formula skip order id 33 's data with value "D" entire row . and only show data with value "R" in sheet2 . if order id have only D value then it will provide "D" values data in sheet two like i explain in example as order id 123 have only record with "D" so in sheet 2 it will provide data same as in sheet 1. so main motive is if Cell E have "D" and "R" for same order id so i need "R" values in sheet 2.
attached file http://www.excelforum.com/attachment...1&d=1475134694Please Login or Register to view this content.
Bookmarks