tag:blogger.com,1999:blog-1869924468172210809.post1891141943002212182..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Identify new entries in a listGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-1869924468172210809.post-2370823468896459912015-02-19T07:33:58.116+00:002015-02-19T07:33:58.116+00:00Pleased it hit the spot.Pleased it hit the spot.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-29848365276782719562015-02-19T07:33:50.551+00:002015-02-19T07:33:50.551+00:00Pleased it hit the spot.Pleased it hit the spot.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-22968803377453173772015-02-18T23:45:39.196+00:002015-02-18T23:45:39.196+00:00Hi Casey
Many thanks for your suggestion. It is ve...Hi Casey<br />Many thanks for your suggestion. It is very easy for us 'Excel Lovers' to happily play with formulae, ranges, sheet names and all the associated syntax. <br />I think many of my clients will appreciate the solution you outlined which produces the desired results via a more 'visual approach', without the need for a formula.<br />Many thanks for taking the time to share the idea, GillGill Carnellhttp://www.secretsofsoftware.co.uknoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30115234852074989292015-02-18T23:37:56.241+00:002015-02-18T23:37:56.241+00:00Hi Glen
Thanks so much for taking the time to reco...Hi Glen<br />Thanks so much for taking the time to recommend the CountIf function as a solution to the task I posed. Tried it out and definitely produces the required results. As you say it leaves the sheets and formulae intact for ease of use when repeating the process several times. In fact I don't mail merge the repeat registrations I copy the resulting list of emails into the eventbrite website to generate the invitations but nevertheless it is a neat, efficient and effective solution.<br />Much appreciated, GillGill Carnellhttp://www.secretsofsoftware.co.uknoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-70008733732451419282015-02-17T16:27:59.598+00:002015-02-17T16:27:59.598+00:00There are a number of ways you could do it, but I ...There are a number of ways you could do it, but I think the benefit of the approach I've suggested is that it leaves the lists intact, and takes seconds in the future, after the initial setup.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-69279204832711519932015-02-17T15:54:07.923+00:002015-02-17T15:54:07.923+00:00Could you not just merge both lists on a new combi...Could you not just merge both lists on a new combined worksheet (ensuring that a new field is added first to identify main or secondary list). You can then use conditional formatting on the emails ('highlight duplicate values') and then filter by both 'main list' and 'no fill'. This will give unregistered people on main list.Caseynoreply@blogger.com