• 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

    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!"...
  2. 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
  3. 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...
  4. 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"...
  5. 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