|
HELP!!!!
I have two lists. The old one (for example) has 2850 rows of data, then the
new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
In the new list in an adjacent column
=IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
Hi Bob
Thanks for the formula. However, I can't make it work. I keep getting #VALUE appear in the cell. I used to think I was quite good with Excel - I'm now starting to wonder... Thanks for any help you can give - I appreciate it! "Bob Phillips" wrote: In the new list in an adjacent column =IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
It works as interpreted, so you would need to give examples of the two
datasets (columns, rows, values, etc.) to help us sort it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... Hi Bob Thanks for the formula. However, I can't make it work. I keep getting #VALUE appear in the cell. I used to think I was quite good with Excel - I'm now starting to wonder... Thanks for any help you can give - I appreciate it! "Bob Phillips" wrote: In the new list in an adjacent column =IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
A B C D
1 FirstName LastName NUS Card No. EMailAddr 2 worksheets in the same file - old list called 20-10-06, new list called 16-11-06. I know there are 47 new names on the new list and I only need these 47. Do you need any more information or is that enough. Thanks again for all your help (and patience!) Lorna "Bob Phillips" wrote: It works as interpreted, so you would need to give examples of the two datasets (columns, rows, values, etc.) to help us sort it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... Hi Bob Thanks for the formula. However, I can't make it work. I keep getting #VALUE appear in the cell. I used to think I was quite good with Excel - I'm now starting to wonder... Thanks for any help you can give - I appreciate it! "Bob Phillips" wrote: In the new list in an adjacent column =IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
Lorna,
You could use something like this; assuming that NUS Card No. is a unique #... =if(countif(A1,D:D)=1,"","New") HTH Hans Katt595 wrote: A B C D 1 FirstName LastName NUS Card No. EMailAddr 2 worksheets in the same file - old list called 20-10-06, new list called 16-11-06. I know there are 47 new names on the new list and I only need these 47. Do you need any more information or is that enough. Thanks again for all your help (and patience!) Lorna "Bob Phillips" wrote: It works as interpreted, so you would need to give examples of the two datasets (columns, rows, values, etc.) to help us sort it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... Hi Bob Thanks for the formula. However, I can't make it work. I keep getting #VALUE appear in the cell. I used to think I was quite good with Excel - I'm now starting to wonder... Thanks for any help you can give - I appreciate it! "Bob Phillips" wrote: In the new list in an adjacent column =IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
HELP!!!!
Can you mail me your spreadsheet, that info doesn't help much I am afraid.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... A B C D 1 FirstName LastName NUS Card No. EMailAddr 2 worksheets in the same file - old list called 20-10-06, new list called 16-11-06. I know there are 47 new names on the new list and I only need these 47. Do you need any more information or is that enough. Thanks again for all your help (and patience!) Lorna "Bob Phillips" wrote: It works as interpreted, so you would need to give examples of the two datasets (columns, rows, values, etc.) to help us sort it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... Hi Bob Thanks for the formula. However, I can't make it work. I keep getting #VALUE appear in the cell. I used to think I was quite good with Excel - I'm now starting to wonder... Thanks for any help you can give - I appreciate it! "Bob Phillips" wrote: In the new list in an adjacent column =IF(COUNTIF(Sheet1!A:A,A1)=0,"New","") and copy down -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Katt595" wrote in message ... I have two lists. The old one (for example) has 2850 rows of data, then the new one, has 2897 - ie 47 new fields. I need to filter out the new fields and I have tried everything! Can anyone help me? I have to do this job once a week and can't believe that my only option is to go through each list one row at a time. Hopefully |
| All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com