Hello:
I am new user of Enterprise Guide. I have an Excel file with a list of titles (i.e., manager, assistant manager, etc.) in column A, and a list of salaries in column B.
I have another Excel File that has a list of salary ranges (i.e., $40,000 to $50,000).
I would like to know if I can bring my first file (the list of titles and salaries) into Enterprise Guide and separate each row into one of the ranges. For instance, how many directors' salaries' range from $40,000 to $50,000)?
With this output from EG, I would like to be able to copy it into the second Excel file as I need to submit this file as part of a survey.
Thank you for any help or suggestions you may offer!
... View more