Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with if & order ..??
i have a book that has 3 columns
A B C id name accounts i have 500+ entries, all w/different ids and names but the accounts are the same because i only have 4 accounts. what i need to do is add 4 columns (1 for each acount) and show in each new column only the ids of the employees who are assigned to those accounts BUT one after the other. i ca ndo an if statement and it will give me the results but the returned values in columns D-G won't in order. i mena, will have spaces in between and i need them w/o any blanks... any ideas?? A B C D E F G id name accounts accnt-1 accnt-2 accnt-3 accnt-4 001 joe accnt-1 001 004 003 015 003 patrick accnt-3 010 005 007 023 004 louis accnt-2 105 005 fsavid accnt-2 007 ryan accnt-3 010 sam accnt-1 015 carlos accnt-4 023 oliver accnt-4 105 natalia accnt-1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with if & order ..??
First sort your data by Acct Number, then copy and paste the appropriate
results into the 4 columns that you are creating. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |