VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Excel Hash Competition 2019 - Dynamic Playoffs Table - My Online Training Hub

Excel Hash Competition 2019 - Dynamic Playoffs Table - My Online Training Hub

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Excel Hash Competition 2019 - Dynamic Playoffs Table - My Online Training Hub This is my entry in the Excel Hash competition where we had to create an integrated solution using Icons, XOR, Dynamic Arrays and Linked Pictures. You RATE the entries based on how well you think they integrated all 4 ingredients here: http://bit.ly/2DaEtPn Download the Excel file here: https://www.myonlinetraininghub.com/excel-hash-2019-dynamic-team-table WATCH the other awesome entries here http://bit.ly/2LA49Js from my fellow Excel MVPs who are: Bill Jelen - MrExcel Leila Gharani Jon Acampora - Excel Campus Oz du Soleil - Excel on Fire Be sure to subscribe to their channels too! - Want More Excel
Date: 2022-04-08

Comments and reviews: 9


Many thanks for your great videos. But I have been struggling with something in Excel sheet and until know I couldn't get a solution and I am doing it manually. Let me give you and example. In the excel sheet I got so many activities. Let's say five activities, but the there are 30 description of the same of those five activities. So basically I want to sperate or get each one activity according their description. Such as;
Description Activity
1_ good A1
2- good
3- bad. A2
4- bad
Drag or put each activity according to the different description of the activity.
Many thanks. Thanks in advance

reply

Mynda, I just watched these videos. I thought they were awesome and look forward to using all of the tools each of you presented once I learn them! I love the collaboration between you all as Excel MVPs. I am going to become an excel MVP one day. I have taken so many classes by Excel MVPs and they have helped me sooooo much. Thank you ALL. I had not heard of you before but I am glad that I have now. I found your video to be the most simple and digestible.
reply

I like Oz, but my bet is on you! You are the best excel teacher on the market!! I don't haven't even looked at your answer, but you will win!! As a side, I would like to send you some ideas for video topics.
reply

Hi Mynda.. nice solution.. clean and clever. I especially like the dynamic image lookup with INDEX and MATCH in a named range.. super creative. Thanks for sharing all your tips. I give it a thumbs up!
reply

very simple.. but lacks explaination.. but i love the way you do it mam.. direct to the point.. mwahugs mam mynda.. love you all who join the excel hash.. more power
reply

I love it Mynda! The use of the named range in the linked picture reference is really smart and opens up a lot of possibilities for dynamic images. Awesome! -
reply

Mynda, you've nailed it again! Love the simplicity and and so beautifully put together. You all did awesome imaginative solutions but I put you in front :)
reply

MYNDA!!!! Amazing! So clean. Simple. Everything is tied together so neatly ... and with a Named Range included.
Brilliant!

reply

hi is there any possibility to bring interface in excel without vba forms??? or from other resources like ms
access forms

reply
Add a review, comment






Other channel videos