order to group

[strapatsaki]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

If I have a spreadsheet with 2,000 names and some of these names are repeated but with additional text (e.g. row A1 reads ''James'' and row A147 reads ''Payment to James'') is there a macro that I could use in order to group automatically the cells that contain the same name (not using the filter option)?

Penny Strapatsaki
e-mail: (e-mail address removed)

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

If I have a spreadsheet with 2,000 names and some of these names are repeated
but with additional text (e.g. row A1 reads ''James'' and row A147 reads
''Payment to James'') is there a macro that I could use in order to group
automatically the cells that contain the same name (not using the filter
option)?

Penny Strapatsaki
e-mail: (e-mail address removed)

There is no way to do this algorithmically as there seems to be no sense to
the text structure. Additionally, VBA macros are not available in Office
2008.and, trust me, it will be faster, easier, and less expensive to do it
manually than to try to develop a script (in any language) that will do
this. You may be able to get some help by searching for the strings you want
using wild cards.