![]() |
#6
|
|||
|
|||
![]()
So far, I have gotten this partially working to where it's usable for now.
I have columns using INDEX/MATCH to get the values of the Options into columns in the scenario worksheets, and I created a range to store the legend (which I enter manually based on their order in the options columns) From there, I get the proper footnote symbol from the legend using another lNDEX/MATCH for each option column, and this is working properly for me. The only part that isn't working yet is the compilation of the legend itself (getting the unique non-empty values from all of the option columns). I do want to try to get this working in the future, and I have had some success with a formula in tests, but getting it to work in the actual worksheet hasn't happened yet. For now, it's easy to enter the values in the legend list manually so that i can get this task done. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Formula to calculate Frequency | lwls | Excel | 1 | 03-30-2015 05:40 AM |
![]() |
Sophie1 | Excel | 2 | 04-23-2014 07:19 AM |
Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
![]() |
grs | Excel | 3 | 02-21-2011 02:17 AM |