+ Reply to Thread
Results 1 to 4 of 4

Specific conditions (values) make a formula bug

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    27

    Specific conditions (values) make a formula bug

    Hello,

    I extracted from my file what is needed to reproduce the bug and attached the sample to this post.

    Here is what happens:
    For each category (column B) I want to identify the largest value (Column J) and pick the correct location (column D). Which will be needed in other worksheets...

    Everything works fine until 2 different Locations got the same value. All goes wrong

    . I highlighted in blue the cells to look at and in red the value changing provocating the issue (hope it helps)
    . The bugging formula is in column "O":

    Please Login or Register  to view this content.
    I try to play around but cannot fix it,

    Thank you
    pit
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Specific conditions (values) make a formula bug

    Try this array formula in O5 and then drag across (say Q5) and down to list all locations for more than one same max values and see if this helps.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Specific conditions (values) make a formula bug

    Thanks sktneer, it worked !

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Specific conditions (values) make a formula bug

    Glad it helped. Thanks for the feedback.
    Moreover if you have got your answer, please mark your thread as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generating a list of unique values based on specific conditions
    By Gobaith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2012, 11:35 AM
  2. Iterate through values meeting specific conditions
    By pico32 in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 05:14 AM
  3. Replies: 2
    Last Post: 02-01-2012, 06:28 PM
  4. Replies: 2
    Last Post: 04-14-2010, 07:46 PM
  5. summing values using specific conditions
    By elecengr in forum Excel General
    Replies: 9
    Last Post: 02-02-2009, 09:35 PM

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