Count values in column (referring to column name in code)

[maya_bee]

Current.png shows a simple example of my dataset. I want to count every value in column furniture and eventually get the dataset as shown in wanted-outcome.png. However, the code needs to look at the column name and not the column number. I want to use the vba for different sheets where column furniture may not always be in the same place.

I tried several things but neither came close. Any suggestions?

 

[mumps]

It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[maya_bee]

A simple example:

Map1
	A	B
1	owner	furniture
2	mike	chair
3	jane	table
4	tom	chair
5	lilly	chair
6	ari	lamp
7	maya	sofa
8	anthony	lamp
Blad1

I would like to add a new column groupsize that shows how often a furniture occurs. So chair occurs 3 times. In the column groupsize where furniture is 'chair' they value will be 3'.

Wanted outcome:

Map1
	A	B	C
1	owner	furniture	groupsize
2	mike	chair	3
3	jane	table	1
4	tom	chair	3
5	lilly	chair	3
6	ari	lamp	2
7	maya	sofa	1
8	anthony	lamp	2
Blad1

Thanks for the tip Mumps.

 

[mumps]

Place this formula in cell B2 and copy it down as far as you have data:
=COUNTIF(B:B,B2)

 

[maya_bee]

I know of the formula, however I'm trying to get it in vba. I'm trying to write a vba script with multiple mutations, so that the person using the script only has to perform one action.

 

[mumps]

I'm trying to write a vba script with multiple mutations

Can you describe the multiple mutations? Also, can you use the XL2BB add-in to post screenshots instead of pictures of your data? It's hard to work with pictures.