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

    Date Format Issue

    Hi All, I just separate the date and time in different columns which helped me to get the data in date format. Now i want to merge the date and time in one column. Is there a way. Column A: 10/20/2015 Column B: 00:12 Column C should be : 10/20/2015 00:12
  2. A

    Date Format Issue

    I did convert both the columns but its still the same.
  3. A

    Date Format Issue

    Hi Jake, the "+" shouldn't make any difference (as per me). I did the changes but its still not working.
  4. A

    Date Format Issue

    Hi Hui, Thanks for taking your time on this. But unfortunately its not working.
  5. A

    Date Format Issue

    Hello Everyone, The formula im using is simply. Im just trying to find the difference between two dates. The problem im facing is the date format issue. I had pulled the dates from a different source and placed the same in Excel. But now when i try to add the formula im getting " #VALUE!"...
  6. A

    Data Available on Rows need to be presented on Columns

    Thanks a lot for your help. Im getting my expected result.
  7. A

    Data Available on Rows need to be presented on Columns

    Thanks. I did face some problem in getting the exact data as i think i have not provided the actual scenario of the master data. I'm enclosing the updated Master data on which i have add additional Row's (highlighted in yellow). Sorry for not being clear on the first instance. Much Appreciated.
  8. A

    Data Available on Rows need to be presented on Columns

    I have huge data which are in multiple rows. But i want those data's to be represented in Columns. I have enclosed a sample document which represents the Master Data format and also the expected resulted im looking for. Thanks in advance for your help on this. Much Appreciated. Regards, Anand
  9. A

    Need help on the enclosed sample data

    Thanks to both for your help. @NARAYANK991 Could you please explain me the formula you have used.
  10. A

    Need help on the enclosed sample data

    Hi All, On the enclosed data Column A has the PDD number and its corresponding insert date is available on Column C (multiple rows). If Column A Value is S054.01015 then i want the result to be 01/05/2012 19:27:25 which is the highest among others in Column C. Like wise if Column A Value is...
  11. A

    Conditional formatting or any other method

    I have a running data which is from Column A to AF and Row 1 to n. When I give a comment in Column G stating "Approved" and Column I stating "Success" then i want the entire Column i.e. A to AF for that particular Row to be highlighted in a specific color. Likewise if Column G is "Pre-Approved"...
  12. A

    Need to add Additional Query in the IF formulae i have [SOLVED]

    Thanks a Lot!!! It worked.
  13. A

    Need to add Additional Query in the IF formulae i have [SOLVED]

    I have a formulae IF(U1<>"",IF(W1="Approved",TEXT(U1,"mm… Basically this formulae is used to place the Month and year detail on U1 if W1=Approved. The challenge i have is in W Column i have multiple entry such as Approved, Pre-Approved, N/A. Now i want to add "Pre-Approved" too in...
Back
Top