Hi all,
A few weeks back I posted a question on Excel, and Hector13 graciously helped me. I was wondering if any of you programming mavens could extend that kindness again?
Here's a link to my original question: http://forums.anandtech.com/messageview.cfm?catid=33&threadid=457639
I am using Hector13's macro. I could understand and modify it pretty easily. I am now stuck with a new challenge- I still am using the same columns of data: a 15 digit number treated essentially as a 15 letter word, I am still looking for cells with less than a 3 letter difference. But the difference is now, I'd like for is to search the column automatically.
Which I don't know how to do.
I'd like highlight Column A, or take (start with) the first value in Column A, and then have it search the whole column for like numbers within that 3 integer threshold. What we worked on before, would do that and then display the integer difference value about two columns over.
What'd be new would be this:
1) After the search (of the first value in colA) anything with a Integer Difference <=3 would get a group number or counter. So all "like" values would display say, a 1 (for group 1), instead of their integer difference value.
2) Then the macro would then drop down to the next unlike (not like Cell1) cell, an Integer Diff >=4, and then do a search for like cells (IntDiff <=3)among the rest of the unchosen, those like cells would be given a group or number 2 offset.
3) And then so on and so on. Until all cells have group value. If the cells are unique- they'd have no group. Or rather they'd be unique groups of one.
Example:
ColA ------------- ColB -- Explanation
515563435640731 X1 unique
777777777720771 X2 Group 1
777777777760731 X3 "
776377777760771 X4 "
777777777760771 X5 "
777777777721110 X6 Group 2
777777777731110 X7 "
I'll get this:
colA ---------------colB ---- colC
515563435640731 X1 (unique, could be given a group number, too)
777777777720771 X2 1
777777777760731 X3 1
776377777760771 X4 1
777777777760771 X5 1
777777777721110 X6 2
777777777731110 X7 2
X1 has no likes.
X2 has X3,4,5 within 3. Group 1.
X6 has X7 within 3. Group 2.
It'd be great if you could help-- I'd appreciate it very much.
Thanks, Mike
A few weeks back I posted a question on Excel, and Hector13 graciously helped me. I was wondering if any of you programming mavens could extend that kindness again?
Here's a link to my original question: http://forums.anandtech.com/messageview.cfm?catid=33&threadid=457639
I am using Hector13's macro. I could understand and modify it pretty easily. I am now stuck with a new challenge- I still am using the same columns of data: a 15 digit number treated essentially as a 15 letter word, I am still looking for cells with less than a 3 letter difference. But the difference is now, I'd like for is to search the column automatically.
Which I don't know how to do.
I'd like highlight Column A, or take (start with) the first value in Column A, and then have it search the whole column for like numbers within that 3 integer threshold. What we worked on before, would do that and then display the integer difference value about two columns over.
What'd be new would be this:
1) After the search (of the first value in colA) anything with a Integer Difference <=3 would get a group number or counter. So all "like" values would display say, a 1 (for group 1), instead of their integer difference value.
2) Then the macro would then drop down to the next unlike (not like Cell1) cell, an Integer Diff >=4, and then do a search for like cells (IntDiff <=3)among the rest of the unchosen, those like cells would be given a group or number 2 offset.
3) And then so on and so on. Until all cells have group value. If the cells are unique- they'd have no group. Or rather they'd be unique groups of one.
Example:
ColA ------------- ColB -- Explanation
515563435640731 X1 unique
777777777720771 X2 Group 1
777777777760731 X3 "
776377777760771 X4 "
777777777760771 X5 "
777777777721110 X6 Group 2
777777777731110 X7 "
I'll get this:
colA ---------------colB ---- colC
515563435640731 X1 (unique, could be given a group number, too)
777777777720771 X2 1
777777777760731 X3 1
776377777760771 X4 1
777777777760771 X5 1
777777777721110 X6 2
777777777731110 X7 2
X1 has no likes.
X2 has X3,4,5 within 3. Group 1.
X6 has X7 within 3. Group 2.
It'd be great if you could help-- I'd appreciate it very much.
Thanks, Mike