Variable column to fixed array
Chip Pearson's site has a formula to do the opposite, but I didn't have any
luck rearranging the formula . . . I have a calendar with each day of the year in a 7 X 2 array with the date in the upper left cell. I am trying to match the day to an r X 2 worksheet where I have "Date" and "Employee Name" and return the employees' names that match the day. An employee's name will not occur twice on the same date, however the number of employees per date will vary, but will not exceed 12. Additionally, I would like to use a dynamic name range for the r X 2 worksheet so it can be amended anytime. Any thoughts, comments, or suggestions are greatly appreciated. Thanks in advance. |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com