cascade

Can xlookup perform a cascade search in the event multiple rows show the same data? I have some data I'm collating and analyzing to see which value is the largest and showing it at the top of the list. However, when there are two values that are the same, it only pulls the first instance...

I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...

I'm using Excel 2013 and Windows 8.1. When I open a workbook, Excel resizes the one I'm opening to match the size of the most recently used open workbook and cascades the workbooks, with the newly-opened workbook the last one in the cascade (in the bottom right). As I open additional workbooks...

I'm in the process of setting up a model based on a simple p&L centre. The idea is to model out one centre (something like a franchise store) and each time we open another store it starts at the beginning of the model. I could do a cascade (as illustrated below) but that is not very elegant...

Does anyone know how to turn this off? I've tried disabling animations for win 8.1 through the control panel and graphics acceleration in Excel advanced options--neither are helping. The cascade of shortcut key leads is really screwing with my mind--it's like being punished for using keyboard...

Hello all. I'm trying to create a series of 3 cascading combo boxes using a technique I found on this board. The first combo (cbo.Areas) contains a list of "Body Areas" derived from the table of the same name (with columns: AreaID and AreaName). The second combo (cbo.Parts) lists more...