I need to get a formula in Excel to sort a contact list divided in categories
- or -
Post a project like this3009
$20
- Posted:
- Proposals: 5
- Remote
- #1012921
- PRE-FUNDED
- Completed
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have a contact list in an Excel file. I has several columns such as: last name, name, email, group 1, group 2, group 3, group 4, so on.
The problem is that thouse groups columns mean different categories (such as: alumni, students, stakeholders...) but they are not ordered, for example: one contact can be under student, lawyers and opinion leaders categories, but a second contact can be under opinion leaders, alumni and science categories (corresponding to the group 1, group 2 and group 3 columns in each case).
So, I need someone to create a formula so I can automatically have all the alumni contacts in a new sheet, all the students in a new second sheet; and also that every time I enter a new contact in the general sheet, then it will appear automatically in the corresponding "second sheet".
The problem is that thouse groups columns mean different categories (such as: alumni, students, stakeholders...) but they are not ordered, for example: one contact can be under student, lawyers and opinion leaders categories, but a second contact can be under opinion leaders, alumni and science categories (corresponding to the group 1, group 2 and group 3 columns in each case).
So, I need someone to create a formula so I can automatically have all the alumni contacts in a new sheet, all the students in a new second sheet; and also that every time I enter a new contact in the general sheet, then it will appear automatically in the corresponding "second sheet".
Matthias E.
97% (7)Projects Completed
4
Freelancers worked with
4
Projects awarded
50%
Last project
21 Sep 2017
Chile
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies