Search:

Type: Posts; User: Graham C1600; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Formulas to count including Unique Numbers

    Hi M,

    Quick query which I cannot figure out.

    Everything is working fine however I've been asked to provide additional data now which I cannot get the formula to work for.

    So
    C$2:C$14<>""...
  2. Re: Formulas to count including Unique Numbers

    Thanks M worked a treat.
  3. Re: Formulas to count including Unique Numbers

    Hi M,

    Thanks for the reply.

    In my actual data there are numerous values in E2:E14. I just tried to keep it as simple as possible when I was getting all the formulas to work.

    Thanks
  4. Re: Formulas to count including Unique Numbers

    Hi M,

    How can I add another part to this formula so when it looks down E2:E14 it counts both Rel & AD ?

    Thanks
  5. Re: Formulas to count including Unique Numbers

    Hi M,

    All sorted, my error. Got it working.

    Thanks again.
  6. Re: Formulas to count including Unique Numbers

    Hi M,

    This isn't right.

    One of the earlier formulas was the following :-
    ...
  7. Re: Formulas to count including Unique Numbers

    Hi M,

    Tried it but it's not right.
    ...
  8. Re: Formulas to count including Unique Numbers

    Hi M,

    As you have done for one of my other formulas, can you assist with also getting these into a list instead of just a number ?

    Thanks
  9. Re: Formulas to count including Unique Numbers

    Thanks M, works a treat. Is there a way of extending this out so M2 shows "3", N2 shows "Steve". The more info i can get here the better for my situation.

    Thanks again.
  10. Re: Formulas to count including Unique Numbers

    M,

    Is it possible to tweak the above formula to provide a list instead of just a number ? So say I put the formula in M1 it would list in M1, M2 etc,, the results of the query ?

    Thanks
  11. Re: Formulas to count including Unique Numbers

    Thanks M these are working great. I've tried them on the full data set and get exactly what i need.
  12. Re: Formulas to count including Unique Numbers

    Thanks M, all working great.

    If i wanted to add another ask in the second regular formula to look down the Last Logon and then count all users, where would the additional C2:C15,<>"" go as i tried...
  13. Re: Formulas to count including Unique Numbers

    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody>

    <tbody>
    Next I would like to count the Unique User ID's based on the following criteria - Type="COL", Model=Rel",UTC="No". So in...
  14. Re: Formulas to count including Unique Numbers

    Hi M,

    Works a treat.
  15. Re: Formulas to count including Unique Numbers

    Hi M,

    Probably a bad example but he slight difference here is query 2 gave me a number of unique User ID's base on the criteria. This time i need to count all the user ID's that meet the criteria....
  16. Re: Formulas to count including Unique Numbers

    Thanks M works fine.

    Next puzzle.

    I need to count the total amount of User ID’s where there is no data in the Last Logon Field and the UTC=”No”. This count needs to be similar to the 2nd query...
  17. Re: Formulas to count including Unique Numbers

    Hi M,

    Bad wording from me.


    I need to count the total amount of User ID’s where there is data in their Last Logon box and the UTC =”No”.


    <colgroup><col></colgroup><tbody>
    Gary
  18. Re: Formulas to count including Unique Numbers

    Thanks M.


    4th
    query. I need to count the total amount of User ID’s where at least 1 person has data in their Last Logon box and the UTC =”No”.

    This one now. The answer should be 5.
    ...
  19. Re: Formulas to count including Unique Numbers

    Hi M,

    This formula works when I do it small scale on the test data I use. When I try to expand it out onto the real data I just get an N/A in the cell. The formula I'm trying to use is as follows...
  20. Re: Formulas to count including Unique Numbers

    Hi M,

    Thanks again for correcting me. Yes yo are correct. It would be 6 because as you say Brian should have been counted.
  21. Re: Formulas to count including Unique Numbers

    Thanks again M, works fine.
  22. Re: Formulas to count including Unique Numbers

    Thanks M. Works a treat.
  23. Re: Formulas to count including Unique Numbers

    Hi Marcelo,

    As for Dante, thanks for support so far.

    Thanks for pointing out that the answer should be 4 and not 3. I looked at the wrong table when i worked out the answer.

    Thanks
  24. Re: Formulas to count including Unique Numbers

    Hi Dante,

    Apologies, will go and do that now.

    I appreciate all the help that was given.

    Thanks
  25. Formulas to count including Unique Numbers

    Hi,

    I've tried this before but ended up going around in circles because i was not asking the right questions. Hopefully the below will clear all this up.


    <colgroup><col><col><col><col...
Results 1 to 25 of 54
Page 1 of 3 1 2 3