Hi Every One Hope You will be enjoying good health
I'm creating order sheet
I'm stuck on one point on auto increment order no
I have created below formula
=IF(ISTEXT(C2),IF(C2="PinkFit","PF",IF(C2="Gloryshop","GS",IF(C2="Whats App","WA",IF(C2="Website","WEB"))))&"-"&TEXT((COUNTIF($C$1:C1,C2)+1),"0000"),"")
<colgroup><col width="64" style="width: 48pt;" span="3">
<col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;">
<tbody>
</tbody>Now I want to edit formula, if the phone no in above cell is same then don't increase in order no
hope you understand
I'm creating order sheet
I'm stuck on one point on auto increment order no
I have created below formula
=IF(ISTEXT(C2),IF(C2="PinkFit","PF",IF(C2="Gloryshop","GS",IF(C2="Whats App","WA",IF(C2="Website","WEB"))))&"-"&TEXT((COUNTIF($C$1:C1,C2)+1),"0000"),"")
| Order_Id | Source | Customer Name | PhoneNo |
| WEB-0001 | Website | 0322895xxx | |
| PF-0001 | PinkFit | ||
| PF-0002 | PinkFit | ||
| PF-0003 | PinkFit | ||
| GS-0001 | GloryShop | ||
| PF-0004 | PinkFit | ||
| PF-0005 | PinkFit | ||
| GS-0002 | GloryShop | ||
| PF-0006 | PinkFit |
hope you understand
