Hi all,
I have a very large spreadsheet (7000+ rows).
Column B contains various Customer Names that repeat (column name: CUSTNMBR)
Column K contains the Unit Price of each invoice (column name: UNITPRCE)
I need to know which customers show a unit price of $0.00 AND $10.00. (or $0.00 AND $12.00)
Can anyone help me come up with a formula or function to achieve this? What I need the formula to do is...single out those customers that have a unit price of 0.00 in at least one of the rows in Column K AND 10.00 in at least one of the rows in Column K.
(I am including a spreadsheet which contains sample data, hope this helps)
THANKS SO MUCH in advance!
NOTE: this question has also been posted on the following forum:
https://www.mrexcel.com/forum/excel-...h-columns.html
Bookmarks