Previous Topic Next Topic

Excel Formula to populate fields

Closed
graphictees Posts 1 Registration date Tuesday January 25, 2011 Status Member Last seen January 25, 2011 - Jan 25, 2011 at 04:03 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 09:02 AM
Hello,

I have a spreadsheet with Employee names (A2...A150) & one of 5 Divisions that they work for (B2...B150). What I am trying to do is put them in a new sheet that will separate them into columns based on the Division that they work for. For instance, the new sheet (Sheet 2) would list each of the 5 divisions at the top of each column and then list the employees in alphabetical order that work for those divisions underneath.

So Employee1 who works in Division3 and Employee2 who works in Division4 will be listed on the new sheet under their respective divisions. I need Sheet 2 to update according to the list on Sheet 1.

Can this be done?

Thank you in advance for your response.

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 27, 2011 at 09:02 AM
It can be done most cleanly by macro. Formula can be tricky and would depend on a lot of other factors. So I suggest look into macro for this

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response