User Profile
JKPieterse
Silver Contributor
Joined Oct 06, 2016
User Widgets
Recent Discussions
Re: XLOOKUP not working for multiple criteria
For me it works if you use same-row references inside the table you are writing the formula into: =XLOOKUP(1, ([@[High Score]]=GameStats[Score])*(GameStats[Board Game]=[@[Board Game]])*(GameStats[Board / Scenario]=[@[Board / Scenario]]),GameStats[Player],,0,1)Re: Excel workbooks keep breaking
This sometimes starts happening with workbooks with a long editing history. I would start with checking the range names (Formula tab, Name Manager). Anything there that you don't need you should get rid of. Also, on the Home tab, click the Cell Styles drop-down. Does it show many styles in the "Custom" category? To resolve this it is advised to try to create a fresh workbook. Open a new blank file and insert as many worksheets as your old one has. Name them exactly the same. Now copy the used area from each tab in the original and do a Paste Special, Formulas into the associated tab of the new file. Of course any special items need to be rebuilt, such as tables, charts, pivot tables etcetera.Re: Focus Cell
I'm afraid that feature is unavailable in Excel 2021. You could try this little and free add-in of mine: https://jkp-ads.com/download.aspx#findmycursor Alternatively, just below that add-in is FollowCellPointer, another add-in aimed to help you see where you are. Note that the latter may clear your undo stak. The first one doesn't.
