Compare cells

jyothish8807 — Tue, 19 Feb 2013 05:57:49 GMT

Rollno	Reviewer
1	Ankit
	b
	a
2	Priya
	a
	c
	b

Rollno	Reviewer
1	Chapter 1
	a
	b
	c
2	chapter 2
	b
	a
	c
	d

Hi friends ,

I want to compare cells of two workbooks1 (master) and Workbook2 (Answer) .Comparison should be done cell wise but the order of data is different in both sheets, moreover some data are missing in workbook2 (Answer) .Plz check the example for more clarification .Is there any other alternative to solve this issue either by using vlookup or any other technique.

Workbook2 Workbook1

But I want to compare both cells of the reviewer and master and check whether its correct or not. And it should compare all the cells of master with answer .If I would be able to consolidate the sheet (ex shown below) then it will be easy for me. Please help me if any other alternate is there.

Rollno	Reviewer	Rollo	Reviewer
1	Chapter 1	1	Ankit
	a		a
	b		b
	c
2	chapter 2	2	Priya
	b		b
	a		a
	c		c
	d

Regards

Jyothish KC

Re: Compare cells

jyothish8807 — Tue, 19 Feb 2013 05:59:14 GMT

The first table is Workbook 2 and seond table is Workbook 1.

topic Re: Compare cells in QlikView

Compare cells

Re: Compare cells