Recent content by Hughesy

  1. H

    Excel Help

    If there was a course that suites my needs I would.:cool: I can do all the nested if statements, lookups, pivots etc, its just this sumproduct function and Arrays i havent come accross before. Iv mastered them now though - quick learner. :D
  2. H

    Excel Help

    Top man! Thanks
  3. H

    Excel Help

    Im sure it is an CountIF or a sumIf but im after a more specific answer if possible. It as an array formula?
  4. H

    Excel Help

    Please can someone help. I have a list of numbers - i.e. 20 22 27 29 32 34 26 25 27 I now need a formula that will show me how many would be between 26-30. I know you can add a cutsom filter to do a count that way, but ideally I need it as a formula.
  5. H

    Excel - Nested IF statements Help needed

    The only problem is that im checking over 800 records at once, to get a count of how many are within that date. Does your example work for this? So for example if i have 01/04/07 - 08/04/07 02/04/07 - 02/05/07 01/04/07 - 12/04/07 01/04/07 - 03/04/07 will it count 02/04/07 - 4 times?
  6. H

    Excel - Nested IF statements Help needed

    Hi thanks for the reply. Ideally i want to be able to do a count of each on a seperate worksheet i have set up. My sheet is set up with all the dates for 01/04/07 - 31/03/08 i.e. 01/04/07 = 02/04/07 = 03/04/07 = 04/04/07 = What i wanted to do was then to simply put a formulae in that...
  7. H

    Excel - Nested Count IF statement help

    Im in need of an expert please?!? I am working on a spreadsheet and i need to know how many people where in a place on a particular day. I have two columns full of start and end dates for over 800 people. I need to work out on a set date (Say the 5th April), how many people where in on that...
  8. H

    Excel - Nested IF statements Help needed

    Hi all im new here and I need abit of help please. I am working on a spreadsheet and i need to know how many people where in a place on a particular day. I have two columns full of start and end dates for over 800 people. I need to work out on a set date (Say the 5th April), how many...
See more
Top Bottom
Community
Articles
Menu