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

1. ## 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. ## 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

3. ## 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

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

#### 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