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
Bookmarks