Is excel capable of gouping numbers within 1 of each other

B

beat

I am trying to pick numbers out pf cells that are within 1 of each other, eg
4,5,7,9,1,11. I want 4,5 to go together.
 
M

Max

beat said:
I am trying to pick numbers out pf cells that are within 1 of each other, eg
4,5,7,9,1,11. I want 4,5 to go together
Click to expand...

Just a little tinker (longshot) to scratch it here
Assuming numbers posted are in A1:F1 (in individual cells)
and that only numbers adjacent to each other are to be compared
In A2, copied across to F2:
=IF(B1="","",IF(ABS(B1-A1)=1,A1&","&B1,""))
might just give you returns resembling what you seem to want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Page numbering with Merged Document and IF statements 1
Finding the right style field in VBA 0
Histogram/Frecuency for Multiple Response Questions 1
Embed the same Excel multiple times 0
Splitting a number in one cell into other cells 0
Finding the height of a row in a word table from Excel 0

Top