Retrieve data by comparing the two excel Sheets

Allwinv

New Member
Joined
May 19, 2019
Messages
32
Hi Excel Experts,

I have 2 excel sheets (Sheet 1 and Sheet 2) which has ticket number and status of each ticket. Sheet 1 is having Old status and Sheet 2 is having new status. I just want to know all the tickets, which are the status changed from sheet 1. Please find the attached image for your reference. Please help on this.



Thanks.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
In this forum you can not put images that way.
But you can upload an image.
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 
Upvote 0
Hi Experts,

I tried to attach the image through URL. But link is not enabled. Can you please help how to insert image or how to create a link for image to submit in forum. Please guide me.

Thanks.
 
Upvote 0
Thank you very much for the quick reply. I will attach the image based on your suggestions.

Thanks.
 
Upvote 0
One more question : apart from Dropbox, is there any other way i can get a link. Is it possible through google drive ?
 
Upvote 0
Try this

<table style="font-family:Arial; font-size:12pt; border-style: groove ;border-color:#0000FF;background-color:#fffcf9; color:#000000; "><tr><td ><b>Sheet1</b></td></tr></table>
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:8pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:100.75px;" /><col style="width:100.75px;" /><col style="width:81.74px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-size:11pt; ">TICKET NUMBER</td><td style="background-color:#ffff00; font-size:11pt; ">OLD STATUS</td><td style="background-color:#ffff00; font-size:11pt; ">NEW STATUS</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-size:11pt; text-align:right; ">123</td><td style="font-size:11pt; ">Proc</td><td style="font-size:11pt; ">Changed</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-size:11pt; text-align:right; ">456</td><td style="font-size:11pt; ">Rep</td><td style="font-size:11pt; ">Same</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-size:11pt; text-align:right; ">789</td><td style="font-size:11pt; ">Can</td><td style="font-size:11pt; ">Same</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-size:11pt; text-align:right; ">888</td><td style="font-size:11pt; ">Bloq</td><td style="font-size:11pt; ">Dont exists</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=IFERROR(IF(VLOOKUP(A2,Sheet2!A:B,2,0)=Sheet1!B2,"Same","Changed"),"Dont exists")</td></tr></table></td></tr></table>

<table style="font-family:Arial; font-size:12pt; border-style: groove ;border-color:#0000FF;background-color:#fffcf9; color:#000000; "><tr><td ><b>Sheet2</b></td></tr></table>
<br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:8pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:100.75px;" /><col style="width:102.65px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-size:11pt; ">TICKET NUMBER</td><td style="background-color:#ffff00; font-size:11pt; ">STATUS</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-size:11pt; text-align:right; ">123</td><td style="font-size:11pt; ">Bloq</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-size:11pt; text-align:right; ">456</td><td style="font-size:11pt; ">Rep</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-size:11pt; text-align:right; ">789</td><td style="font-size:11pt; ">Can</td></tr></table>
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top