Hi there everyone, here i am again.
I have a question that is as tricky as difficult.
So i want to create a sheet where i can put a line with several suppliers ( of fruit, milk etc) and under each supplier the product price, around 5 prices to comparisson.
Now what i need is a formula that automatically searches in a determinated line the highest price/lowest price calculating imidiatly the difference, p ex.:
- [Line 2:] A BC D Difference
- [Line 3:] 30€ | 25€ | 27,5€ | 20€ = 10€
Is this possible to do?! perhaps is a challenge... :/
Best regards
Bookmarks