How to select all blank cells in a range to keep unlocked in excel.

 Select Only the Blank Cells:

• Press Ctrl + G (or F5) to open the Go To dialog box.
• Click the Special... button at the bottom left.
• Select Blanks and click OK

How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order])

To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0)

If we want unique ranks, we can use the formula:

=RANK(C5,$C$5:C$10,0)+COUNTIF($C$5:C5,C5)-1

For ascending order, the formula would be:

=RANK.EQ(C5,$C$5:C$10,1)+COUNTIF($C$5:C5,C5)-1

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

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)))

Extract Domain from email in Excel or Google sheet

 =TEXTAFTER(A2, "@")

or,

=MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))

Generate emaill address using another column

 =IF(C2="",CONCATENATE(B2,"@","domain.com"),C2)