Thanks, I made good headway with Excel. I am waiting for some more data. Sent from my iPhone
> On Dec 18, 2021, at 1:18 PM, Brian Webster <[email protected]> wrote: > > > Chuck if you don’t get that task done send the files to me and I can probably > link them up and merge the file. My GIS software lets me work with csv files > and tables and do some cool stuff with matching and such. > > Thank you, > Brian Webster > www.wirelessmapping.com > > From: AF [mailto:[email protected]] On Behalf Of Andrew Haninger > Sent: Saturday, December 18, 2021 2:32 PM > To: AnimalFarm Microwave Users Group > Subject: Re: [AFMUG] OT Merging Data > > If the common thing between them is something like an email address or > account number, I wonder if the venerable vlookup or the new xlookup will > work? > > Then I agree with making a new file or sheet and put that common value in one > column and remove duplicates. > > Then use columns B,C,D,E,F, etc to lookup your other data. > > Be careful about the dollar signs in your cell references. A1 and $A$1 refer > to the same cell, but behave differently when you copy and paste. The dollar > signs tell Excel to lock that reference in place. Without it, Excel will > adjust the reference when you copy and paste it around. I don't think I'm > explaining this very well. > > For sure someone else has done this before. I'd be surprised if Excel > couldn't handle it. > > Andy > > On Sat, Dec 18, 2021, 12:03 Chuck McCown via AF <[email protected]> wrote: > > I have at least three files I need to merge. Spreadsheets. > > Say one has names and addresses > One has addresses and phone numbers > One has phone numbers and email addresses > > They are not the same length of file so certain records are missing in all > three files. > There is something common to allow one file to be merged into at least one of > the other files. > > I really don’t want to write code to parse and search. > I am hopeful there is some kind of feature in excel that could do this. > Or I guess I might be able to fire up a database and make it happen. > > Any suggestions? > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
