Hi, I've been using this forum to solve multiple challenging problems for some time, but I recently signed up to ask a question. Hopefully, I can get some assistance.
Based on a date range that are a table column's names (column names are formatted as dates), I would like to return the values from the first column that are based on the values within the table.
For example, based on the table below, for values that are 20% and less, between 11/1/2013 and 1/1/2014, I would like to return "Person A, Person C, Person D and Person F"
TABLE
----------------------------------------------------
| Resources| 09/13|10/13|11/13|12/13|01/14|02/14|
----------------------------------------------------
|Person A | 0% | 30%|20%|10%|10%|20%|
|Person B | 0% | 30%|20%|40%|40%|20%|
|Person C | 0% | 30%|20%|10%|10%|10%|
|Person D | 0% | 30%|20%|10%|10%|20%|
|Person E | 0% | 30%|20%|40%|40%|20%|
|Person F | 0% | 30%|20%|10%|10%|10%|
------------------------------------------
RESULT
----------
| Resources|
----------
| Person A |
| Person C |
| Person D |
| Person F |
----------
Thank You!!!!![]()
Bookmarks