Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Excel Help #49189381


ChrisC

Recommended Posts

I agree. First we need a fully documented business process and you'll need to get the buy-in of senior management. Then we'll see about planning a kick-off meeting to consider your requirement.

 

:lol:

 

I'm thinking some kind of consolidation of the option columns. In that case just pivot it as SkippyjonJones suggested.

Link to comment
Share on other sites

Concatenate for merging the data (i.e. if you want first name and 2nd name in the same cell)

 

=CONCATENATE(A5,,B5)

 

 

and as suggested above, Pivot table for de-duping e-mail address.

 

Failing that, you could definitely do with reintermediating some leading-edge mindshare on this, and can do this by evolving the scalable functionality you're after.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...