Help needed adding the last bit to a formula

[bionicle]

hi All,

wondering if someone could help me out in figuring out the last part (I hope) to a formula.

I have the below formula which returns the correct information however I would like it to add a figure to the end of the text.

this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)") returns as Mr Higgins (subcontractor) whoever I need it to put a number at the end of the column (1-100) but I also need it to see additional (subcontractor) cells and therefore make to number add 1 each time.

if column "W" has 15 cells with (subcontractor) in them it needs to count on 1 each time.

hope that makes sense..

steve

 

[Roxxien]

Hello,

From what I understand, this is what you search.

=IF(W2="(Subcontractor)",K2& " (Subcontractor)" & COUNTIF($W$2:W2,"=(Subcontractor)")

 

[Peter_SSs]

Duplicate to Help needed adding the last bit to a formula

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.