• 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...

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

Search results

  1. H

    Move cells to same column

    Thank you for your time Hui, I will give it a try.
  2. H

    Move cells to same column

    sorry if i dont express clearly, My spreadsheet have hundreds of rows, each row in the spreadsheet is an individual record,when this file was exported, some fields in the records are not in one column. what I wanted to do is to align those fields which are not on the same column. e.g. balance...
  3. H

    Move cells to same column

    Hi Hui, The result became 123, what I wanted to achieve is to remain the row, just to align them to the same column.
  4. H

    Move cells to same column

    Hi there, I have an excel file which is exported from an application as illustrated below. How do it put cell A1,B2& C3 to the same column. Is there a macro or function which can use to automate this process. Ans the actual worksheet contain bulk of data which is almost impossible to do it...
  5. H

    Choose function

    exactly, I got it now, thank you for your patient, Hui. I have another question, I think i will open it as a new q.
  6. H

    Choose function

    Hui, thank you for your prompt reply,but how does the list '2,1,7,6,5,4,3' being workout ? =(WEEKDAY(DATE(2010,9,1))) return the value of '4' and choose function pick up '6' as the value. I still in the dark. sorry about that.
  7. H

    Choose function

    Hi all, I am not able to figure out the no series of "2,1,7,6,5,4,3" which shown in the choose function. Can someone help ? TIA. When is Labor Day (US) in 2010? Labor day (the US variant) is celebrated on first Monday of every September. It occurs on Sep 6th in 2010. Using excel...
Back
Top