Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » How To » Tables (RSS)

Browse by Tags

  • Creating a Master-Detail View in Excel

    Today's author, Dan Battagin, a Program Manager on the Excel team, talks about joining two tables in Excel (a.k.a. returning multiple rows for VLOOKUP). Today, we'll take a look at the VLOOKUP function, and work out a way to get around its major drawback - it returns only a single value that matches the lookup. If you're like me, there are times when you have a big table of data which is pretty well normalized, and you want to pull all of the rows out of that table that match a certain...

  • Tracking Split Costs

    Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. We had a blast, but that’s a conversation for another day. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.