Forum Discussion
Enumerating Smartly in Excel
=IF(D4="External Client Regulatory","1."&COUNTIF($D$4:D4,"External Client Regulatory"),
IF(D4="External Operational Request","2."&COUNTIF($D$4:D4,"External Operational Request"),
IF(D4="Evolent Standard Operational","3."&COUNTIF($D$4:D4,"Evolent Standard Operational"),
IF(D4="Evolent Vendor Operational","4."&COUNTIF($D$4:D4,"Evolent Vendor Operational"),
IF(D4="Evolent Internal Operational","5."&COUNTIF($D$4:D4,"Evolent Internal Operational"),0)))))
Maybe with above formula which i applied in the attached file.
=IF(D4="External Client Regulatory","1."&COUNTIF($D$4:D4,"External Client Regulatory"),
IF(D4="External Operational Request","2."&COUNTIF($D$4:D4,"External Operational Request"),
IF(D4="Evolent Standard Operational","3."&COUNTIF($D$4:D4,"Evolent Standard Operational"),
IF(D4="Evolent Vendor Operational","4."&COUNTIF($D$4:D4,"Evolent Vendor Operational"),
IF(D4="Evolent Internal Operational","5."&COUNTIF($D$4:D4,"Evolent Internal Operational"),0)))))
Maybe with above formula which i applied in the attached file.
- Yes this works perfectly - just need to get the formatting so it will be two digits behind the . so thanks again!
NewelleNielsen8821 Perhaps wiser not to hard-code all the category names with nested IF statements. In the attached file, I've demonstrated the use of a lookup table and also resolved the two-digits issue after the point.
- @Riny_Van_Eeklen403176
This is SO GREAT - thank you - my next task is to ensure that if a row gets deleted that the number stays the same - do I have to do that in a Macro to set it to text once identified? It has to be dynamic to a point as new things are added throughout the project and others are moved off but they need to keep their values so it would need to be dynamic for the new entries only and the once established no changes. Hopefully that makes sense.
