ordinal

  1. charlesstricklin

    Add ordinal to date

    I'm stumped. I have a column B which has dates in the format "Wednesday, March 15, 2023". I'd like the cells in column C to show a date like that as "Wednesday, March 15th, 2023"
  2. Jaafar Tribak

    DLL Export Viewer ( VBA Based )

    Spurred by the question asked recently by @audeser in this post, I took a deeper look and I arrived at the following little project which, as the title of the current thread suggests, it allows you to list all the functions exported by standard windows DLLs . This little vba project mimics to a...
  3. masud8956

    Adding st, nd, rd, th to ranked values

    Hi everyone! I am using the following formula to rank 20 rows of entries at S5:S24. =IF(ISNUMBER(R5),1+COUNTIF($R$5:$R$24,">"&R5),"") What modification do I need to get the texts st, nd, rd, th as ordinal suffix? Regards
  4. M

    Make Second Sheet from left Activesheet (ordinal position #2)

    Hi, I do not know if this is super easy or challenging, but I am trying in set my active worksheet to be the second sheet from the left. When my workbook opens, a form prompts you for a username/password which allows certain sheets to become visible depending on what you put in. I want to...
  5. L

    Save File with ordinal date (1st, 2nd, 3rd) Name

    Hello all, I've been trying everything and searching without luck. I'm trying to save a file with an Ordinal date (1st, 2nd, 3rd). I need the name to look like Summary June 10th to June 16th. The code I have so far is: ActiveWorkbook.SaveAs ("C:\Users\Laura" _ &...
  6. V

    COUNTIF help, or is there a better alternative?

    Hi everyone, needing help with my project. I need to count the ordinal number (1st, 2nd, 3rd, etc) of an entry in a given list. For example: <tbody> A B 1 Smith, John 1 2 Doe, Jane 1 3 Smith, John 2 4 Parker, Peter 1 5 Parker, Peter 2 6 Doe, Jane 2 7 Parker, Peter 3 8 Smith...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top