XcelLearner
Board Regular
- Joined
- Feb 6, 2016
- Messages
- 52
- Office Version
- 365
- 2016
- Platform
- Windows
Hi,
I have a data array of n (n>100) stock tickers with their respective values. The tickers and their values are randomly distributed, not in an order. I need to look for tickers with largest values, which I used LARGE and ROWS together with XLOOKUP functions. However, when there are two tickers with indentical values, the formulae only display one ticker.
For example, in this table, I have two tickers (AFG, FJFGJ) with value of 64, but only one ticker (AFG) is shown. Please refer to the table.
How could I revise the formula so that both AFG and FJFGJ will be shown? I use Office 365.
Thank you very much.
I have a data array of n (n>100) stock tickers with their respective values. The tickers and their values are randomly distributed, not in an order. I need to look for tickers with largest values, which I used LARGE and ROWS together with XLOOKUP functions. However, when there are two tickers with indentical values, the formulae only display one ticker.
For example, in this table, I have two tickers (AFG, FJFGJ) with value of 64, but only one ticker (AFG) is shown. Please refer to the table.
How could I revise the formula so that both AFG and FJFGJ will be shown? I use Office 365.
Thank you very much.