Compare names from different months

[philb99]

I am trying to compare Names + Course from 2 different months and having issues with Conditional Formatting

Can someone advise me how to do this please. Looking to show which Names and Course are reported in Month 2 as well as Month 1 for the same Name and Course

Thanks

 

[Twollaston]

I am trying to compare Names + Course from 2 different months and having issues with Conditional Formatting

Can someone advise me how to do this please. Looking to show which Names and Course are reported in Month 2 as well as Month 1 for the same Name and Course

Thanks

You can create a concatenate field next to you table, and then use conditional formatting for duplicate values (as long as their won't be a duplicate in the same month)


[TABLE="width: 85%"]
<tbody></tbody>[/TABLE]

Excel 2010
	L	M	N	O	P	Q	R
1	Table 1				Table2
3	Name	Course			Name	Course
4	Jim	English	JimEnglish		Jim	English	JimEnglish
5	John	Science	JohnScience		Mark	Science	MarkScience
6	Mark	Science	MarkScience		John	Math	JohnMath
Sheet5

Cell Formulas
Range	Formula
N4	=L4&M4
R4	=P4&Q4

 

[Twollaston]

Alternatively you could try something like this:

Excel 2010
	L	M	N	O	P	Q
1	Table 1				Table2
3	Name	Course			Name	Course
4	Jim	English			Jim	English
5	John	Science			Mark	Science
6	Mark	Science			John	Math
7
8
9
10
11
12
13
14
15
16			Jim	English
17
18			Mark	Science
19
20
21
22
Sheet5

Cell Formulas
Range	Formula
N16	=IF(SUMPRODUCT(($L4=$P$4:$P$6)*($M4=$Q$4:$Q$6)),L4, "")
N17	=IF(SUMPRODUCT(($L5=$P$4:$P$6)*($M5=$Q$4:$Q$6)),L5, "")
N18	=IF(SUMPRODUCT(($L6=$P$4:$P$6)*($M6=$Q$4:$Q$6)),L6, "")
N19	=IF(SUMPRODUCT(($L7=$P$4:$P$6)*($M7=$Q$4:$Q$6)),L7, "")
N20	=IF(SUMPRODUCT(($L8=$P$4:$P$6)*($M8=$Q$4:$Q$6)),L8, "")
N21	=IF(SUMPRODUCT(($L9=$P$4:$P$6)*($M9=$Q$4:$Q$6)),L9, "")
N22	=IF(SUMPRODUCT(($L10=$P$4:$P$6)*($M10=$Q$4:$Q$6)),L10, "")
O16	=IF(SUMPRODUCT(($L4=$P$4:$P$6)*($M4=$Q$4:$Q$6)),M4, "")
O17	=IF(SUMPRODUCT(($L5=$P$4:$P$6)*($M5=$Q$4:$Q$6)),M5, "")
O18	=IF(SUMPRODUCT(($L6=$P$4:$P$6)*($M6=$Q$4:$Q$6)),M6, "")
O19	=IF(SUMPRODUCT(($L7=$P$4:$P$6)*($M7=$Q$4:$Q$6)),M7, "")
O20	=IF(SUMPRODUCT(($L8=$P$4:$P$6)*($M8=$Q$4:$Q$6)),M8, "")
O21	=IF(SUMPRODUCT(($L9=$P$4:$P$6)*($M9=$Q$4:$Q$6)),M9, "")
O22	=IF(SUMPRODUCT(($L10=$P$4:$P$6)*($M10=$Q$4:$Q$6)),M10, "")

 

[philb99]

Perfect thank you