Showing posts with label Excel Function. Show all posts
Showing posts with label Excel Function. Show all posts

Friday, December 20, 2024

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

Friday, December 13, 2024

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

Wednesday, October 2, 2024

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

Wednesday, May 1, 2024

SQL to delete all WooCommerce products except those with "draft" status

 -- Disable foreign key checks (important for InnoDB) SET     FOREIGN_KEY_CHECKS = 0;     -- Delete product meta DELETE     pm FROM     wp_p...