Results 1 to 10 of 11

Thread: Merge Two Spreadsheets In To One Sheet Based On Matching Column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #10
    Junior Member
    Join Date
    Aug 2013
    Posts
    9
    Rep Power
    0

    Talking

    i found out that the problem could be easily solved with vlookup, and was wondering if you were aware of that or use it much

    even though access likely has so many more flexible uses, i don't think i'll need or use it ever (i'm just merging and doing one simple % calculation, nothing special)

    Answer to I have a lot of data to analyze. What's the advantage of using MS Access to an SQL database and doing manual queries? - Quora clarifies to me to that i overall don't need access

    there's also ASAP Utilities for Excel - ASAP Utilities 5.0 Download this free Excel add-in - Recommended by several magazines but doesn't work for excel 2013 64 bit though :/
    Last edited by exceltoohard; 09-04-2013 at 05:53 AM.

Similar Threads

  1. Replies: 4
    Last Post: 07-08-2013, 05:36 PM
  2. Replies: 4
    Last Post: 06-18-2013, 01:38 PM
  3. Lookup From Cell Range By Matching Row and Column
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 03-07-2013, 02:02 PM
  4. Offset based on Values in Column E
    By mrmmickle1 in forum Excel Help
    Replies: 7
    Last Post: 12-04-2012, 10:06 AM
  5. Finding Last Used Row or Column In Excel Sheet
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •