Previous Topic Next Topic

Comapre excel sheet and generate result

Closed
saritha - Nov 27, 2009 at 04:44 AM
 saritha - Dec 10, 2009 at 12:16 AM
Hello,
I have an excel workbook contains students details like name , Roll no, address,phone numbers etc. and another
book contains only Name, Roll number and fee details. I want to compare these two sheets and generate an excel sheet which contains the names and roll no of students those who didn't pay fees.

Please help.

saritha
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 28, 2009 at 08:01 PM
the configuration of the two sheets is not known. anyhow you can try autofitler -custom
1
saritha
Dec 10, 2009 at 12:16 AM
normal two worksheets, sheet1 contains Name, roll no, address ..etc (almost 1000 lines ). second sheet contains same students fee submission details.

I just wanted to compare these two sheets.

result data sheet = data in sheet1 - data in sheet2

intention ..... I want to generate a workbooks containing list of students those who didn't paid the fees.

can u help, I am a beginner in excel.

thanks in advance

saritha
0

Similar discussions

Excel - To generate unique ID
wliang -
ferg -

4 responses
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
App Password "This Feature isn't Available Right Now"
DavidS -
Enduroelm -

11 responses