Extract the names of the Items purchased at different prices

[ala995]

Hello,
I have a very large database of Items, And most of the Items have the same prices and are purchased at the same common price.
What I want in my case is that if I purchased some item at different prices, I want Excel to show me their names so that I can deal with them later.
For example, in my case, I have this data.

Items.xlsx
	A	B	C	D	E
1	Purchase Number	Invoice Type	Invoice Date	Item	Price
2	1	Purchase Invoice	23/09/2022	Item 1	5
3	29	Purchase Invoice	16/03/2023	Item 1	5
4	1	Purchase Invoice	23/09/2022	Item 1	5
5	29	Purchase Invoice	16/03/2023	Item 1	5.2
6	46	Purchase Invoice	26/04/2023	Item 2	6
7	46	Purchase Invoice	26/04/2023	Item 2	6
8	1	Purchase Invoice	23/09/2022	Item 2	6
9	29	Purchase Invoice	16/03/2023	Item 2	6
10	46	Purchase Invoice	26/04/2023	Item 2	6
11	46	Purchase Invoice	26/04/2023	Item 2	6
12	46	Purchase Invoice	26/04/2023	Item 3	3
13	46	Purchase Invoice	26/04/2023	Item 4	9
14	64	Purchase Invoice	15/06/2023	Item 5	2.9
15	64	Purchase Invoice	15/06/2023	Item 5	2.9
16	64	Purchase Invoice	15/06/2023	Item 5	2.7
17	64	Purchase Invoice	15/06/2023	Item 5	2.9
18	1	Purchase Invoice	23/09/2022	Item 6	10.5
19	29	Purchase Invoice	16/03/2023	Item 6	10.5
20	46	Purchase Invoice	26/04/2023	Item 6	10.9
Sheet1

I want the excel to give me the name of the item (Item 1, Item 5, Item 6) because they are the only Items that were purchased at different prices.

I hope my question is clear and thank you very much in advance

 

[hagia_sofia]

Hello, something like this maybe:

=IF(SUMPRODUCT(($E$2:$E$20)*($D$2:$D$20=D2))/COUNTIFS($D$2:$D$20,D2)=E2,"",D2)

 

[ala995]

This is what I was looking for, thank you very much.