Cidolfus
09-23-2008, 10:44 PM
Hello,
I have a spreadsheet with lots of rows (40000+), and in the 2nd column of this spreadsheet, it consists of an organization's department, so the 2nd column would look something like this:
Sales
Sales
Sales
Finance
Sales
Finance
HR
HR
HR
Sales
etc...
What I'd like is to loop through this column, and be returned with all the departments - Sales, Finance, HR. (Something like dinstinct in PL/SQL)
How can I do something like that?
I have a spreadsheet with lots of rows (40000+), and in the 2nd column of this spreadsheet, it consists of an organization's department, so the 2nd column would look something like this:
Sales
Sales
Sales
Finance
Sales
Finance
HR
HR
HR
Sales
etc...
What I'd like is to loop through this column, and be returned with all the departments - Sales, Finance, HR. (Something like dinstinct in PL/SQL)
How can I do something like that?