Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    22
    Views
    479

    hi Rory, allow me to say, that was a...

    hi Rory,

    allow me to say, that was a remarkable formula.
  2. Replies
    22
    Views
    479

    thank you zeddy, ";" instaede of "," in the...

    thank you zeddy,

    ";" instaede of "," in the formula was the tricky part.
  3. Replies
    22
    Views
    479

    Please find the attachment.48139

    Please find the attachment.48139
  4. Replies
    22
    Views
    479

    Hi Paul and my sincer appology for late reply. ...

    Hi Paul and my sincer appology for late reply.

    i did that but still keep getting the pop window indicated in my previous reply.
  5. Replies
    22
    Views
    479

    My sincer appolgy for late reply Rory, still...

    My sincer appolgy for late reply Rory,

    still getting the pop window as i indicatae in my previous reply.
  6. Replies
    22
    Views
    479

    Hi Rory, i tried the formula but i keep getting...

    Hi Rory,
    i tried the formula but i keep getting an excel pop window with highlight of the 3,offset part of the formula.
    As for your question, it should count 1 in B and 0 in C.
  7. Replies
    22
    Views
    479

    Thank you so much Maud, i did not try the...

    Thank you so much Maud,

    i did not try the code (UDF) but the formula with helper column and COUNTIFS works prefectly.
  8. Replies
    22
    Views
    479

    hi Martin, i have included a sample workbook.

    hi Martin,
    i have included a sample workbook.
  9. Replies
    22
    Views
    479

    hi Maudibe building on your image and...

    hi Maudibe
    building on your image and considering that B:E represent headings, then staring from left to right D&E should show a zero count since for D there are values exist across the rows ddd...
  10. Replies
    22
    Views
    479

    Counting Formula

    greetings,

    I want do the counting under each column and consider only cell value(s) that solely appear in that column only. Something similar to the below Metrics.

    A B C D E
    AAA 1 ...
  11. Thread: formula help

    by dubdub
    Replies
    6
    Views
    180

    Perfect, thank you so much Rory.

    Perfect, thank you so much Rory.
  12. Thread: formula help

    by dubdub
    Replies
    6
    Views
    180

    yes they are.

    yes they are.
  13. Thread: formula help

    by dubdub
    Replies
    6
    Views
    180

    formula help

    greetings,

    Assume I have data in columns a,b as below and I want a formula to help me assign a sequence number to only the first four for each code as in column c, appreciate any idea.
    ...
  14. Replies
    4
    Views
    1,205

    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...
  15. Replies
    4
    Views
    1,205

    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...
  16. 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.
  17. 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...
  18. 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...
  19. greetings, i am still waiting for...

    greetings,
    i am still waiting for suggestions.....
  20. 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.
  21. Thread: Format help

    by dubdub
    Replies
    4
    Views
    303

    Great thanks Kweaver for the help.

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

    by dubdub
    Replies
    4
    Views
    303

    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...
  23. Thread: Format help

    by dubdub
    Replies
    4
    Views
    303

    Format help

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

    by dubdub
    Replies
    14
    Views
    1,872

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

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

    by dubdub
    Replies
    14
    Views
    1,872

    attached, applying your formula and Maudib...

    attached, applying your formula and Maudib version.
Results 1 to 25 of 397
Page 1 of 16 1 2 3 4