Hi All, I have here a formula and its working well. But i have a problem.
In column a are the names and in column e are the values.
Please Login or Register to view this content.
a 1
a 1
a 1
a 1
b 2
b 2
b 2
c 6
c 6
what i need to add is when the values in column e are the same ex. customer a all values are 1 it should display Equal and not yes.
So i should have 3 output: YES, NO and EQUAL
Attached is the file
Hope u can help me Book1.xlsx
Last edited by geliedee; 01-06-2015 at 07:37 AM.
Sorry wrong solution
Hi try this
Punnam
Last edited by Punnam; 01-06-2015 at 07:40 AM.
=IF(AND(E2=MAX(IF($A$2:$A$13=A2,$E$2:$E$13)),E2>1),"Yes","No")
Try this array formula
Confirm with Shft+Ctrl+Enter
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi geliedee,
Did you edit your requirement?
If so then please mention it.
Regards,
AM
Hi, the values in column a is duplicated.
hi ashishmehra2010, thanks for the reminder. yes i have edited it and when i refreshed, i saw the first answer to my question.
So here's the updated one.
what i need to add is when the values in column e are the same (ex. customer a all values are 1) it should display Equal and not yes, not no.
So i should have 3 output: YES, NO and EQUAL
hi nflsales, i tried your formula, it applies for customer with the 1 values in column e.
the out put should be liked this:
a 1 EQUAL
a 1 EQUAL
a 1 EQUAL
a 1 EQUAL
b 2 NO
b 3 YES
b 1 NO
c 6 NO
c 7 YES
C 5 NO
=IF(COUNTIF($A$2:$A$10,$A2)=COUNTIFS($A$2:$A$10,$A2,$E$2:$E$10,$E2),"Equal",IF(COUNTIF($A$2:$A$10,$A2)=COUNTIFS($A$2:$A$10,$A2,$E$2:$E$10,"<="&$E2),"Yes","No"))
Try this in H2 and copy towards down
hi @nflsales , that worked really good! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks