traditional

  1. M

    treating dates as dates in pivot table

    https://snag.gy/QFOWNd.jpg Here I have a date column which is a date format in power query. There are no nulls or non date values. How do i filter this with the traditional date hierarchy or the option to select all dates after a date. It's random when excel deigns the data unworthy of...
  2. N

    Delimit from right to left?

    Is there any way we can delimit a string from right to left rather than the traditional left to right operation? Please refer to this file for clarification: https://docs.google.com/spreadsheets/d/1iOeH9SDd4WgIsM2fR5FM09wsrjw_ClsdcOicxK6xT-o/edit?usp=sharing Thanks!
  3. A

    Get the contents of column A and put it in Column B overwiting a tag

    I am working with just 2 columns. I am writing a macro to get the value from column A and put it in column B, overwriting the tag style, so that row 1 appears like the following: The Regency Straight Back is a traditional ....., and do this for all rows Column A...
  4. BrianGGG

    Can't spill with SUM

    Hello. I'm failing at using Dynamic Arrays to completely solve my problem. A brief description: I have a table of items, and I would like to list each letter of the alphabet along with a count of the number of items that start with that letter. Here is a sample table that I have called...
  5. D

    Vlookup FORMULA

    Hi, I'm looking for a formula to do the following: Formula C22: Lookup Employee number VLookup - T_LOOKP,if match Lookup Age, if < 50 go to Admin and get maximium contributionamount else > 50 maximium. vlookupemployee find Traditional - calc methods and determine ifit is gross pay or...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top