Search:

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

Page 1 of 15 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    269

    Great Thanks Rory, and thanks as well to Maudibe...

    Great Thanks Rory, and thanks as well to Maudibe for the help.
  2. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    269

    attached, applying your formula and Maudib...

    attached, applying your formula and Maudib version.
  3. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    269

    hi rory, I set three "comp" status for the...

    hi rory,

    I set three "comp" status for the last code and the formula assigned 1 where it suppose not. Any guidance how to make it not to....
  4. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    269

    Formula help

    greetings,
    i have included data sample and formula description in the attachment.
  5. Replies
    0
    Views
    60

    Pivot Table bulit used formula

    Greetings,

    Is there a way to transfer a pivot table summary layout into a separate sheet with fields’ values associated with the formula used to generate them. I am not referring to the formula...
  6. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    It does, and thank you very much.

    It does, and thank you very much.
  7. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Happy Holidays Rory, I entered the formula...

    Happy Holidays Rory,

    I entered the formula and it gives zero all the way.

    To add to your previous question, after verifying a match of secondary name in both REAL & HOPE, then sum the counts...
  8. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    yes sir.

    yes sir.
  9. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    My mistake, what i need is the counts of...

    My mistake, what i need is the counts of "secondary" matches between "HOPE"&"REAL" at year,general,specific & branch values.
  10. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Hi Rory, i tested the formula with the sample...

    Hi Rory,

    i tested the formula with the sample data, the calculation highlighted in red in the attachment at 2017 & 2018 shows a value of 1 when it suppose to output 2.
  11. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    sample of the data is included in the attachment.

    sample of the data is included in the attachment.
  12. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Great thanks Rory, unfortunately, the appearance...

    Great thanks Rory, unfortunately, the appearance is more than once in each and asymmetric; are you indicating formula will be hard to develop under such situation.
  13. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Hi Zeddy, and sorry for my late reply. The "...

    Hi Zeddy, and sorry for my late reply. The " REAL" counts is not what i am after, i have included more explanation in my reply to RetiredGeek, i hope it is more clear.
  14. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    hi Paul, and sorry for my late reply. I have...

    hi Paul, and sorry for my late reply. I have included an attachment.
  15. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Thank you RetiredGeek for your reply, i have...

    Thank you RetiredGeek for your reply, i have included definition and example of "REAL" count that I need in the attachment.
  16. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    851

    Formula Help

    Greetings,

    I won do counting for two items, hope and real using mutiple criteria. The hope is a straight one(countifs), the real one i need help to introduce aditional criteria which is do...
  17. Replies
    4
    Views
    232

    Great Great Thanks Maudibe.

    Great Great Thanks Maudibe.
  18. Replies
    4
    Views
    232

    My appology, the previous file is not the...

    My appology, the previous file is not the one,please consider this one
  19. Replies
    4
    Views
    232

    icon conditional formating - Excel 2010

    Greetings,
    I need help to apply icon style format beside cell value based on the following conditions:
    If cell value = 0 then no format
    If =100 then green icon
    If <100 then red icon
    If >100 then...
  20. Replies
    9
    Views
    339

    Splendid solutions, right on the money Maudibe.

    Splendid solutions, right on the money Maudibe.
  21. Replies
    9
    Views
    339

    Great thanks to you Maudibe & Paul, and i am...

    Great thanks to you Maudibe & Paul,
    and i am sorry i did not provide enough information in my first post. i have a list with repetitive names in column "b" and i want to assign an order number to...
  22. Replies
    9
    Views
    339

    Add order number

    Greetings,

    i need help with a formula that can output a data order number as shown below.

    order
    num data
    1 sam
    2 ram
    ram
    3 lam
  23. Replies
    5
    Views
    909

    Many Thanks Eric, wonderful, is there a way to...

    Many Thanks Eric,
    wonderful, is there a way to include the headings under which the highlighted code exist, also is there a way to include multiple codes using this procedure.
  24. Replies
    5
    Views
    909

    Extracting paragraphs

    Greetings,
    I have a 100 page document. The paragraphs in the document ends with codes like “SAM”, “GAMD”, ”BD&WT” in brackets “()”. What I need is a code that enables me to do extract based on...
  25. Thread: formula help

    by dubdub
    Replies
    3
    Views
    328

    As always perfect. Great thanks Steve.

    As always perfect. Great thanks Steve.
Results 1 to 25 of 374
Page 1 of 15 1 2 3 4