1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comments in attached need addressing

Discussion in 'Excel Jobs, consulting gigs & freelancing' started by muna, Oct 21, 2018.

  1. muna

    muna Member

    Messages:
    75
    Willing to pay £20 for successfully addressing all the comments in the attached.

    Paypal preferred.

    I'm willing to pay first (providing I trust you... In other words, long-term users who I have seen help others).

    Please do not put this in another forum. I want to pay. I require attention due to the urgency and would rather pay for a higher quality service.

    Deadline: 9pm UK time on 22/10/2018.

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    Source data: O2: =IF(SUM((E2=F2)+(G2=H2)+(I2=J2)+(K2=L2))=4,"All Ok","X") then copy down

    One issue you have is that the source data has non-printable characters

    Source Data E2 contains XSTTO<CR> where <CR> is the carriage return code Char(13)

    check it by =Len(E2) and it is 6, not 5
    muna likes this.
  3. muna

    muna Member

    Messages:
    75
    Really appreciate this. I will have to test it when I get home.

    Could you attach a file addressing all the comments? Happy to extend the deadline to 9pm the following day.

    I was really hoping you would respond as I know how helpful you are. I’ve been lurking this forum for some time and admire your dedidcation and professionalism in helping others.

    Please help me! I’m not going to lie, pretty desperate and stressed to get this resolved
  4. muna

    muna Member

    Messages:
    75
    Can you help? :(

Share This Page