Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi ,
Hoping someone can help with this.....
I have a file with a list of orders .
Column C contains the order numbers which will duplicate if the order contains different types of orders ( order type is in column g ) , but also van duplicate if it contains multiple payment methods culumn I Ie.debit card, credit card, gift card and PayPal.
I'm trying to find 2 formulas which will identify if an order ( column c) has split order type "y" or "n" or a split payment type "y" or "n" or both .
I've used a count if you identify if the order number is duplicated ..
=IF(COUNTIF($C$2:$C$500,$C2)>1,"Y"."N")
But this won't tell me if it is a split order due to multiple order types column g or multiple payment types column I or both ?
Hoping someone can help
Hoping someone can help with this.....
I have a file with a list of orders .
Column C contains the order numbers which will duplicate if the order contains different types of orders ( order type is in column g ) , but also van duplicate if it contains multiple payment methods culumn I Ie.debit card, credit card, gift card and PayPal.
I'm trying to find 2 formulas which will identify if an order ( column c) has split order type "y" or "n" or a split payment type "y" or "n" or both .
I've used a count if you identify if the order number is duplicated ..
=IF(COUNTIF($C$2:$C$500,$C2)>1,"Y"."N")
But this won't tell me if it is a split order due to multiple order types column g or multiple payment types column I or both ?
Hoping someone can help