Comparing data on two worksheets

Thanks Doug,

The first part is I'd like to know which organisations are on list 1 below(which means they got at least some 2016/17 funding) and not on list 2 (2015/16 funding), and vice versa. This should tell me which organisations were funded in 2016/17 but not in 2015/16. And which organisation were funded in 2015/16 but not in 2016/17. Which organisations are received funding for both years? You could use organisational name. The UKPRN is a unique identifier for each organisation, if useful.

Probably best to have a look at the relevant spreadsheets at https://www.gov.uk/government/collections/funding-allocations-and-performance-management-for-providers #sfa-funding-allocations and scroll down for the two latest funding allocation Excel sheets:

'SFA funding allocations

The SFA publishes funding values for colleges, training organisations, local authorities and employers with a contract .

1. SFA funding allocations to training providers: 2016 to 2017
18 October 2016 Guidance

2. SFA funding allocations to training providers: 2015 to 2016
29 June 2016 Guidance

The second part is about comparing particular columns from 2016/17 and 2015/16. For example, which organisations received funding for '16-18 Apprenticeships and Agency funded 16-18 Traineeships
2016/17' in 2016/17 but not in 2015/16, vice versa and which organisations got funding in both years. It would be great to show the amounts of funding so I could total up each funding stream.

You'll see some but not all the columns have the same headings across both years. However, Adult Education Budget is the same as Adult Skills Budget, by the way.

Grateful for guidance and support,

Cath