|
|
#5
09-06-2018, 10:35 PM
|
|||
|
|||
Two possible formulas (PasteSpecial formula results into your column as Values, after that you can delete the column with formulas. Or simply use formula.).
When you have different number of persons, you have to edit the persons list reference range in formula. To avoid formula editing, you have to use dynamic named range for names list range defined and used instead of cell reference, or you define both your tables as Tables, and convert provided formula into Table formula. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA to distribute all columns evenly within tables | NorthSuffolk | Word VBA | 3 | 09-23-2017 05:28 PM |
 Project does not distribute work evenly between the days
|
Campelliann | Project | 1 | 01-09-2017 06:01 PM |
|
Distribute shapes equally
|
Losey | Visio | 2 | 11-18-2014 01:29 PM |
| How to distribute and retrieve information with Outlook 2003 form | freemang | Outlook | 0 | 01-09-2014 02:09 PM |
| Resize and distribute width - 2 pictures | AndyDDUK | PowerPoint | 2 | 10-10-2012 03:38 AM |
Windows 8 
Office 2016
Threaded Mode