Excel Formula to find the most Expensive Item

Показать описание

Excel Formula to find the most Expensive Item.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick

Рекомендации по теме

Комментарии

This is literally exactly what I have been trying to do! Thank you.

electrician

Sir, first of all thanks for the short videos, which helped alot in office works. It's easy to watch short videos rather than lengthy one.
Sir can you please do same for drop-down option in excel.

sayanwitasaha

Excellent. I think we can use filter function too. But that is a bit longer than this. The good point in filter is that we can find more than one ( first three big for example)

mohammadj.shamim

That's much better than returning just the max value 👍

oddjob

thank you so much mr ajay youre a lifesaver

kiwimelom

It's good, what about top 5 expensive items from the list?

ajaybansod

Control+shift+L will create a filter, you can easy filter price largest to lowest .

danyalibnekhalil

Sir how to get rid of scientific number from excel ?
for example I want 26894E002 or any other number combined with E00.
But the result shows E+ values.

harshithkoshi