+ Reply to Thread
Results 1 to 3 of 3

Count smallest two against a figure in another column and use logic to get true or false

  1. #1
    Registered User
    Join Date
    08-06-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    23

    Count smallest two against a figure in another column and use logic to get true or false

    Hi Freinds,
    Good day!
    I would like put up my request to get help from you guys.
    I have to get the sum of two smallest number against a figure (alfa numeric in another column) and the use that logic to decide for the third column
    Example:
    column A B C
    A1X 1 Output
    A1X 2 Output
    B1Y 3 Output
    A1X 4 Output
    B1Y 4 Output
    It would like to put a formula that will tell that if the value of b column is 2, then what is the sum of two lowest number against the figure in column A and if it is
    3 then "True" or "False". And one more thing if the value of either of the two lowest number is repeated against the figure in A column than it should be false.

    Hope guys can understand it.
    Thanks in advance and if any further clarification needed please let me know.

    Thanks again
    Pervez

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,106

    Re: Count smallest two against a figure in another column and use logic to get true or fal

    No, sorry. I don't understand your requirement. Please attach a sample worksheet showing WHAT your exected results are. Thanks.

    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon
    Glenn



  3. #3
    Registered User
    Join Date
    08-06-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    23

    Post Re: Count smallest two against a figure in another column and use logic to get true or fal

    Hi..Thanks..problem got resolved.

    Thanks for your interest shown in helping me out and your active participation.

    Thanks

    pervez

+ 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. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  2. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  3. [SOLVED] logic test showing TRUE when should be FALSE?
    By loopiloo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2013, 01:22 AM
  4. [SOLVED] Need to apply individual True/False Value, to Multi-Cell Ratio Count Formula
    By James_D in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2013, 03:55 PM
  5. Replies: 2
    Last Post: 09-06-2012, 03:23 PM
  6. Replies: 2
    Last Post: 09-06-2012, 01:19 AM
  7. Replies: 2
    Last Post: 09-06-2012, 01:19 AM
  8. [SOLVED] True or False if already in column
    By Tim in forum Excel General
    Replies: 4
    Last Post: 10-18-2005, 09:05 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