This was one of the exam I encountered when I applied to one company. Need your help as I am curious and will definitely expand my knowledge in excel.
Challenge is need to use formulas only. I already tried using Index combined with Small functions. But I can't incorporate the given criteria as it only accepts absolute value.
Here's the scenario. Need to list down the fruits based on sales on a given criteria.
1st criteria below $1500
2nd criteria between $1500 - $2000
3rd criteria above $2000
See attached file for the detailed list of data. We should have the exact same list as shown in Sheet1.
Bookmarks