Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-24-2017, 06:48 AM
Cosmo Cosmo is offline Formula to calculate footnotes Windows Vista Formula to calculate footnotes Office 2007
Competent Performer
Formula to calculate footnotes
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

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.
Reply With Quote
 



Similar Threads
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
Formula to calculate footnotes IF Formula to calculate dates Sophie1 Excel 2 04-23-2014 07:19 AM
Formula to calculate Leap Year USAOz Excel 2 09-11-2011 04:58 PM
Formula to calculate footnotes What formula should I use to calculate commission? grs Excel 3 02-21-2011 02:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft