Note that Vlookup functions need things in ascending order for your actual value you're looking up otherwise you'll get odd results. I use these a lot, and they're very useful.
> -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Richard B > McDonald via Jfw > Sent: Monday, December 01, 2014 8:49 AM > To: 'Greg Nickel'; 'The Jaws for Windows support list.' > Subject: RE: Category grouping in excel > > Someone else mentioned pivot tables, which may indeed be the best way > to go; but they are a bit complex. Alternatively, you may want to use > the "vlookup" function. This would involve simply adding a new column > "Category" into which you would add a code (e.g., "1", "A", Lumber", > etc. or whatever you want) and then vlookup would look for the match > and sum for each match respective to the indicated column amount. Note > that your cvlookup function is imbedded within a sum function to do > this. Also, so long as each of your line item descriptions are > consistent you do not need to add a category column but, rather, could > just "vlookup" on that. > > HTH, > Richard > > -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Greg > Nickel via Jfw > Sent: Sunday, November 30, 2014 8:07 PM > To: [email protected] > Subject: Catagory grouping in excel > > Hello all. > > > > Can anyone tell me how to group line items in excel by their row title? > > > > I have catagories of construction costs that have been expensed on > different dates for different amounts. I'd like to categorize them by > row title so that all the expenses for each category are grouped > together. > > > > Thanks, as always. > > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.the-jdh.com/pipermail/jfw_lists.the- > jdh.com/attachments/201411 > 30/cec9d7a3/attachment.html> > _______________________________________________ > Jfw mailing list > [email protected] > http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com > > > _______________________________________________ > Jfw mailing list > [email protected] > http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
