-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Why do Index and Match do not work when you've multiple numbers in Cell
- Thread starter nsa1
- Start date
Attachments
Upvote
0
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 18,420
- Office Version
- 2019
- Platform
- Windows
Note1:
Make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "Yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
Note2:
I am not seeing something in your images.
Note: 3
I share my file for you to download on your computer. Remember to answer Yes to enable macros when you open the file.
In row 2 from cell E2 you will see the results that the IndexWithComma function returns.
drive.google.com
Regards
Dante Amor
Make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "Yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
Note2:
I am not seeing something in your images.
Note: 3
I share my file for you to download on your computer. Remember to answer Yes to enable macros when you open the file.
In row 2 from cell E2 you will see the results that the IndexWithComma function returns.
index comma.xlsm
drive.google.com
Regards
Dante Amor
Upvote
0
Similar threads
- Solved
