Hello everybody, I'lltry to explain my problem as good as possible.
I need to create a database with excel for managing resumes. I have data, then I fill a db and automatically, according to particular criteria, the names of the potential candidates for a job position must appear.
My problem is this. A person has either 0 or more than 1 job experience. But I have only one cell. Each experience has a duration.
How can I put into only one cell more than one experience, and in another cell, the duration of each?
Example
NAME JOB EXPERIENCE DURATION
MARCO ACCOUNTANT 1 YEAR
MARKETING 2 YEARS
I wanna select a person with an experience in marketing.
Please help me!
Try hitting ALT ENTER to create a new line in a single cell.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks