• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Mike86

  1. Mike86

    Array formula for sorted & filtered results

    I added a column to your table that displays the row number when valid. Column G displays the list of valid row numbers. Column H and I are the associated dates and values.
  2. Mike86

    Help Please!! how to make this type of analysis?

    Don't forget weight and size of the package. Lots of difference shipping a metric ton versus a pound or a pallet versus a small box.
  3. Mike86

    Not able to create this chart

    Not perfect, but this is close.
  4. Mike86

    How to repeat a formula every X rows

    @ad.dias @SirJB7 Damn. OK, round did a funny thing around Noon on each day. Was trying to get away from doing the Date statement. Shows what corner cutting gets you. Updated sheet attached.
  5. Mike86

    Count records that don’t exist by dates but are inferred by status

    @MediumLebowski It's identifying every person in the A28:E30 table that have start dates before and end dates after the year-quarter in h5:h16. If a person started in or before that quarter, and were discharged after or during that quarter, they're counted. Getting this function to work was...
  6. Mike86

    Count records that don’t exist by dates but are inferred by status

    @MediumLebowski Yes, that's a pain. OK, fixed.
  7. Mike86

    How to repeat a formula every X rows

    Brute force, but here's a way to do it. You don't always have the same number of data points per day, so using the average if and adding a Date column seemed a simple way to do it.
  8. Mike86

    Count records that don’t exist by dates but are inferred by status

    @MediumLebowski I took a shot at this, but was getting some different counts than yours. To get it to work without being a pain, I needed to reformat your Corp Fiscal Qtr column to show the years first. Cells D28:E30 have the min/max Assess Dates converted to quarter format. Here's an issue...
  9. Mike86

    Putting length of service into age brackets

    @Brooksy1 Sorry for the response delay, I don't check here every day. Without getting too messy, the attached file seems to do what you want. Hiding Col J will make it look cleaner.
  10. Mike86

    Putting length of service into age brackets

    Another look at a solution. I've added a name selection and some other things. You can change the age ranges by altering the yellow values. You also need to make sure the ages match for the start/stop of the different blocks. Otherwise, you lose years in those gaps.
  11. Mike86

    Creating monthly, quarterly and annual analysis

    If you check back, the quarter issue is resolved.
  12. Mike86

    Creating monthly, quarterly and annual analysis

    This may be doing what you want, but I'm not 100% sure. If this isn't what you want, a few more examples of the desired output would be helpful.
  13. Mike86

    InTake Form

    There's the basic data form provided with Excel. It's not very elaborate, but it's easy to activate and works well with simple tables: https://support.office.com/en-us/article/Add-edit-find-and-delete-rows-by-using-a-data-form-17bca0a4-3ba5-444a-983c-a8ce70609374
  14. Mike86

    using index/match to find the intersection of 2 variables - not working

    See Bosco's comment in #4. By changing the headers to text (ie using ">", "-", or "<" in the header) you stopped the Match function from operating. I'd recommend using 0, 5, 10, 15, 20, and 100 for the headers. The function works with that. If you must do the headers as you have them above, use...
  15. Mike86

    using index/match to find the intersection of 2 variables - not working

    Check the value in B1. It displays 0.5%, which would put you in the 0% column. When 5 is entered in B1, the rate is displayed as $1.70
Back
Top