Facebook-f Youtube Envelope Phone

Author: andy fox

Create Rank Number-Words (i.e. 1st, 5th, etc) in Excel

1st, 2nd and 3rd Place ribbon rosettes

Was working on a Foxco data project recently where i needed to take dates that were ranked, add a value and then add the proper suffix to them as a number-word (i.e. the 1/1/2025 is the 1st day of the year) and 1/9/2025 is the 9th (not the 9st) day of the year. How this formula works, in simple terms (detailed explanation at the bottom). In my case, M2 was the cell reference contains the number I wanted to convert. The formula handles the special cases for 11th, 12th, and 13th (which use “th” instead of “st”, “nd”, “rd”) For all other numbers, it looks at the last digit to determine the suffix. Examples: 1 → 1st2 → 2nd3 → 3rd4 → 4th11 → 11th (not 11st)21 → 21st22 → 22nd23 → 23rd101 → 101st111 → 111th (not 111st) Here’s an alternative version that uses A1 and different but equally sound logic. Excel Ordinal Formula Breakdown (Nested IF Version) The Formula: excel=M2&IF(OR(MOD(M2,100)=11,MOD(M2,100)=12,MOD(M2,100)=13),”th”,IF(MOD(M2,10)=1,”st”,IF(MOD(M2,10)=2,”nd”,IF(MOD(M2,10)=3,”rd”,”th”)))) Step-by-Step Explanation: 1. M2& 2. MOD(M2,100) 3. OR(MOD(M2,100)=11, MOD(M2,100)=12, MOD(M2,100)=13) 4. First IF Statement: excelIF(OR condition, “th”, [nested IFs]) 5. MOD(M2,10) 6. The Nested IF Chain: excelIF(MOD(M2,10)=1,”st”, IF(MOD(M2,10)=2,”nd”, IF(MOD(M2,10)=3,”rd”,”th”))) This creates a decision tree: Visual Decision Flow: Examples: NumberLast 2 digitsSpecial case?Last digitSuffixResult11No1st1st22No2nd2nd33No3rd3rd44No4th4th1111Yes-th11th1212Yes-th12th1313Yes-th13th2121No1st21st2222No2nd22nd2323No3rd23rd11111Yes-th111th Key Differences from CHOOSE Version: Both formulas accomplish the same result, but the first version is more straightforward in its logic flow.

WordPress Random Post / Page / Product Link Plugin

image 4

If you want to create a link that will magically whisk visitors away to a completely randomized Post, Page or WooCommerce product this plugin may be what you’re looking for. In the admin settings you can change the url to be whatever you’d like it to be, here on Foxco.net it’s /random/ (give it a whirl). Click here to download it. Key Features: How to Use: Admin Features: Usage Examples: The plugin uses WordPress’s built-in rewrite rules and handles all the technical aspects like proper redirects, security, and database queries efficiently. Ready to use immediately after activation. Leave a comment with your feedback.

foxco is a STEALTH microagency for tech, web, marketing, sales channels, consulting, eCommerce, and big data. Where 65% of technology projects fail we plug in sharp, stealth, simple and fast– and never miss.