Database Function

[Loisw]

HI,
is there a database function (or any other function) that will take all the customer ID's that contain C @ the beginning & insert them in a seperate table underneath the table @ the top? i am aware that it can be done by filtering but was wondering if it can be done by a formula.

Thanks

[zbor]

Off topic:

Maybe it's better way to define array with:

Basic Toolkit
Cement Mixer
Chainsaw
Heavy Toolkit
Lawn Roller
Lawnmower
Rotavator
Strimmer

with related prices, becuase tomorrow you might change those prices and all values in table will change (no need to adjust formula).

So, instead of:

=LOOKUP($D2;{"Basic Toolkit"\"Cement Mixer"\"Chainsaw"\"Heavy Toolkit"\"Lawn Roller"\"Lawnmower"\"Rotavator"\"Strimmer"};{21\33\18\30\10\22\27\13})

you might consider:

=VLOOKUP($D2; array, 2, FALSE)

where array can be defined somewhere else, for example Sheet2!A1:B50

[Cheeky Charlie]

You can create a formula which uses index, rank, large and match, incorporating a left()=C wouldn't be too hard, there are examples on this forum, but they are absolutely hideous. It's such a bad way of doing it I won't bother trying!

What you could consider is creating a pivot table - with a helper column in your raw data (like =left(customername)) you could easily select customer groups by initial.

CC