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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top