![Brian](/img/default-banner.jpg)
- 232
- 3 851 431
Brian
United States
Приєднався 11 сер 2006
Random how-to's and fun stuff
Will it AI | Deleting duplicates horizontally in Excel
I used AI to write the python code to remove duplicates occurring horizontally in an Excel worksheet. In this episode, I showed you my process real-time, and even though it gave me a workable solution in the first go, I kept tweaking the GPT prompt to get back exactly what I wanted. If you need the python code you can find it on my git account here: github.com/brianleedick/delete-excel-duplicates-horizontally/commit/74b17c99ec259657867e07eda20924ec496777f0 ...just simply copy and paste into your python ide.
Переглядів: 20
Відео
Will it AI | Creating Amazon Affiliate Links Using a List of Product Descriptions Programmatically
Переглядів 16День тому
I used GPT to create the python code, that takes the description of an item in an excel document...in this case book titles and authors, to find the relevant Amazon url, and then add the affiliate tag on programmatically across multiple products and reinsert the resulting url into the excel file. This will require the use of a Google Cloud console, that may cost a modest amount of money if you'...
How to separate data with multiple lines of data per cell
Переглядів 1813 місяці тому
If you have have a dataset, where randomly within your data there are cells with line breaks between data, and you want each one of those lines to be in their own cells, this is the best way I've found to fix this. Unfortunately, it is a multiple step process, but it's the fastest way i found out how.
How to remove random blank data in a dataset excel
Переглядів 2493 місяці тому
Have a dataset in excel with random blanks you want removed. This tutorial quickly shows you how to remove them so that your data looks cleaner and you can do further analysis with less headaches.
New Matter Mod-T 3D printer won't connect (blinking light)
Переглядів 1318 місяців тому
if you happen to have a old new matter mod t printer that's still working. I've recently run into an issue that I haven't encountered yet. where periodically the filament header who climb all the way up to the very top of the lead screw and it causes an issue on future prints. when I connect via USB cord, the printer power light flashes on and off and my computer will not recognize that it's co...
How to fix speed issues on Sole treadmill
Переглядів 27 тис.Рік тому
if you're getting an e2 warning or speed control issues with your sole treadmill one possible and luckily cheap fix is to check the speed control sensor under the protective cover near the motor. our treadmill was slowing down before speeding up and speeding up before slowing down and ultimately we got an e2 warning. when we get on and by pushing the sensor closer we fix the issue. this particu...
My task bar is frozen and not working | How to fix without restart
Переглядів 14 тис.Рік тому
This is a quick tutorial on how you may be able to get your task bar unfrozen and back to functioning properly without having to reboot your computer. If you open up the task manager (by hitting ctrl alt del) you should see an application or process called, "Windows Explorer". Right click on that icon and select "restart". Give it a few seconds (the task bar may actually disappear and come back...
How to get the formula bar back in Excel | Short term and Default
Переглядів 1,6 тис.Рік тому
Recently, when I've opened my Excel workbooks the formula bar is mysteriously missing. I know the easy solve to pull it up short-term under the view tab, but didn't know how to update it as the default until just recently. This video is meant to show both methods. The short term fix and the long term default settings update for how to bring back the formula bar in Excel
How to Count Net Workdays in Google Sheets and how to list a full year
Переглядів 4,8 тис.Рік тому
This tutorial explains how to determine the number of networkdays in a given year, which automatically excludes your lovely weekends and holidays for you. Then in the second part, I show you how to make a list of all the workdays in a separate column if that is something you are to need. Oddly enough, Google Sheets performs the "Networkdays" formula the same as Excel. But in terms of listing th...
How to determine the number of workdays in a year and list them
Переглядів 784Рік тому
This tutorial will show you how to use the "networkdays" and "workday" formulas in excel. Networkdays is a good starting point in the process because it will calculate the number of workdays you have in a given year (which eliminates weekends, and holidays assuming you have a list of holidays). With this number calculated you can then create a list of the actual workdays in a column using. Hate...
What to do if you get treadmill bed oil on the motor belt of my treadmill and it keeps skipping!
Переглядів 6 тис.Рік тому
Have you ever gotten the 100% silicon treadmill belt oil on your motor belt? if you have you've probably worried you ruined the whole treadmill because it skips constantly and you can't get the oil off. i went online to try to find solutions and everything i found only got be about 60-80% of the way there... this (chalk) is the only thing I've found that works completely for a long period of ti...
What is this swarm of insects? Mixture of June bugs and bumble bees? Is that common?(Central OH USA)
Переглядів 779Рік тому
trying to figure out what these insects are in central Ohio without having to knock them down and likely kill them to figure it out. there are thousands of them, they are staying close to the bushes and grass and regularly collide into things but don't seem to fall and die when that happens.
Can you make a bandsaw riser block out of wood? Yes, but...
Переглядів 2,2 тис.2 роки тому
If you're looking for how to make a riser block for your bandsaw, but don't want to pay for an expensive one, one doesn't exist for your model, or you simply prefer a diy option. this video will help walk you through the build process. It will also outline some of the key considerations, benefits, and shortcomings of using a riser block in general. As promised, the equation referenced in the vi...
High resolution UFO spotting video evidence THEY DON'T WANT YOU TO SEE | PROOF they exist
Переглядів 1382 роки тому
Pretty much open and shut case on this one, bohyzzz. Explain this one government?!?!?! Usually UFO pictures are grainy and easy to discount...not so sure on this one.
Low Budget Walking Desk Treadmill Conversion Option
Переглядів 1,7 тис.2 роки тому
Low Budget Walking Desk Treadmill Conversion Option
Why is my Davinci Resolve export only a second long
Переглядів 13 тис.2 роки тому
Why is my Davinci Resolve export only a second long
How to get rid of the color inversion shortcut on Android phone
Переглядів 40 тис.2 роки тому
How to get rid of the color inversion shortcut on Android phone
How to make micro object movements in Tinkercad
Переглядів 5 тис.2 роки тому
How to make micro object movements in Tinkercad
Mine Ethereum with Windows Laptop and Nvidia Graphics Card
Переглядів 9 тис.3 роки тому
Mine Ethereum with Windows Laptop and Nvidia Graphics Card
How to import a Wikipedia table into Google Sheets
Переглядів 10 тис.3 роки тому
How to import a Wikipedia table into Google Sheets
How to create a progress bar in a cell in Excel
Переглядів 4393 роки тому
How to create a progress bar in a cell in Excel
Create a completion bar in Google Sheets
Переглядів 1,1 тис.3 роки тому
Create a completion bar in Google Sheets
How to find the keywords used for youtube videos
Переглядів 7493 роки тому
How to find the keywords used for youtube videos
How to fix a cheap space heater for free (pressure switch fix)
Переглядів 48 тис.3 роки тому
How to fix a cheap space heater for free (pressure switch fix)
Taking apart and fixing Blue Yeti Mic that won't turn on
Переглядів 6 тис.3 роки тому
Taking apart and fixing Blue Yeti Mic that won't turn on
What you can earn on YouTube with a small channel
Переглядів 2143 роки тому
What you can earn on UA-cam with a small channel
DIY pixel 2 cell phone lens removal
Переглядів 3,9 тис.3 роки тому
DIY pixel 2 cell phone lens removal
USB C Charging Cord Keeps Popping Out
Переглядів 19 тис.4 роки тому
USB C Charging Cord Keeps Popping Out
THANK YOU SO MUCH BROTHER!!!!!
Thanks mate. Your video has helped me fix my little heater.
Thank u 😂
How do you put the guides back in.
Спасибо большое! Очень помог
Perfect just what I was looking for but I am putting a letter in the cell and having it change colour for a spreadsheet who is or who is not at work.
this worked and fixed it but it only fixed it for 2 minutes. i tried again and it still stops working after 2 minutes.
Hmm.. sounds like your system is restarting this process rapidly. Can you right click on the process name and see if there is anything in properties or settings that implies a time of restart
Top category.
It's good lesson but how can those colors replacement the words or grade for example where we have the marks 10 we need green color but number 10 no display how can I do?
hmmm...not sure i follow. You want to treat a number differently than a number + text?
Is there a way to show two team names for example if there is a tie?
Good information
brilliant video, I am reading it through a book but this explains it more Clearly
Thanks
You're the greatest! I didn't do this, but I bent off a tiny corner of copper off the tab and jammed it into the gap to complete the circuit. We will have to be careful it doesn't catch on fire by tipping over but that's ok!
Hi, I'm having trouble finding it on google: what's the rule for this but the trigger being another cell being blank vs unblank. I'm doing room checks and have a comments cell for each room where I list any errors. I want the room number cell to turn red if there's any errors written down, so I guess =d1="literallyanytextaha,what'sthelineforthat" thanks!
how do you get rid of the lock?
Where is that on the ipad 😢
THANK YOU VERY MUCHH SAVE MY THE LIFE TODAY
this saved me a huge meltdown! Thank you!
Wait nvm i found it! thank you!
what if your layout doesn’t look like that, where do you find that tab?
Thank you
Amazing 😭💕
Awesome tutorial. Do you have any course in udemy for such cool tricks in excel?
Amazing tutorial, straight to the point, and saved me hours of work by not restarting my computer. Thank you👍
Thx, make my brain smoking try to find file to stop this madness.
Much obliged.
I APPRECIATE YOUR HELP
Damn, you just saved me so much time on something it could have taken me years of head-banging to figure out. Thank you so much!
Thank you! $ was the only issue.
how do you get rid of the $?
Thankyou for the help I have been searching for a way to make the snap finer.
Thank you!! It is helpful
THANK YOU for this. I was literally losing my mind trying to fix this.
You saved me a 40 min video. tysm
Thank you soo much ❤
such a dumb fix, thanks bro !
Bro I had tried it... But not worked.... My pc suddenly freeze whenever I open application when I click start menu it didn't respond and later respond and mouse clicking not working
How do you open and close the function brackets/parenthesis?
You made that so much harder than it needed to be
thats why ur the goat
Thank you very much! The little copper spring had simply popped out. Popping it back in again fixed the problem! So much better than buying a new heater.
Thanks bro
Shortest and most beneficial video ever, thx
I became so dizzy, glad to know it's likely just a senor causing the speed issue
This doesn't work when my data is coming from data validation. If you can please help?
Genius! Thank you so much!
Thanks man!
How do I get my mod-t to work? I don't know the software I need to run it.
❤❤❤❤❤
OMGGGGGGGGG you saved my work of 43 hours... Can't thank you enough 😭