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

    To check the duplicate row if the 3 cell of the row is same

    Hi persol, Can you set me a formula to automatically color the duplicate row along with the following formula =IF(COUNTIF(B:B,B2)>1,"Duplicate","")
  2. S

    To check the duplicate row if the 3 cell of the row is same

    hi persol, also, consider using the following formulas: =IF(COUNTIF(B:B,B2)>1,"Duplicate","") or =IF(COUNTIF($B$2:$B$200,B2)>1,"Duplicate","") Both will detect duplicate numbers, labels, names, amounts, etc. your above formula works but...i don want to color the row of...
  3. S

    To check the duplicate row if the 3 cell of the row is same

    Hi, can u solve this for me. I have 3 cell with customer no:,date, and vendor no:.if any other cells have the same customer no:, date and vendor no:.it should be shown as red... It is to find out duplicate when the 3 column is same. Could you please help me on this. Regards Saneesh
  4. S

    Formula for seggregation of dates

    thank you mike........
  5. S

    Formula for seggregation of dates

    Hi, I have one column with 1000 dates and i have on particular date with me...according to this date i want to divide this date into 3.that is <45,45-90 days,>90days Could you please arrange me a formula for this.. Regards Sannesh
  6. S

    past date formula

    Thank you for you fast update...
  7. S

    past date formula

    how to get a decimal figure by subtracting two past date(not current date).. ie;07(month)/08(date)/2011(year)-07(Month)/23(Date)/2011(Year)=answer 15(means the gap between the past 2 days.
Back
Top