Countif function

[Rachelpan]

I have looked through the Countif formulas, but cannot seem to find the one that fits my issue.

Column A has 20 different department names repeated several times down to row 500.
I would like a formula that would place a numeric value in column B beside each department name in column A.
For example - if the department name of "Sand" was repeated 80 times - it would have number 3 (for example) next to that department name each time.

 

[mrshl9898]

So you want a specified but unrelated number against each Department?

Best to write out a list of Departments, with said values in the next column, and use VLOOKUP to return the value against the name.

 

[Rachelpan]

So you want a specified but unrelated number against each Department?

Best to write out a list of Departments, with said values in the next column, and use VLOOKUP to return the value against the name.

 

[Rachelpan]

That works.
Thank you