Ive got a grid of 20x20 cells, and in there is either a 1,-1,0 or any char(such as *,#,$) and in it i need to count how many times there is a 2x2 group of the same value, I need to get this to the smallest size possible(as in all goes into one cell) otherwise just really small
Hi and welcome to the forum
by "2x2" Group", do you mean in all directions? verticle, horizontal and diagonal?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This is what i mean http://i.imgur.com/0kBU3TL.jpg thats the grid i have and each time a pattern such as the one i circled appears i count it, so yes i guess in all directions
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
How about the formula =SUMPRODUCT(--(A1:S19=B1:T19)*(A1:S19=A2:S20)*(A1:A19=B2:T20))
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Ahh thank you that work amazingly thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks