by year

  1. N

    Get value from December given year

    Hello, This is my first attempt at Xl2bb. Could you please help me with a formula that can get value only from December month from year given ? Need to calculate year-end balance which is in each year December month. But value can be YYYY format only in L3 column. For example, in Q3 result...
  2. E

    Finding the Top 5 of text filled column by the different Years in the data!

    I would like help solving this problem, Finding the Top 5 of text filled column by the different Years in the data. I have a set of data in one sheet that covers 3 Fiscal years FY15, FY16 and FY17 (Column named "Open_FY") and sub categories of issues (named SubCat) this are workplace issues...
  3. R

    Sort date column by year Excel vba

    Folks: How can I sort a date column by year without creating a parallel, offset column that holds the formula like Year(rcell.value)? like: 'Sort 'change sort keys to year(column 3.value), column 1, column 3 sheet1.UsedRange.Offset(6, 0).Sort _ key1:=Sheet1.UsedRange.>>Year of...

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