And if wanna have "Intersection" formatted with specific color you can add one more formula in conditional format using =AND(from city = Atlanta, to = Atlanta) - with proper referencing. Great videos, its helpful tough.
Hello Sabu. It is very nice to hear that my video helped you. To help others is the whole reason for me to produce and to post videos. Thanks for watching. T-E-CH
Thank you it is very useful to me useful information and professional explanation I would like to ask about the presentation software used in the explanation
I have a matrix which is a result of a pivot table and I need to look up the value in an intersection and put it in another spread sheet (for all the values) which will be used for mail merge spread sheet. Your video is very clear for 1 intersection. How do I populate the entire mail merge spread sheet with the data from the pivot table? Thanks!
Hello Mike. Thanks for sharing this challenge. If you would like, I can help you with your sheet. Email me at theexcelchallenge@gmail.com and we’ll communicate there. Remove any confidential information. I don’t need your data. All I need is the structure you have and the structure you need. I’ll be looking out for an email from you. Thanks for watching T-E-CH
So, in your example, I would use =INDEX(I3:W17),MATCH(H3,H3:H17,0,I3) to get the blank. Do I just fill up the rest of the spread sheet one by one? Thanks again.
Thanks alot for this video but may I ask how do we inverse this process? as if I enter "129", then it would return me "Driving from Philadelphia to new york is 129 miles"? Thanks again
Thanks a lot , but I have some problem my coloumn range contains values like 20,40,60 with a difference of 20 but I need to find intersect having decimal values like 20.1,20.2,20.4......., if I put all data in column it becomes a huge table . Can you help me to find intersect between the two values in column like between 20 and 40 so on.
What is the best formula(s) and how to use it, which can select multiple cells and show (with color) in a large excel file that contains financial data "between value", example: all cells between 31,950 to 32,020, then those between 39,450 to 40,100 in the same file.
Any idea, how can i retrieve the column name.. let's say i want to find which city if the most distant from Boston? I would really appreciate it. Thanks guys
How would one go about creating a chart; whether pie, bar etc. to show the difference between the cities? I am currently working on a similar project and would like some assistance please! I am having issues finding a visual aid that would show for example in this instance: "the distance traveled between Chicago and Atlanta is 944 miles." #HELP!
Hello Deanna-Kaye. You can use the formula foundation that I show in the video, and from there, play with formatting, i.e. larger font, colored cell background, colored font, etc. in order to highlight the features you want to highlight. If you have more questions, you can ask them here or you can email me at theexcelchallenge@gmail.com Thanks for watching! T-E-CH
Hello nice explanation. My question is: given a value, how can I have excel find the closest value in a defined matrix and then Have excel tell me what row and column it’s located in?
Cool Stuff. I need some help. I've got an employee schedule. Rows: B15:B100 has the employee names. Which match the Application.UserName Row: 2 has the Date: mm/dd/yyyy What I'm trying to do is when a given employee opens up the workbook, the sheet will activate to: Today's Date Employees Row. I'm able to do the above as individual functions but not together. For date: I found some code that does a .find on CLng(date) and then once it finds the cell it does the application.goto cell For the employee name: I just set the range: B15:B100 and if value = Application.Username then I go to that cell. I just can't get them to work together.
Hello Mai, Select all the cells where you have numbers and right-click on them. Find the Cell Format option and once the window opens up, select a time format. Repeat the exercise as I show it in the video and that should do the job. Thanks for watching. T-E-CH
Thank you. this was a very helpful video. I have a question, i need help with, would you be able to help me please. this has to do with event scheduler that has the (day(row 1) and date(row 2)) on the column and the hours(15min interval) in the row. I want to be able to insert a data by selecting day or date vs time and fill in the intersection with info. I would appreciate your help. If I can provide you my email please let me know, i will temporarily post it upon your reply. thank you.
hi, how do I find the column name for a value in a table? So I have these sets of scores on a column, and I wanna add the name of the column that the score is from to the cell next to it. How do i do that?
Thanks a ton. I was stuck with a problem for past many hours, you sorted it out easily. Loved the way you explained. Cheers
Thanks so much for breaking it down in such a brilliant way!! Best tutorial ever for Index Match...
Amazing! I was wondering how to find for one "X" , a value which is having multiple "y" values. This video helped me out. Thanks!
Thanks you have solve my most pending problem...thanks once again. God bless You.
I was stuck and now making some progress. Thanks. Great video.
Very well simplified. Thanks.
Thank you, thank you for this tutorial!
Wow that's a complete explanation. I'm a loyal fan now.
LOL. Thank for the loyalty Norman. It's encouraging to hear you liked the explanation.
T-E-CH
very helpful thank you
MASSIVE THANK YOU!!!
Very good, easy to understand tutorial
Thank you!! Subscribed.
Thank you so much brother!
Man! This was a saver. Thanks a lot.
Really very useful.
Thanks
Hey, thank you very very much, you have solved my problems, great
And if wanna have "Intersection" formatted with specific color you can add one more formula in conditional format using =AND(from city = Atlanta, to = Atlanta) - with proper referencing.
Great videos, its helpful tough.
great thanks 🎉
Thanks, you make it easy for me to learn. Keep going
thank you for this its very clear
Thank you. That was very helpful.
beautifully simple! Thank you!
Best explanation given. Gj
excellent !!
Thank you!!!
the explanation id so clear .. this really helped me , THANK YOU FOR BEING THERE FOR US :)\
Hello Sabu. It is very nice to hear that my video helped you.
To help others is the whole reason for me to produce and to post videos.
Thanks for watching.
T-E-CH
Thank you it is very useful to me useful information and professional explanation
I would like to ask about the presentation software used in the explanation
Is there a way to only highlight the intersecting cell instead of the whole row or column around it?
excellent
It is Great 😊💓💓
I have a matrix which is a result of a pivot table and I need to look up the value in an intersection and put it in another spread sheet (for all the values) which will be used for mail merge spread sheet. Your video is very clear for 1 intersection. How do I populate the entire mail merge spread sheet with the data from the pivot table? Thanks!
Hello Mike. Thanks for sharing this challenge. If you would like, I can help you with your sheet. Email me at theexcelchallenge@gmail.com and we’ll communicate there. Remove any confidential information. I don’t need your data. All I need is the structure you have and the structure you need. I’ll be looking out for an email from you.
Thanks for watching
T-E-CH
I think the simple way of putting it, say in your example is.... how do I find the formula for each distance in each intersection.
So, in your example, I would use =INDEX(I3:W17),MATCH(H3,H3:H17,0,I3) to get the blank. Do I just fill up the rest of the spread sheet one by one? Thanks again.
Thanks alot for this video but may I ask how do we inverse this process? as if I enter "129", then it would return me "Driving from Philadelphia to new york is 129 miles"? Thanks again
Good work.Thanks
Thank you Syed. Glad to hear you liked my work.
T-E-CH
Thanks a lot , but I have some problem my coloumn range contains values like 20,40,60 with a difference of 20 but I need to find intersect having decimal values like 20.1,20.2,20.4......., if I put all data in column it becomes a huge table . Can you help me to find intersect between the two values in column like between 20 and 40 so on.
What is the best formula(s) and how to use it, which can select multiple cells and show (with color) in a large excel file that contains financial data "between value", example: all cells between 31,950 to 32,020, then those between 39,450 to 40,100 in the same file.
Awesome
Any idea, how can i retrieve the column name.. let's say i want to find which city if the most distant from Boston? I would really appreciate it. Thanks guys
Thank you for blowing my mind again :D
8:00 is the magic
How would one go about creating a chart; whether pie, bar etc. to show the difference between the cities? I am currently working on a similar project and would like some assistance please! I am having issues finding a visual aid that would show for example in this instance: "the distance traveled between Chicago and Atlanta is 944 miles." #HELP!
Hello Deanna-Kaye.
You can use the formula foundation that I show in the video, and from there, play with formatting, i.e. larger font, colored cell background, colored font, etc. in order to highlight the features you want to highlight.
If you have more questions, you can ask them here or you can email me at theexcelchallenge@gmail.com
Thanks for watching!
T-E-CH
Hello nice explanation. My question is: given a value, how can I have excel find the closest value in a defined matrix and then Have excel tell me what row and column it’s located in?
Same problem I am facing .. you found out any ?
What if i want to have 2 tables for the lookup array? I don’t know how to fix this
Cool Stuff.
I need some help.
I've got an employee schedule.
Rows: B15:B100 has the employee names. Which match the Application.UserName
Row: 2 has the Date: mm/dd/yyyy
What I'm trying to do is when a given employee opens up the workbook, the sheet will activate to:
Today's Date
Employees Row.
I'm able to do the above as individual functions but not together.
For date: I found some code that does a .find on CLng(date)
and then once it finds the cell it does the application.goto cell
For the employee name: I just set the range: B15:B100 and if value = Application.Username then I go to that cell.
I just can't get them to work together.
how would this be done in Google Sheets?
i need to do this same formate but with time, how do i go about doing that?
Hello Mai,
Select all the cells where you have numbers and right-click on them. Find the Cell Format option and once the window opens up, select a time format. Repeat the exercise as I show it in the video and that should do the job.
Thanks for watching.
T-E-CH
If i want the opposite one ? Select cell and get the name given nearest to the row and column
Thank you. this was a very helpful video. I have a question, i need help with, would you be able to help me please. this has to do with event scheduler that has the (day(row 1) and date(row 2)) on the column and the hours(15min interval) in the row. I want to be able to insert a data by selecting day or date vs time and fill in the intersection with info. I would appreciate your help.
If I can provide you my email please let me know, i will temporarily post it upon your reply. thank you.
you are a magician (Y)
Thanks Munawar. Hope you found it helpful.
+1 subscriber
It looks like that function only look for an max of 15 arros cells and 15 columns cells, i does give me an error #Ref :\
Please tell me " The cell address of the cell made by the intersection of D column and 7th rows is ________
can you send me the file
Hello Vinay. I just sent you the file. Check your inbox and if it isn't there, try your spam folder. It may have gone there. Thanks for watching.
hi, how do I find the column name for a value in a table? So I have these sets of scores on a column, and I wanna add the name of the column that the score is from to the cell next to it. How do i do that?