office13broken Posted August 30, 2013 Share Posted August 30, 2013 (edited) ***SOLVED ***it's been solved.....the solution from easiest to hardest are:vlookupwww.asap-utilities.com/download-asap-utilities-free.php?file=1 (doesn't work for excel 2013 64 bit though :/ms accesssorry i could not explain it better.... thank you..*** OP ***hey im trying to do hobby project and i have this really big problem: im trying to merge two spreadsheets with one sheet each into a new one. they should be merged based on matching ids in column A1:A1000, so the outcome would not have duplicated ids.im assuming this is a common need but i couldn't find anything for excel 2013please advise. link to a good video guide would be helpful and good. Edited September 4, 2013 by office13broken Link to comment Share on other sites More sharing options...
jaclaz Posted August 30, 2013 Share Posted August 30, 2013 Forget about Excel 2013.This is "basic" spreadsheet use.Post an example of the contents of first and second sheet.Basically you want to use the VLookUp function on the third sheet:http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspxjaclaz Link to comment Share on other sites More sharing options...
office13broken Posted August 31, 2013 Author Share Posted August 31, 2013 (edited) THANKS SO MUCH!! i found what i needed -- i needed to know what the word 'consolidate' in excel meant. this is by labels, so 'top row' and left column' just curious, would vlookup be easier for this? or would be the same?this is for making a map! Edited August 31, 2013 by office13broken Link to comment Share on other sites More sharing options...
jaclaz Posted September 1, 2013 Share Posted September 1, 2013 It depends of what you want to do. A "report" sheet made using vlookup and similar functions is "dynamic" and "connected" to the source worksheet(s).Any change in the source will be "reflected" on the "report" sheet, you can have as many "report" sheets as you want, each one highlighting some fields or having fields in a given order, sorting them, etc.In this case you would be using Excel as a "poor man's" database, where you have one or more sheets (separated or connected among them) containing "raw data" and one or more "report" sheets allowing to sort/visualize the data in any given form.The use of consolidating functions built-in in Excel is a (very limited) subset of what you can do "manually".jaclaz Link to comment Share on other sites More sharing options...
office13broken Posted September 2, 2013 Author Share Posted September 2, 2013 sadly i need to request for aid again as i realised far too late that 'consolidate, from what i understand, only does numerical data...doesn't need to be dynamic (changes base on source data)advise please? Link to comment Share on other sites More sharing options...
jaclaz Posted September 2, 2013 Share Posted September 2, 2013 advise please?I advise you to provide the example that I requested earlier. jaclaz Link to comment Share on other sites More sharing options...
office13broken Posted September 2, 2013 Author Share Posted September 2, 2013 (edited) it's just data from A-C1 : A-C1000the same as the sheet you want to merge withonly difference is A2:A1000 would have similar ids/labels so the id would need to match upon merge and not be duplicatedthe first post describes what the problem is though. it never mentions anything about dynamic and all these other things i don't know what you mean by 'report' sheet because this is for making a mapbut making a map has nothing to do with the problem, just letting you know was all Edited September 2, 2013 by office13broken Link to comment Share on other sites More sharing options...
office13broken Posted September 2, 2013 Author Share Posted September 2, 2013 it would be type B on http://welfarestate.com/Excel-Data-Matching-Merger/ but that script doesn't seem to work on excel 2013 Link to comment Share on other sites More sharing options...
jaclaz Posted September 3, 2013 Share Posted September 3, 2013 Look, you asked for advice, I gave some to you.Please provide some example data.You do not follow this advice, I cannot provide you with further ones.I need an example actually a sample of the EXACT, SAME data you are working with, to be able to provide quickly (and hopefully) a solution to your issue.Please do cooperate in taking the §@ç#ing guessing out of the equation:http://homepage.ntlworld.com./jonathan.deboynepollard/FGA/problem-report-standard-litany.htmlRemember that is you that have the problem and someone else, in his/her spare time and for free, is trying to help you, why not making the life of this someone a little bit easier? jaclaz Link to comment Share on other sites More sharing options...
office13broken Posted September 4, 2013 Author Share Posted September 4, 2013 it's been solved.....the solution from easiest to hardest are:vlookupwww.asap-utilities.com/download-asap-utilities-free.php?file=1 (doesn't work for excel 2013 64 bit though :/ms accesssorry i could not explain it better.... thank you.. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now