Видео

Hi Sir! Can I ask? where can I put these codes?

My sheets are always loaded with INDIRECT() references that I build right into the range names. It's not ideal because it slows things down but I f@#king hate tables because they won't let me put array formulas in the headers and for the reasons you mentioned. The real issue is that we're using Excel (and Google Sheets) for larger datasets where we should be using MySQL or some other proper database. We sacrifice performance for convenience.

I would like to add another method to check if "Y" is in column B and if so then to do the rest of the code. How would I add that in?

The fact that you try to show the different kinds of errors that we may encounter, makes the tutorial way more helpful. Thank you. Still one of the best tutorials out there in the YT after some 8 years.

Where can we see the outcome of this project?

Thank you for this (free) great content!

Certainly will be using this as a reference. Great that you included a downloadable file as well. Really appreciate the work that you do.

Can’t wait! Thanks for doing what you do

Looking forward to this, Mr Tiger Man 🐯

Thank you for watching the 30 Excel Formulae video - what did you make of the list? I'll get back to you in the comments!

Awesome video! Could you update the link of the practice files? I think they are invalid

=Trim(Substitute(A1, Char(160),""))

Just started watching this series. Seems like a fun challenge even though I'm not a chess player. I created the board using an IF statement with the IFEVEN and IFODD functions to color the even-numbered cells in the even-numbered rows and the odd in the odd rows in the specified range.

This is pretty old but really useful ,I also like the fact that he looks like Mark Webber

Of all internet, you were the first to provide a good and useful answer. Thanks, and congratulations

Excellent! Explained beautifully.

To be honest it'll be easier and quicker to just click the cell and delete the space !!

l want to know computer micro software offices

Thanks

This one was a lot of fun. Had it emulate the way traffic signals work here in the us, and added inactive light colors (dark red for off, etc). I like the idea of driving functionality from a central location in the workbook.

That is amazing! Thank you, but how did you find which is the Char160? It doesn't seem to work for me... I would like to know which is exactly the charcter that is generating the space for me.

What?

This is great. I've been a tech guy since I was 13 (I'm 54), and this is the first time that someone has broken it down like you. Being a tech guy, I'm usually trying to go straight to code and then all I do is confuse myself and end up giving up. Differentiating concept from code was an epiphany for me. Still loving this series from Milwaukee, Wisconsin (even if you do spell 'color' the wrong way) :)

Really appreciate. Thanks

Hey Chris, This is interesting but what if I want this to work on auto so when data is entered in the 1st sheet it will also appear in the destination sheet with using a play or activate button. The next step would be to sort the data on the destination sheet and only show the top ranking results with the code running on auto. Is there a more detailed video on your website?

Glad I found this. Great content! I'm a Software Quality Assurance tester. I'm between jobs now, so I got to thinking about how I might upgrade my job search spreadsheet and learn a few things on the way. I'm no stranger to code, but I really like your step by step approach. My ultimate goal is to create a dashboard that I can use to enter job search info, search for positions/companies I've already applied to, etc...and it's great fun learning this stuff and it keeps me busy. Thanks!

Love the ideas behind this video. I understand the code, however when I run it from Method 3 onwards I get Run-Time error '1004': Application-defined or object-defined error. The template sheet is active, I added an extra line of code to activate the worksheet. I do not know why I am getting this error? Worksheets("Template").Activate Sheets("Template").Range(Range("E2").Value).Value = _ Sheets("Template").Range(Range("H1").Value).Value

Thank you

❤Thank you

On a separate topic. Is it possible to create some buttons in the Ribbon to switch the cursor flow direction when Enter is pressed (rather than going into Options)? Perhaps using macros? Thank you for any consideration.

Thank you! I’m looking for how to use data similar to your sheet to create a progress table/grid (ie each of the “Actuals” is a row; each of the “Targets” is a column and get Excel to put the students’ names in the appropriate cell. Any tips?

I think power query is vba killer to a large extend.

What are your impressions of Power Automate? Is it a 'VBA Killer'?! Let me know your view in the comments!

This guy's body language gives off crazy Jim Carrey energy. Which is fun.

2:06 I also have been using that one the most, but recently I've been messing with "Use a formula to determine which cells to format," combined with "Stop if true," I've found that these combined is excellent for separating background graphics from sprites. You have a few "If this cell contains" rules at the top of the list with "Stop if true" checked, so that sprites get priority, then you have down at the bottom a bunch of "Use a formula to determine which cells to format" rules, the formula in question needs to determine the coordinates of the cell being formatted, I realized that for a finite range of cells this can be done through relative references, just put at the edges of the screen a bunch of values ascending upwards that tell each cell their X or Y coordinates, then in the formula you can find the Y-value by using $IW1 and the X-value with A$257 assuming your "screen" is 256*256 cells big. However, there's one problem I'm having that I'm hoping this video will address, well conditional formatting is far faster than VBA macros which I prefer to formulas, it is still really slow for some reason, surely there must be some kind of thing designed for rendering graphics, that or there's a way to get the conditional formatting to be faster.

You are Amazing!!!

Very good video, I hope you keep yourself safe.

Hello, this series has been really good, just got a question. I've set up a table and everything with the students ranked, but is there a way to have their corresponding values with them?

Hi there. I use a formula for tracking W/L streaks but I can't get it to work when there is a blank cell. for example.. Team A has 5 wins in a row, then an "off day" and then another win. so the streak should be W6 but because of the blank cell, the streak reverts to W1... Is there a way to continue the streak when there is a week with no game?

I love your tips thanks. Is there a way to make every other line one color and the other set of every other line a different color, just like "Format as Table" gives you, but without it actually becoming a "table"? When it becomes a table it becomes immensely difficult to move rows around in the table due to some internal rules Excel thinks it must follow. I could set up complex conditional formatting to do so, but then moving things around also becomes problematic. It seems like many versions ago, Excel let me do this without it becoming a complex table with a header. Thanks.

Thank you very much. You take your time in Explaining. Well done!

So easy to forget to reset the counter variable or reset it in the wrong place. Liked that you posted the video anyway.

Like this type of video. Was initially a little confused as to how you were getting the results around the 10 minute mark (Chris,Luna) until I realized that Golden Retriever was the last team on the first sheet (list was partially covered by camera inset of you typing) and that you were running the complete macro so this was the last entry processed. I had not downloaded the example file.

Excellent video learnt a lot and thanks for clearly explaining.

I want to do a three day rugby 7s tournament table and fixtures up to quarter, semi and grandfinals for three days. There are 40 male teams only participating altigether .Is it possible for me to use this template or if you can show me another i can do in excel.