Forum Discussion
Formula to return duplicate values
Hi Everyone, I need assistance on a formula to return duplicate values that wouldn't break the formulas i currently have on the spread sheet To summarize what the spreadsheet does : On the ...
Wow! Not the simplest of spreadsheets. Not sure if I follow why you have all these formulae in the Fee Split tab.
Would it be possible to restructure the data in SecLendingDetail? Now you have separate rows for each possible Holding% for a individual Instrument code. I sense it would become much easier when you have one row for each Instrument code, but with separate columns for each Holding%. From your data I understand that an Instrument can have up to 3 Holding%s (thus 3 columns).
Then it will be very easy to split the Fee on the LenderDaily Billing tab for each Ticker ID by a VLOOKUP formula that picks up the valid % in your "restructured" SecLendingDetail tab.
Just a suggestion. Good luck!