Excel: INDEX and MATCH #77
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Jennie
This is great. Can this be done in reverse? I mentioned an example in a comment in the -Create an excel macro- video about it but seems more appropriate for this video instead. So instead of finding out what values of sales, can you start with empty sale array so that one can fill in the sales values in the array by using the index and match (perhaps?) to populate the array with sales numbers....
reply
This is great. Can this be done in reverse? I mentioned an example in a comment in the -Create an excel macro- video about it but seems more appropriate for this video instead. So instead of finding out what values of sales, can you start with empty sale array so that one can fill in the sales values in the array by using the index and match (perhaps?) to populate the array with sales numbers....
reply
Hamza
How Can i open new sheet by typing any cell...?
For example.. i want to i have a sheet of costumer name and address ext ext...
Now how can i open my costumer's month sales detail i putted on another sheet...
Can i open his sales detail by clicking his name cell
reply
How Can i open new sheet by typing any cell...?
For example.. i want to i have a sheet of costumer name and address ext ext...
Now how can i open my costumer's month sales detail i putted on another sheet...
Can i open his sales detail by clicking his name cell
reply
lika
I wish you would go further to show example of how to use these functions in real life with thousands of rows of data. I cannot imagine using this formulas the way you showed in real life.
reply
I wish you would go further to show example of how to use these functions in real life with thousands of rows of data. I cannot imagine using this formulas the way you showed in real life.
reply
education
I-m taking an accelerated Excel summer class, using SIMnet. You explained this concept so well! So much more understandable than the text book!!! Thank you so much!!!
reply
I-m taking an accelerated Excel summer class, using SIMnet. You explained this concept so well! So much more understandable than the text book!!! Thank you so much!!!
reply
Faulrff
I-m taking an accelerated Excel summer class, using SIMnet. You explained this concept so well! So much more understandable than the text book!!! Thank you so much!!!
reply
I-m taking an accelerated Excel summer class, using SIMnet. You explained this concept so well! So much more understandable than the text book!!! Thank you so much!!!
reply
Mister
Excellent video and really helpful:), for the people who cannot download the practice file, right click on the link and select the -save as- option.
reply
Excellent video and really helpful:), for the people who cannot download the practice file, right click on the link and select the -save as- option.
reply
Add a review, comment
Other channel videos
