Prevent duplicate entry in excel.

On the Settings tab, choose "Custom" from the Allow drop down list and enter =COUNTIF($D:$D,D2)=1 into the Formula box

Upload file to server using Power Shell Command

 scp file_name.zip username@server_ip/server_address:/directory_path

Office 2021 Activation using command

 @echo off

title Activate Microsoft Office 2021 (ALL versions) for FREE - office.com&cls&echo =====================================================================================&echo #Project: Activating Microsoft software products for FREE without additional software&echo =====================================================================================&echo.&echo #Supported products:&echo - Microsoft Office Standard 2021&echo - Microsoft Office Professional Plus 2021&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\ProPlus2021VL_KMS*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo =====================================================================================&echo Activating your product...&cscript //nologo slmgr.vbs /ckms >nul&cscript //nologo ospp.vbs /setprt:1688 >nul&cscript //nologo ospp.vbs /unpkey:6F7TH >nul&set i=1&cscript //nologo ospp.vbs /inpkey:FXYTK-NJJ8C-GB6DW-3DYQT-6F7TH >nul||goto notsupported
:skms
if %i% GTR 10 goto busy
if %i% EQU 1 set KMS=kms7.office.com
if %i% EQU 2 set KMS=e8.us.to
if %i% EQU 3 set KMS=e9.us.to
if %i% GTR 3 goto ato
cscript //nologo ospp.vbs /sethst:%KMS% >nul
:ato
echo =====================================================================================&echo.&echo.&cscript //nologo ospp.vbs /act | find /i "successful" && (echo.&echo =====================================================================================&echo.&echo #Please consider supporting this project: donate to my paypal "devomman@gmail" &echo #Your support is helping me keep my servers running 24/7!&echo.&echo =====================================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one... & echo Please wait... & echo. & echo. & set /a i+=1 & goto skms)
explorer "https://www.office.com/"&goto halt
:notsupported
echo =====================================================================================&echo.&echo Sorry, your version is not supported.&echo.&goto halt
:busy
echo =====================================================================================&echo.&echo Sorry, the server is busy and can't respond to your request. Please try again.&echo.
:halt
pause >nul

Create an admin account in WordPress via MySQL

INSERT INTO `wp_users`(

    `user_login`,

    `user_pass`,

    `user_nicename`,

    `user_email`,

    `user_status`

)

VALUES(

    'admin999',

    MD5('password999'),

    'firstname lastname',

    'email@example.com',

    '0'

);

INSERT INTO `wp_usermeta`(

    `umeta_id`,

    `user_id`,

    `meta_key`,

    `meta_value`

)

VALUES(

    NULL,

    (

SELECT

    MAX(id)

FROM

    wp_users

),

'wp_capabilities',

'a:1:{s:13:"administrator";s:1:"1";}'

);

INSERT INTO `wp_usermeta`(

    `umeta_id`,

    `user_id`,

    `meta_key`,

    `meta_value`

)

VALUES(

    NULL,

    (

SELECT

    MAX(id)

FROM

    wp_users

),

'wp_user_level',

'10'

);

Contatenate text to Date to Sort

Convert 01.01.2024  to 01/01/2024 to count as date in Excel.

 =DATE(RIGHT(A2,4),MID(A2,FIND(".",A2,1)+1,FIND(".",A2,FIND(".",A2,1)+1)-FIND(".",A2,1)-1),MID(A2,1,FIND(".",A2,1)))

How to install Plesk on Ubuntu 22.00 using a single command

 # sh <(curl https://autoinstall.plesk.com/one-click-installer || wget -O - https://autoinstall.plesk.com/one-click-installer)

Toshiba e studio 2829a print using lan cable without router

 To set up a Toshiba e-STUDIO 2829A printer to print using a LAN cable without a router, you'll need to directly connect the printer to your computer with an Ethernet cable and configure both devices to communicate with each other. Here's how you can do it:

1. Connect the Printer to the Computer:

   • Plug one end of the Ethernet cable into the LAN port of the Toshiba e-STUDIO 2829A.
   • Plug the other end of the Ethernet cable into the Ethernet port of your computer.

2. Set Static IP Addresses:

   • Since there is no router to assign IP addresses dynamically, you need to set static IP addresses for both the printer and the computer.

3. Configure the Printer’s IP Address:

   • Access the printer’s control panel.
   • Navigate to the network settings (this can usually be found under Admin or System settings).
   • Set a static IP address for the printer. For example, you might use 192.168.0.10.
   • Ensure the subnet mask is set to 255.255.255.0.
   • Save the settings.

4. Configure the Computer’s IP Address:

   • On your computer, go to the network settings.
     • Windows:
       1. Open Control Panel.
       2. Go to Network and Sharing Center.
       3. Click on Change adapter settings.
       4. Right-click on the Ethernet adapter connected to the printer and select Properties.
       5. Select Internet Protocol Version 4 (TCP/IPv4) and click Properties.
       6. Choose "Use the following IP address" and set the IP address to 192.168.0.20 (it should be different from the printer’s IP).
       7. Set the subnet mask to 255.255.255.0.
       8. Leave the Default Gateway and DNS fields blank.
       9. Click OK to save the settings.
     • Mac:
       1. Open System Preferences.
       2. Go to Network.
       3. Select Ethernet and click on Advanced.
       4. Go to the TCP/IP tab.
       5. Set Configure IPv4 to Manually.
       6. Enter 192.168.0.20 for the IP address and 255.255.255.0 for the subnet mask.
       7. Leave the Router field blank.
       8. Click OK and Apply to save the settings.

5. Add the Printer on the Computer:

   • Now, you need to add the printer on your computer.
     • Windows:
       1. Go to Control Panel.
       2. Select Devices and Printers.
       3. Click on Add a printer.
       4. Choose "Add a local printer or network printer with manual settings".
       5. Select "Create a new port" and choose Standard TCP/IP Port.
       6. Enter the printer’s IP address (192.168.0.10).
       7. Follow the prompts to install the printer driver (you may need the printer driver software from Toshiba's website).
     • Mac:
       1. Open System Preferences.
       2. Go to Printers & Scanners.
       3. Click the plus (+) button to add a printer.
       4. Select the IP tab.
       5. Enter the printer’s IP address (192.168.0.10).
       6. Choose the appropriate protocol (typically HP Jetdirect - Socket).
       7. Enter a name for the printer and select the appropriate driver.
       8. Click Add.

After completing these steps, your Toshiba e-STUDIO 2829A printer should be set up to print using a LAN cable directly connected to your computer without a router