Excel 2007 : Intervals

**freehawk** · 02-09-2010, 04:55 PM

Hi, I have a question if there is formula, for something that is in the atachment. Simply what I would like is that I have around 500 of such 4 columns sequences, and I would like to divide them into groups. So for example, numbers from 1 to 3, including 3 would be named letter " A", from 4 to 6 including 6 would be letter " B", and so on. Also, I would like the original numbers to stay, without replacing it.

Thanks

**freehawk** · 02-09-2010, 05:11 PM

Anyone?????

**rwgrietveld** · 02-09-2010, 05:15 PM

=char(int((b2-1)/3)+65)

**freehawk** · 02-09-2010, 05:25 PM

Thanks, but what If I want to make it every 4,5 and so on? then I have to change the "b2-1)/4" instead of "b2-1)/3" Also why 65?

Thx

**rwgrietveld** · 02-09-2010, 05:50 PM

65 equals A, 66 equals B etc.

and yes, the interval is determined with the 3,4,5,6

**freehawk** · 02-09-2010, 06:16 PM

Ok, Thx, but I have one more question. Now when I have letters in rows, is there a formula or vba, that will count all the possibilities, so for example if in first row there are letters in 5 columns; A, B, C, D, E, then it will look up all such combinations and paste them in another sheet. It will search the second rows of 5 columns with maybe different sequence of letters, and will do the same, and if the row 2, and 456 have the same letters, then this process wouldn't be done again with row 456.

What I would like is similar to TextCrawl program, but in it, I have to manually put the numbers, which with alot of rows would be tidious, so I hope there is a shorther, faster way.

Thanks