Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting column to 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
Array | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |