![]() |
| Customer: Sign in Delegate: Sign in Trainer: Log in |
|
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables Pivot TablesThe UK's most regular instructor-led training courses.
Pivot Tables
We have two different excel spreadsheets - one which gives a list of all projects supported through our funding programme, Grants for the arts (data already supplied for our tailored training programme with Stephen on 19th Feb 08), and another which lists all of the Arts Council's Regularly Funded Organisations (RFOs). What we are currently unable to do is report on RFOs which have also been funded through Gfta (i.e. our reporting systems are unable to report across different funding programmes). What we would like to be able to do is somehow cross reference these two sets of data so that we can just note on our Gfta report, those applicants (identified via contact URN) which are also RFOs.
RE: Pivot Tables
You might be able to use the vlookup formula in excel to see if one value on a data sheet appears anywhere on the other data sheet. Are there any common fields between the two sheets? Like a name or an ID or something?
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mini sitemap. These are the main areas of our web site. Full sitemap. |
© 2009 Best STL. All
Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms
and Conditions