excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Medium Priority · Version 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:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Server loaded in 0.08 secs.