Spreadsheet: 763464d1642181124-nesting-functions-with-len-right-left-filter-compare
Sheet: sample set

EQY_FUND_CRNCY | [NAME] | FA_ADJUSTED |  |  |  |  |  |  |  | Factset |  |  | [NAME] | Tickers in bloomberg not excel
USD |  |  |  |  |  |  |  |  |  | IRWD-US |  |  | MVIS-US
Ticker | Short Name | Market [NAME] | GM:Q | Revenue T12M | Market [NAME] | Price:D-1 | P/E |  |  | SMLR-US |  |  | GBT-US | GBT-US
None (1739 securities) |  |  |  |  |  |  |  |  |  | ELVT-US |  |  | LUG-CN | LUG-CN
MVIS US Equity | MICROVISION INC | 681030784 | 101.3927612304688 | 2338000 | 681030784 | 4.150000095367432 |  |  |  | NRDS-US |  |  | AWRE-US | AWRE-US
GBT US Equity | GLOBAL BLOOD THE | 1879223936 | 98.40544128417969 | 179945000 | 1879223936 | 29.15999984741211 |  |  |  | ZYXI-US |  |  | EH-US | EH-US
LUG CN Equity | LUNDIN GOLD INC | 1890403584 | 94.18672180175781 | 736138992 | 1890403584 | 8.081293106079102 | 7.696433067321777 |  |  | SCPL-US |  |  | ME-US | ME-US
AWRE US Equity | AWARE INC | 66834396 | 94.17964172363281 | 16284000 | 66834396 | 3.099999904632568 |  |  |  | SWI-US |  |  | DGHI-CN | DGHI-CN
EH US Equity | EHANG HOLDINGS | 914579072 | 67.96283721923828 | 15696511.48686133 | 914579072 | 16.5 |  |  |  | BDGI-CA |  |  | ACRG/A/U-CN | ACRG/A/U-CN
ME US Equity | 23ANDME HOLDIN-A | 2524784128 | 50.59053802490234 | 243920000 | 2524784128 | 5.78000020980835 |  |  |  | EH-US |  |  | VAPO-US | VAPO-US
DGHI CN Equity | DIGIHOST TECHNOL | 107545000 | 49.44343185424805 | 3556620.772471045 | 107545000 | 4.296687602996826 |  |  |  | WWW-US |  |  | WWW-US | TACT-US
ACRG/A/U CN Equity | ACREAGE HOLD-E | 157869632 | 49.4340705871582 | 162288469.2564296 | 157869632 | 1.639999985694885 |  |  |  | F-CN |  |  | F-CN | AMSWA-US
VAPO US Equity | VAPOTHERM INC | 484949760 | 49.38737869262695 | 131955000 | 484949760 | 18.60000038146973 |  |  |  |  |  |  | TACT-US
WWW US Equity | WOLVERINE WORLD | 2166313728 | 43.1600456237793 | 2288900064 | 2166313728 | 26.29999923706055 | 13.01003074645996 |  |  |  |  |  | AMWSA-US
F CN Equity | FIORE GOLD LTD | 113447920 | 40.5950813293457 | 81732885.39926332 | 113447920 | 1.112170338630676 | 5.269199371337891
TACT US Equity | TRANSACT TECH | 96288360 | 40.58475112915039 | 36026000 | 96288360 | 9.789999961853027
AMSWA US Equity
The BLOOMBERG PROFESSIONAL service, BLOOMBERG Data and BLOOMBERG Order Management Systems (the "Services") are owned and distributed locally by Bloomberg Finance L.P. ("BFLP") and its subsidiaries in all jurisdictions other than Argentina, Bermuda, China, India, Japan and Korea (the "BLP Countries"). BFLP is a wholly-owned subsidiary of Bloomberg L.P. ("BLP"). BLP provides BFLP with all global marketing and operational support and service for the Services and distributes the Services either directly or through a non-BFLP subsidiary in the BLP Countries. The Services include electronic trading and order-routing services, which are available only to sophisticated institutional investors and only where necessary legal clearances have been obtained. BFLP, BLP and their affiliates do not provide investment advice or guarantee the accuracy of prices or information in the Services. Nothing on the Services shall constitute an offering of financial instruments by BFLP, BLP or their affiliates. BLOOMBERG, BLOOMBERG PROFESSIONAL, BLOOMBERG MARKET, BLOOMBERG NEWS, BLOOMBERG ANYWHERE, BLOOMBERG TRADEBOOK, BLOOMBERG BONDTRADER, BLOOMBERG TELEVISION, BLOOMBERG RADIO, BLOOMBERG PRESS and BLOOMBERG.COM are trademarks and service marks of BFLP, a Delaware limited partnership, or its subsidiaries.