Increment a counter by 1 for every 4 cells the same.

[sravilob]

Within a range of cells, I want to be able to increment a counter by 1 for every 4 cells the same. 8 cells the same counter = 2, 12 cells the same counter = 3 and so on. Only if the like cell total is divisible by 4 should the counter increment.

In my range of cells, N17:DX17, I want to be able to increment my counter by 1 in D17 for every 4 "V" up to a maximum of 4. I only want my counter in D17 to show 0,1,2,3 or 4 regardles of how many "V" are in my range.
2 "V" counter shows 0.
4 "V" counter shows 1.
6 "V" counter shows 1.
8 "V" counter shows 2.
19 "V" counter shows 4.

I hope I am clear with my request.

I'm sure the solution is simple.

[Pete_UK]

Within a range of cells, I want to be able to increment a counter by 1 for every 4 cells the same. 8 cells the same counter = 2, 12 cells the same counter = 3 and so on. Only if the like cell total is divisible by 4 should the counter increment.

I hope I am clear with my request.

I'm sure the solution is simple.

I've quoted your whole post as only the last two sentences are visible to me and they don't make any sense on their own.

Yes it is possible to increment every 4 cells, but I think you need to give some more detail of exactly what you want to achieve. It also helps to post a sample workbook (NOT a picture), with a Before and AFTER sheet showing what you want to do.

Pete

[sravilob]

I've quoted your whole post as only the last two sentences are visible to me and they don't make any sense on their own.

Yes it is possible to increment every 4 cells, but I think you need to give some more detail of exactly what you want to achieve. It also helps to post a sample workbook (NOT a picture), with a Before and AFTER sheet showing what you want to do.

Pete

In my range of cells, N17:DX17, I want to be able to increment my counter by 1 in D17 for every 4 "V" up to a maximum of 4. I only want my counter in D17 to show 0,1,2,3 or 4 regardles of how many "V" are in my range.
2 "V" counter shows 0.
4 "V" counter shows 1.
6 "V" counter shows 1.
8 "V" counter shows 2.
19 "V" counter shows 4.