• 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

    Find Last Billing Date for each Customer.

    Thanks Faseeh. You are rocking!!
  2. S

    Find Last Billing Date for each Customer.

    Hi, All, I have some 80000 rows of data for some 1600 customers, out of that I have to find last Billing date for each customer. Sample Data is given as below. Please help me out. Distributor Code Invoice Date 305226 20-Jan-12 305309 21-Jan-12 305314 22-Jan-12 305315 23-Jan-12 305218...
  3. S

    Find nth Column Number for first instance of data occurance

    Thanks NARAYANK991, You are really awesome!!
  4. S

    Find nth Column Number for first instance of data occurance

    Hi, I have a data of Customers and their Monthly Invoicing details in MOM format as shown below. Now, I want to find their first month when they invoiced and also calculate their first six months of total business. Data is as below for reference:- Customer Jan/10 Feb/10 Mar/10 Apr/10...
  5. S

    How to protect excel data from getting misused.

    Thanx a lot!! to "SirJB7" & "Luke M" for your valuable inputs.
  6. S

    Excel file to be opened on specific PCs.

    Hi, I want to protect my data sheet so that it can not be opened on any PC (other than specified one). I want to create a macro which stores "Computer Name"/"User Name" then matches on finding the current "Computer Name"/"User Name", if it does not matches then file closes or does not open...
  7. S

    How to protect excel data from getting misused.

    Hi, I am facing one problem in my office. I have one file with confidential sales data which is shared to some of our team members. And it is updated on monthly basis. Now, for the fear of data might be misused, we want that this data to be protected. This file is kept at one of our office...
  8. S

    Create list of related Data

    we have a data set like this- Region City North JAIPUR North DELHI East KOLKATA East PATNA South BANGALORE South CHENNAI Now in other sheet, I have created a drop down list of Regions in A1, Now I want that all the cities of selected region to be shown from B1 to B9999. Please help...
  9. S

    Count unique values among duplicates

    Hui, I am really apologetic for miscommunication from my side. Your solution is working well. Many Thanks for support.
  10. S

    Count unique values among duplicates

    I have uploaded the Demo Sheet and also explained the result I need. https://rapidshare.com/files/961030234/Demo_Sheet.xls Thanks in Advance for your support
  11. S

    Count unique values among duplicates

    Hui, How can I share excel sheet with you, so that result I want can be understood by you. Thanks,
  12. S

    Count unique values among duplicates

    Thanks Hui for your response, but by taking above data the formula gives 48 for all rows.
  13. S

    Count unique values among duplicates

    Guys please help me getting count unique values among duplicates. Column 1186MPYes 1002PBYes 1003PBYes 1004PBNo 1005PBNo 1007PBYes 1017PBYes 1020PBYes 1021PBYes 1022PBYes 1025PBYes 1031UPYes 1032PBYes 1038HRYes 1042HRYes 1043PBYes 1045PBYes 1046PBYes 1047PBYes 1049HRYes...
Back
Top