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

    Finding the unique distinct values based on a condition

    Hello Narayan You are right. I made a mistake. Your formula works too. However, I have to mention the range of cells manually. What if I would like excel to go through the entire column and give me the result. Thank You
  2. K

    Finding the unique distinct values based on a condition

    Hello Deb I have 2010. Your formula worked like a charm. However, I do not understand what is being done in the formula. Could you please explain. Also, how would the formula change if i do not want to mention 500 cells. What if I want excel to read the column A and Column B rather than...
  3. K

    Finding the unique distinct values based on a condition

    Hello All I am trying to find the unique distinct value in Column B based on the Value in Column A Year Situation 1/3/2011 AK3289 2/5/2011 4/1/2011 AM9832 5/3/2011 AK3289 9/4/2011 PMY0983 28/8/2011 1/5/2012 AF2345 1/22/2012 AK2134 3/4/2012 4/5/2012 3/9/2012 AF2345...
Back
Top