I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
Try using the Rank formula where the 5th parameter is the item of the Incentive Fees/Unrealized Investment Gain list.
Hi Rob, Thank you for the feedback. This was the result I got. Any feedback for how I can make this right? Thanks @rob_marshall
I thought that is what you wanted. What exactly are you needing the final result to be?
Hi Rob, My apologies. I had the incorrect pivot. That formula was just what I needed. Thank you! @rob_marshall