06-02-2020 10:19 AM
06-02-2020 10:19 AM
Hello, I am trying to reorganize a list of data, to create separate columns, so that I can calculate total sales per type of item, total amount owed. I'm attempting to use the VLookup function or Index Match. The Text Manager is not giving me the columns in the way that I have them set up.
06-02-2020 11:25 AM
It's quite unlikely that anybody will be able to give you cogent advice based solely on the description you give. Could you upload the file (or a sample of it) so that we could actually see what it is you're working with?
06-02-2020 12:12 PM - edited 06-02-2020 12:14 PM
06-02-2020 03:06 PM
Valencia -- I'm, frankly, conflicted here when it comes to helping you. Why? Because you'd learn a lot more by struggling through figuring out how to resolve these on your own. I'll make a couple of recommendations or suggestions, but it'd be a lot better if you made some more efforts at figuring out your own solutions.
You mentioned in your first message that "The Text Manager is not giving me the columns in the way that I have them set up." I'm not even sure what you're referring to as "the Text Manager"--excel Help does not return any results from that term. There ARE text manipulation functions and I've used a few of the basic ones here in the attached revision of your sheet, to resolve the very first of the problems. These are the functions LEFT, MID, and RIGHT.
These all operate on Cell A4, which contains the text: "Daisy Girl #1 O# 1"
Having done this, I will tell you that VLOOKUP should work for the rest of the columns, where you're supposed to find the number of different cookies each girl sold.
And if you're really interested in teaching yourself, I'd highly recommend a book by Smitty Smith (a Microsoftie), a book entitled Excel 2019, Business Basics & Beyond. It's available on Amazon.
Not all books on Excel are easy to read; this one is a good and readable introduction to the kinds of problems you've been given.
As I said, though, if you make a few stabs and find yourself up against it, by all means come back and post questions. It's just that the more you hang in and struggle with it, the more you'll actually be able to understand and explain it. Having somebody else do it for you is helpful in some ways, but not the best way to learn.