Adding Timestamp upon Cell Modification | Excel

Enabling a Timestamp in Excel Upon Cell Modification without Overwriting Existing Timestamps

To achieve this, follow these steps:

Step 1: Enable Iteration in Excel Options

Navigate to Options -> Formula -> Iteration and ensure the option is enabled.

Step 2: Adding Timestamps to Column B on Change in Column C

Suppose your values are in Column C, and you want to track timestamps in Column B. Apply the following formula in Column B:

=IF(C2<>"", IF(B2="", CONCAT(MINUTE(NOW()), ":", SECOND(NOW())), B2), "")

This formula will only update the timestamp in Column B if a change is made in the corresponding cell of Column C, ensuring it doesn't overwrite existing timestamps.

A Guide to Installing and Configuring SSH Tunneling | Windows

Introduction:

Secure communication and data protection are paramount in today's digital landscape. One effective way to ensure this is through the use of SSH tunneling. In this guide, we'll walk you through the process of installing, setting up, and utilizing SSH tunneling on a Windows operating system. This technique will provide you with a secure and encrypted channel for your data transmission needs.

Step 1: Install OpenSSH as a Windows Optional Feature

1. Begin by installing OpenSSH as an optional feature on your Windows machine.
2. Windows will automatically create a new firewall rule to permit inbound SSH access over port 22.

Note that, if you manually download and install OpenSSH, you'll need to create an inbound rule to allow SSH port access.

Step 2: Start and Enable the SSH Service

1. Open PowerShell as an administrator

2. Start the SSH service using the following command 

Start-Service ssh

How to Download Videos Shared on Microsoft SharePoint and 365 | Microsoft

Is it possible to download a video shared over Microsoft SharePoint or 365 when we can watch it but are unable to download it?

Introduction:

Have you ever encountered a situation where you're able to watch a video shared on Microsoft SharePoint or 365, but you can't seem to find a way to download it? In this guide, we'll walk you through a simple solution that empowers you to download these videos using the versatile media converter, ffmpeg.

Solution: Using FFmpeg Video Converter

FFmpeg is a powerful and universal media converter that can handle a wide range of media tasks, including converting and transcoding videos. Follow these steps to download videos that you can watch but can't download directly from Microsoft SharePoint or 365:

ffmpeg is a universal media converter. It can read a wide variety of inputs - including live grabbing/recording devices - filter, and transcode them into a plethora of output formats.

Search and Replace function DB2 SQL

A function to replace all occurrences of a string in a source string with a new string.

• Using Db2 REPLACE() function with literal string example

REPLACE(source_string, search_string, replace_string )

SELECT 

    REPLACE('IBM DB2','DB2','Db2') result

FROM 

    sysibm.sysdummy1;

RESULT :  IBM Db2 

Excel Formulas FILTER, SEQUENCE, TEXTJOIN, TRANSPOSE | Excel

 

Filter using the formula, instead of lookup.

=FILTER(OUTPUT, CONDITION)

EXAMPLE: 

FILTER(A1:A10, B1:B10=C1)

OUTPUT WILL BE SPILLED DOWN. 

TRANSPOSE to spill this output in columns, instead of down in the rows.

=TRANSPOSE( FILTER(OUTPUT, CONDITION) )

EXAMPLE: 

=TRANSPOSE( FILTER(A1:A10, B1:B10=C1) )

TEXTJOIN for a spill in one cell with a separator like a comma.

=TEXTJOIN(",", FILTER(OUTPUT, CONDITION) )

EXAMPLE: 

=TEXTJOIN(",", FILTER(A1:A10, B1:B10=C1) )

SEQUENCE:

to have a list of numbers 

=SEQUENCE(row, column, start, interval)

example: 

1 row and 10 columns, left to right

=SEQUENCE(1,10)

1 column and ten rows, top to down, 

=SEQUENCE(10,1)

1 column and ten rows, top to down, starting from 5 and the interval is 2

=SEQUENCE(10,1, 5,2)

To extract data for the last month (day 1st to day 30th) from a database in DB2 || IBM DB2

To extract data for the last month (day 1st to day 30th) from a database in DB2, 

Use the below condition in WHERE clause :

TRANSDATE >= THIS_MONTH(CURRENT DATE - 1 MONTH)

AND TRANSDATE < THIS_MONTH(CURRENT DATE)

Umar Adil