nth occurence

  1. A

    Returning Nth day in a certain week each month

    Hi All, I have a sheet where i want to enter one row and it then automatically calculates all the dates below it. However the problem I have is that i want it to calculate every nth day in a certain month so not sure what the formula or code is. Eg I have the following table: <tbody> Start...
  2. D

    Trouble with identifying the Nth "-"

    Hey all, I'm translating a string characters: xzyxzyzxyy 8-22-60-5W6 zxyzxyyxzy zxyxzy 10-21-1-6 yxzyzyyxyzxyyzyxy yzxyxzyyxzyxzyxyzyx 6-20-111-5 yzx to: 08-22-060-05W6 10-21-001-06W6 06-20-111-05W6 And I was thinking of searching for the Nth "-" by using a FIND("-",A1,FIND("-",A1)+0) tied...
    • dark_rug
    • Thread
    • character standardization concatenate find text mid nth occurence
    • Replies: 5
    • Forum: Excel Questions
  3. B

    Modify a custom function

    hi, need help modifying this custom function. I need to find the nth occurrence of a word and when there isn't an nth occurrence for it to return no value. Right now this function will keep cycling through and delivering the same values. If there are 3 occurrences of the word "yes", when i ask...

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