Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Tables

Resolved · Low Priority · Version Standard

Reply Wed 20 Feb 2008, 13:18Delegate Samantha said...

Samantha has attended:
No 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.

Hope this makes sense.

I am going to email Stephen with the list of RFOs so he can hopefully answer this questions.

Thanks,
Sam

For upcoming training course dates see: Pricing & availability

Reply Sat 1 Mar 2008, 11:00Trainer Cress said...

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?

Excel articles

· How Sharing Your Excel Data Can Help Your Business Flourish
· How To Manage Your Everyday Spending In Excel
· So Can You Really Sort On Colours In Excel 2007?
· Microsoft Excel's Best Kept Secret
· Correct In, Garbage Out

Please browse our web site to find out more about
microsoft excel courses tate and other Microsoft training courses.

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips