auto scooby

I am looking to perform a calculation that concatenates certain cells (text) based on conditions

Column A Column B Column C Result

Name 1 Text Text Nothing
Name 1 Text Text Nothing
Name 1 Text Text Col a1+b1+c1+b2+c2+b3+c3
Name 2 Nothing
Name 2 Col a4+b4+c4+b5+c5
Name 3 Etc.............
Name 3 Etc.............
Name 3

Any ideas

ChefDude

=if([Condition], [Condition is true value], [condition is false value])

eg;
= I F (A3 = 1,B3 & " " & C3,"False Condition Text")

if you want to do an OR name = "mike" or name = "fred", then...
= I F (OR(A2 = "Mike", A2 = "Fred"),B2 & " " & C2)

similar for AND too.

does that make sense?

DCI Gene Hunt

DCI = IF "this 290)( makes >//3 sense to you **&66y you're @<< a nerd

ChefDude

fvckin scoobybastidnet parser Grrr

go look it up.

auto scooby

Understand that

Column A will be a list of names, some names will appear 1,2,3,4 times.

If name appears once on one row then concat b2,c2
If name appears twice, on two rows then concat b2,c2.b3,c3
if name appears three times on three rows then concat b2,c2,b3,c3,b4,b4

Your forumulae does not take into account the testing for when a name changes in column a and then concatenating based on that.

I am still stuck and have cheated using Ultraedit. Which is not really any good as it takes to long.

Any more ideas

ChefDude

judicious use of countif may well help then

ChefDude

actually, scratch that. you need to write some vba

i'm a bit busy for coding.

auto scooby

Bizarre, I came to exactly the same conclusion.

Tried to use CountIf and then decided that I could not easily make use of the result.

Am know searching for simple import scripts to use Access !!