Brian
Brian
  • 232
  • 3 851 431
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
How to fix a slow flowing sink
Переглядів 4383 роки тому
How to fix a slow flowing sink
DIY pixel 2 cell phone lens removal
Переглядів 3,9 тис.3 роки тому
DIY pixel 2 cell phone lens removal
Cider Press on a Budget
Переглядів 1,7 тис.3 роки тому
Cider Press on a Budget
USB C Charging Cord Keeps Popping Out
Переглядів 19 тис.4 роки тому
USB C Charging Cord Keeps Popping Out

КОМЕНТАРІ

  • @kjordy
    @kjordy 21 годину тому

    THANK YOU SO MUCH BROTHER!!!!!

  • @amarsen6129
    @amarsen6129 2 дні тому

    Thanks mate. Your video has helped me fix my little heater.

  • @mahafunnytv6730
    @mahafunnytv6730 4 дні тому

    Thank u 😂

  • @1986marconi
    @1986marconi 4 дні тому

    How do you put the guides back in.

  • @A.Andrei.
    @A.Andrei. 6 днів тому

    Спасибо большое! Очень помог

  • @sueblakey1858
    @sueblakey1858 7 днів тому

    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.

  • @captain11201
    @captain11201 8 днів тому

    this worked and fixed it but it only fixed it for 2 minutes. i tried again and it still stops working after 2 minutes.

    • @BrianLeeDick
      @BrianLeeDick 8 днів тому

      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

  • @FxPatron
    @FxPatron 9 днів тому

    Top category.

  • @iyakaremyepatrick3710
    @iyakaremyepatrick3710 11 днів тому

    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?

    • @BrianLeeDick
      @BrianLeeDick 9 днів тому

      hmmm...not sure i follow. You want to treat a number differently than a number + text?

  • @danielaj5494
    @danielaj5494 11 днів тому

    Is there a way to show two team names for example if there is a tie?

  • @saurabhpathak6891
    @saurabhpathak6891 12 днів тому

    Good information

  • @ronancoogan2772
    @ronancoogan2772 12 днів тому

    brilliant video, I am reading it through a book but this explains it more Clearly

  • @humanharddrive1
    @humanharddrive1 14 днів тому

    Thanks

  • @Evabernard868
    @Evabernard868 15 днів тому

    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!

  • @adamrogers6231
    @adamrogers6231 15 днів тому

    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!

  • @crilups
    @crilups 17 днів тому

    how do you get rid of the lock?

  • @default587
    @default587 19 днів тому

    Where is that on the ipad 😢

  • @asimansari6672
    @asimansari6672 21 день тому

    THANK YOU VERY MUCHH SAVE MY THE LIFE TODAY

  • @ybcwaxgaming
    @ybcwaxgaming 22 дні тому

    this saved me a huge meltdown! Thank you!

  • @TaelorHigh
    @TaelorHigh 22 дні тому

    Wait nvm i found it! thank you!

  • @TaelorHigh
    @TaelorHigh 22 дні тому

    what if your layout doesn’t look like that, where do you find that tab?

  • @liamhandville6107
    @liamhandville6107 24 дні тому

    Thank you

  • @honanleon1489
    @honanleon1489 24 дні тому

    Amazing 😭💕

  • @ghostrider-hk5jm
    @ghostrider-hk5jm 25 днів тому

    Awesome tutorial. Do you have any course in udemy for such cool tricks in excel?

  • @AJRPlayz
    @AJRPlayz 25 днів тому

    Amazing tutorial, straight to the point, and saved me hours of work by not restarting my computer. Thank you👍

  • @muhammadnazerinsaripin1925
    @muhammadnazerinsaripin1925 29 днів тому

    Thx, make my brain smoking try to find file to stop this madness.

  • @frankiess1027
    @frankiess1027 29 днів тому

    Much obliged.

  • @Fahad-rw3zr
    @Fahad-rw3zr Місяць тому

    I APPRECIATE YOUR HELP

  • @riledmouse4677
    @riledmouse4677 Місяць тому

    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!

  • @ashronaldosrkira7102
    @ashronaldosrkira7102 Місяць тому

    Thank you! $ was the only issue.

    • @crilups
      @crilups 17 днів тому

      how do you get rid of the $?

  • @jabbathetuck
    @jabbathetuck Місяць тому

    Thankyou for the help I have been searching for a way to make the snap finer.

  • @saisb8309
    @saisb8309 Місяць тому

    Thank you!! It is helpful

  • @BruteforceExplorer
    @BruteforceExplorer Місяць тому

    THANK YOU for this. I was literally losing my mind trying to fix this.

  • @boltirgames
    @boltirgames Місяць тому

    You saved me a 40 min video. tysm

  • @payelroy9816
    @payelroy9816 Місяць тому

    Thank you soo much ❤

  • @shy7940
    @shy7940 Місяць тому

    such a dumb fix, thanks bro !

  • @comedysketches5115
    @comedysketches5115 Місяць тому

    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

  • @Blessed2beU
    @Blessed2beU Місяць тому

    How do you open and close the function brackets/parenthesis?

  • @kurtfirestone2761
    @kurtfirestone2761 Місяць тому

    You made that so much harder than it needed to be

  • @6xub.
    @6xub. Місяць тому

    thats why ur the goat

  • @BrknSoul
    @BrknSoul Місяць тому

    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.

  • @bakenneabdullateef536
    @bakenneabdullateef536 Місяць тому

    Thanks bro

  • @hussein8645
    @hussein8645 Місяць тому

    Shortest and most beneficial video ever, thx

  • @Antonio---
    @Antonio--- Місяць тому

    I became so dizzy, glad to know it's likely just a senor causing the speed issue

  • @kanakkumar2
    @kanakkumar2 Місяць тому

    This doesn't work when my data is coming from data validation. If you can please help?

  • @itsffellie
    @itsffellie Місяць тому

    Genius! Thank you so much!

  • @HJ-gc7ub
    @HJ-gc7ub Місяць тому

    Thanks man!

  • @Shadnasiku
    @Shadnasiku Місяць тому

    How do I get my mod-t to work? I don't know the software I need to run it.

  • @mariechelle
    @mariechelle Місяць тому

    ❤❤❤❤❤

  • @mor5x
    @mor5x Місяць тому

    OMGGGGGGGGG you saved my work of 43 hours... Can't thank you enough 😭