Search:

Type: Posts; User: Aryatect; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: how to best summarize this in a pivot table?

    It should work in compact form also, key was putting filter on postal code column.

    Glad could help and thanks for the feedback :)
  2. Re: how to best summarize this in a pivot table?

    Hi, top or bottom 10 or 2 in the example below (not percent) can be attained using filter on Postal Code for top or bottom 10 this will yield you below results.
    ...
  3. Replies
    5
    Views
    83

    Re: Count If with same keywords

    Glad could help and thanks for the feedback!
  4. Replies
    5
    Views
    83

    Re: Count If with same keywords

    Hi, Please try below:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  5. Replies
    5
    Views
    83

    Re: Count If with same keywords

    Hi, From the problem you described below should work:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  6. Replies
    3
    Views
    132

    Re: Auto selected based on DOB

    Changed a formula a little different, see if this works:

    =IFERROR(INDEX($A$2:$A$16,MATCH(IF(DATE(YEAR(E2),MONTH(E2),1) >=...
  7. Re: Trying to convert m/dd/yyyy to mm/dd/yyyy

    Hi, 2 ways:

    1. Go to Number Format and change to mm/dd/yyyy
    2. If number stored as text is ok then =TEXT(A1,"mm/dd/yyyy")
  8. Replies
    1
    Views
    78

    Re: Calculating percentages - error

    Hi, you are changing from 0 to 1 which means it as per your formula 1/0 which is infinite and not 100%. You can default it to 100% by =IFERROR(U3/V3-1,1) but you have to note that if it changes from...
  9. Replies
    7
    Views
    221

    Re: Average or occurrences help needed

    if the understanding from post #6 is correct then below should work (Showing only part of data):

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
  10. Replies
    7
    Views
    221

    Re: Average or occurrences help needed

    So in the example you gave, occurrences should be 4 right row 2 to row 15 - 1st , then row 26 - 2nd occurrence , then there is a gap of row 27 and hence row 28 - 3rd occurrence and row 31 to 48 is...
  11. Re: Help! Excel formula - Pulling from data to another sheet

    Hi, This is 1 option:

    Taking more details from https://www.mrexcel.com/forum/excel-questions/1107193-simple-formula-excel.html

    <b></b><table cellpadding="2.5px" rules="all"...
  12. Replies
    7
    Views
    221

    Re: Average or occurrences help needed

    Try below:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  13. Replies
    7
    Views
    221

    Re: Average or occurrences help needed

    Hi, Below should work if you data range header is in A1 & B1 and data starting in A2&B2:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  14. Replies
    3
    Views
    117

    Re: IDs Included in Another Table

    Glad could help and thanks for the feedback.
  15. Replies
    3
    Views
    117

    Re: IDs Included in Another Table

    Hi, See if this help:


    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
  16. Replies
    8
    Views
    284

    Re: Find Latest value that meets Criteria

    Glad we could help and thanks for the feedback !
  17. Re: pivot table field list keeps disappearing / fields dont appear in order

    Glad could help!
  18. Re: pivot table field list keeps disappearing / fields dont appear in order

    Hi, Think of it this way 1 worksheet can have multiple pivot tables which may or may not refer to the same source raw data, if field list would appear if you click anywhere and add any field how...
  19. Replies
    5
    Views
    163

    Re: Show 40 hours worked

    Glad we could help and thanks for the feedback!
  20. Replies
    8
    Views
    284

    Re: Find Latest value that meets Criteria

    Another option:

    =MAXIFS(B5:B10,A5:A10,C1,C5:C10,">"&0)
  21. Replies
    5
    Views
    163

    Re: Show 40 hours worked

    Hi, Welcome to the message board, your formula should check =(J5>=40/24,40/24,J5) as 40 hours are 1.66666 in numeric value. If you are looking for further assistance can you please post some sample...
  22. Replies
    8
    Views
    284

    Re: Find Latest value that meets Criteria

    Thanks Sam_D_Ben
  23. Replies
    7
    Views
    129

    Re: using dates with index matches

    Glad could help :)
  24. Replies
    8
    Views
    284

    Re: Find Latest value that meets Criteria

    Hi, Try Below:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  25. Replies
    7
    Views
    129

    Re: using dates with index matches

    In MATCH, you used C1:C3 which was end of month, I am using B1:B3 which is beginning of month. End of month will move the match back 1 row when match is less than 2nd row in this case hence 1 where...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4