grouping

[Mike 6]

A B C D E F G
1 22 1 3 5 7 9
2 33
3 22
4 44
5 55
6 66
7 22 2 4 6 8 10
8 22 5 10 15 20 25

I am desprately looking for a formula that will organize data by using a
common cell number, then taking the remainder of the data in that row and
only looking at those rows for comparing data. In the example above column A
w/ "22" openning the door for the data in rows 1, 7 and 8.

Thanks very much
Mike

 

[Sheeloo]

Sorry, I could not understand what you want to do...

 

[Max]

Suggest that you just clean it up (remove the rows w/o data),
then just do a data > sort on the cleaned up table, sort by col A

To clean up:
Insert a new top row, type a label into G1, eg: xxx
Put this in G2:
=IF(COUNT(B2:F2)=0,"x","")
Copy down to the last row of data in col A
Then select col G, click Data>Filter>Autofilter,
choose: x from the droplist to filter out the rows w/o data
Select all these rows > right-click > Delete Row
Remove Autofilter, then delete col G.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik