Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Sarah has attended:
Excel Intermediate course
Excel Advanced course

Excel

Hi,

I have a spreadsheet with costs for different stationery types (paper etc.) from different stationery firms I want to show in the last column the name of the company which has the cheapest number for each item

For example if Staples paper was cheaper than another 3 stationers I would want the name "Staples" to show in the last cell.

I hope that makes sense

Thanks
Sarah

RE: Excel

Hi Sarah, thanks for your query. You need to use the Match, Index and Max (or Min) functions to achieve this. Bit complicated to explain here, but here's a handy link:

http://www.exceltip.com/st/Retrieving_the_Column_Header_of_the_Largest_Value_in_a_Row/1014.html

Hope this helps,

Anthony

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.