Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    645

    Great thanks Maud for your help, I think, my...

    Great thanks Maud for your help, I think, my first post does not detail the uniqueness part enough, which intended not to consider the count of any repetitive name in col A for the same month more...
  2. Replies
    4
    Views
    645

    Need formula help

    Greetings everyone,
    I want to do unique counts of col "a" for each month (a20:a31) using date1 and date2 columns and based on b14:b18 criteria. For example as depicted in the attachment for the...
  3. Perfectly done dear Zeddy, I will give it a try...

    Perfectly done dear Zeddy,
    I will give it a try with the real things, and i need your patinet if somthing pop up.
  4. First, my apology for late reply, Secondly,...

    First, my apology for late reply,

    Secondly, attached is the template I have with no values. The excel version is 2010. The values will be extracted from the cell and populated under its...
  5. Copy and paste cell value based on fill color

    hi all,

    Is there a way to copy and paste cells values based on cell fill color.
    Say i have a range A1:Y300, the cells are either single or merged. The range has variety of fill color.
    I want...
  6. greetings, i am still waiting for...

    greetings,
    i am still waiting for suggestions.....
  7. Automate message move based on subject to a computer folder/file

    I hope all are in a good health,
    My question, how can I automate the move of an arrived outlook message based on the subject to a specific computer folder address/location.
  8. Thread: Format help

    by dubdub
    Replies
    4
    Views
    200

    Great thanks Kweaver for the help.

    Great thanks Kweaver for the help.
  9. Thread: Format help

    by dubdub
    Replies
    4
    Views
    200

    thank you Kweaver for your quick response, but...

    thank you Kweaver for your quick response, but the format should be based on the difference between 2015 and 2014. for example for JAN the 2015 value is 2% while 2014 value is 12% the delta of...
  10. Thread: Format help

    by dubdub
    Replies
    4
    Views
    200

    Format help

    hi all,
    i need help to get the format as per the conditions specified in the attached file.
  11. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    691

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

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

    by dubdub
    Replies
    14
    Views
    691

    attached, applying your formula and Maudib...

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

    by dubdub
    Replies
    14
    Views
    691

    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....
  14. Thread: Formula help

    by dubdub
    Replies
    14
    Views
    691

    Formula help

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

    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...
  16. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    It does, and thank you very much.

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

    by dubdub
    Replies
    28
    Views
    1,597

    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...
  18. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    yes sir.

    yes sir.
  19. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    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.
  20. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    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.
  21. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    sample of the data is included in the attachment.

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

    by dubdub
    Replies
    28
    Views
    1,597

    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.
  23. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

    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.
  24. Thread: Formula Help

    by dubdub
    Replies
    28
    Views
    1,597

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

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

    by dubdub
    Replies
    28
    Views
    1,597

    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.
Results 1 to 25 of 384
Page 1 of 16 1 2 3 4