dear experts
i have two column set of data in column a:a serialno
in column b:b Parts
1.If For Single So'S Refelects Multiple Time In A:A I Have Parts Status Like With Parts And With Out Parts I Want Result ""Double Business"
2.If Parts Status Is With Parts Or Without Parts Only I Want Result (""Single Business"")
3.If Serial No Is One Time And Business Type Is Either With Parts Or Without Parts I Want Result ""Part Business"")
please find the attachment if you not able to understand
May be this...
In C2 Cell
=IF(A2="","",IF(AND(COUNTIFS(A:A,A2,B:B,"with parts"),COUNTIFS(A:A,A2,B:B,"without parts")),"DOUBLE BUSINESS",IF(AND(COUNTIFS(A:A,A2,B:B,"with parts"),COUNTIFS(A:A,A2,B:B,"without parts")=0),"Single Business",IF(AND(COUNTIFS(A:A,A2,B:B,"with parts")=0,COUNTIFS(A:A,A2,B:B,"without parts")),"Part Business",""))))
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
dude check those row only REST OF THE WORKS PERFECTLY
CCC2222 with parts RESULT SHOULD BE PART BUSINESS
TY8811 without parts RESULT SHOULD BE PART BUSINESS
FIND THE ATTACHMENT
hi breadwinner, try:
=IF(A2="","",IF(COUNTIF(A:A,A2)=1,"PART BUSINESS",IF(COUNTIFS(A:A,A2,B:B,"<>"&B2)>0,"DOUBLE BUSINESS","SINGLE BUSINESS")))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this...
=IF(A2="","",IF(AND(COUNTIFS(A:A,A2,B:B,"with parts"),COUNTIFS(A:A,A2,B:B,"without parts")),"Double Business",IF(SUM(COUNTIFS(A:A,A2,B:B,{"with parts","without parts"}))=1,"Part Business",IF(OR(AND(COUNTIFS(A:A,A2,B:B,"with parts"),COUNTIFS(A:A,A2,B:B,"without parts")=0),AND(COUNTIFS(A:A,A2,B:B,"with parts")=0,COUNTIFS(A:A,A2,B:B,"without parts"))),"Single Business",""))))
thanks alot sixth senses and smart sense benishiryo efforts
thread been solved!!!!
OK.. solved..
but still .. throwing my effort..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Dude welcome Thanks alot Some thing special at your formula!!! more advance
Pl see the file attached.
USE this in D2 and drag down.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks