+ Reply to Thread
Results 1 to 3 of 3

Looking for a formula, I believe it will involve both Vlookup and the Max function.....

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Jackson
    MS-Off Ver
    Excel 2007
    Posts
    2

    Looking for a formula, I believe it will involve both Vlookup and the Max function.....

    I am building a database to collect data on defects for work. I need a formula that would look for the most called defect for the week and instead of reporting the # of calls post the name of the part instead. I don't see why it wouldn't be possible but am new to Excel and just now figuring this stuff out. Thank you much for any advice in advance.

    The file setup like this

    Column A - Location, Column B - Part, Column C+ week ending date.
    Each row just fills in the data for the above with the number of defects that week under the date.

    I have the totals built into a separate sheet that will contain the formula in question so that all I need to do is enter the data and refer to the second sheet for any information I need.

    Secondary question, I normally just hit the Column to select all and sort but it was switching up the totals when they were in the same sheet which was why I transfered them over to the second sheet. Is there a way to tell excel to sort only the actual data without actually selecting the data itself so that I can continue to use the Column to select all rather than select just the cells the data is in?

  2. #2
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Looking for a formula, I believe it will involve both Vlookup and the Max function....

    Can you please submit a sample Excel File, so that your query can be easily solved.

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    Jackson
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Looking for a formula, I believe it will involve both Vlookup and the Max function....

    Quote Originally Posted by tgsekhar View Post
    Can you please submit a sample Excel File, so that your query can be easily solved.
    I was just thinking it would be easier if I had the file I can upload but it is at work, it will be tomorrow before I can upload it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1