Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Help to correct SIP date optimizer data analytics

    I finally managed to crack this. Unable to figure out how to delete the thread.
  2. Help to correct SIP date optimizer data analytics

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Reaching out to seek help from experts to correct one of the SIP date...
  3. Re: Experts help required to shorten and concise VBA macro

    Thanks a lot Peter for suggestion.

    I made changes to these two sections more or less in line with your recommendation.

    Appreciate the help :)
  4. Re: Experts help required to shorten and concise VBA macro

    Hi Caleeco,

    Ignore the earlier code. I was able to cut it further down to this below code. Please have a look at it and suggest improvement.



    'Individual Portfolio returns
    ''Copy and...
  5. Re: Experts help required to shorten and concise VBA macro

    Hi Caleeco,

    First all thanks a ton for taking time out to read such a long code.

    Picked up some very useful tips from your explanation. These would really help me for not only keeping this...
  6. Experts help required to shorten and concise VBA macro

    Hi Experts,

    I have written a VBA macro to compute returns of my different investment portfolio, which works perfectly fine and serves my purpose pretty well. But my VBA skills are at a very very...
  7. Replies
    17
    Views
    2,870

    Re: SUMIF Of Multiple Values

    Thanks for the post. I used it and helped me
  8. Replies
    4
    Views
    172

    Re: Question about Sum of cells

    You can try some external website to upload the file and provide the link here
  9. Replies
    1
    Views
    184

    Re: adding colored cells in excel 2007

    See if this is what you are looking for
    Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function - YouTube


    OR may be this

    Count Cells Based On Background Color
  10. Re: How to compare values in two columns in an excel sheet and populate a value in another column

    This should surely work for you.

    Formula in Column C =IF(AND(A2="NEW",B2="RAHUL"),1,0)
    Formula in Column D =IF(AND(A2="PROGRESS",B2="RAHUL"),1,0)
    Formula in Column E...
  11. Thread: Duplicates

    by norulen
    Replies
    22
    Views
    2,122

    Re: Duplicates

    :) :) Glad that i could contribute :)
    But would suggest you to post the solution which worked for the best for other people's benefit who might be searching for this thread in the future
  12. Replies
    4
    Views
    172

    Re: Question about Sum of cells

    Would like to see sample input and output data to understand your exact requirement before suggesting you anything
  13. Replies
    33
    Views
    1,451

    Re: vlookup laste 6 digit.

    I just realized i am mistaken here. Wildcard Character can only be used for text and not numbers
  14. Replies
    33
    Views
    1,451

    Re: vlookup laste 6 digit.

    May be if you post small sample of your input and output requirement i might be able to help you out with your second requirement
  15. Replies
    33
    Views
    1,451

    Re: vlookup laste 6 digit.

    You can even use Vlookup function with wildcard character
    for example in vlookup value try this "*" & Cell reference for the value you want to look for
  16. Re: Working days between first and last column with data

    NETWORKDAYS - Excel - Office.com
  17. Re: Working days between first and last column with data

    Excuse me!! i dint get you? Does this formula not work for you?
  18. Re: Working days between first and last column with data

    Try this formula
    =NETWORKDAYS(A1,B1)
  19. Replies
    9
    Views
    2,306

    Re: Shortening list in Excel

    Thanks a lot Micheal and Shg i ll have a look at these links and let you know if i am able to get it working :)
    Thanks again guys :)
  20. Replies
    9
    Views
    2,306

    Re: Shortening list in Excel

    Ha ha..but valko I am already using an ActiveX combo box and i already have autocomplete properties set. But what i am looking for is something which will reduce the dropdown list only to the words i...
  21. Replies
    9
    Views
    2,306

    Re: Shortening list in Excel

    do you mind sharing it? I have also been looking for something like that but was unable to get it working through the link provided.
    I am already using a Combo box in a userform and i want the...
  22. Replies
    5
    Views
    229

    Re: Problem with MID function

    Try this
    =IF(LEFT(A1,1)*1>3,"OK","Not OK")
    or
    =IF(MID(A1,1,1)*1>3,"OK","Not OK")
  23. Re: Calculating Hours and Returning Positive or Negative Number

    .
  24. Replies
    9
    Views
    5,615

    Re: Count cells by color and get "#NAME?"

    :) :) Thanks for putting it back here. Happy that this link helped you :)
  25. Thread: Subract Time

    by norulen
    Replies
    19
    Views
    740

    Re: Subract Time

    Another compact version after tweaking VoG formula
    =IF(AND(G36=B36,I36>E36),"-"&TEXT(I36-E36,"hh:mm"),MOD(E36-I36,1))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4