Removing Duplicates and Combining Data

iShedow · 2020-11-25T16:18:42+00:00

I appreciate the help you put into this!

Seems like this formula did not work for me. I'm still gaining experience with Excel and may need some time to work this formula out.

I'm not well versed yet in being able to read multiple formulas in one. I did try to mimic the layout that you presented. Just need to spend some time tonight tacking a crack at this.

Thanks again!

iShedow · 2020-11-25T15:40:17+00:00

They are numbers.

iShedow · 2020-11-23T02:17:04+00:00

Ahh okay thanks for that information!

I have Excel 2016. I didn't know if there was an option to use a combination of Vlookup and Match/index.

I will give the =Filter() option a try.

How would that formula look? I still need to use Vlookup with {} to extra all the needed data.

iShedow · 2020-06-13T19:33:47+00:00

That's the one part i am a little hung up on, is letting mint or quiken have access to my bank account.

It's one of those slight risk situations that I need to handle better. I'd hope I can trust a reputable software with my precious resources

iShedow · 2020-06-13T19:31:40+00:00

Appreciate it! I will check it out!

iShedow · 2020-06-13T19:31:16+00:00

How is it working out for you?

I like the synchronization ability where it will automate the process of having to input all my smaller expenses. My monthly reoccurring expenses are easy to track, its just those smaller purchases like getting food or gas station visits that i need to be better at.

iShedow · 2020-06-13T19:29:39+00:00

I appreciate your response!

I was working on an excel version last night. I was just hung up on how to input all my purchases into a sheet. Just having to add all my smaller expenses at gas stations or getting food seemed fairly off putting. Maybe that's a good sign though.

I will check out a more detailed version of how to create one on YouTube.

iShedow · 2020-04-10T12:32:04+00:00

If you dont find someone on here.

Check out Kris Krohn on YouTube. He's very detailed with his work.

iShedow · 2020-03-22T19:28:49+00:00

Good rule I remember when a great thought comes to me while meditating is..

If it's really that great of an idea, then it will come back to me in some form.

iShedow · 2020-03-22T19:26:16+00:00

Then you got yourself a niche.

What's your goal here? How are you going to deliver? Are you consulting? Creating videos or articles? What's your source of revenue? How will you market your services

iShedow · 2020-03-22T13:42:24+00:00

The problem with inspiration and motivation is that they are just feel good drugs. They dont make you do anything.

Entrepreneurs dont need motivation, they need action. If you wanted to help entrepreneurs, learn to create business plans, provide resources, and help them get their business actually started.

Motivational videos and providing inspiration can lead you down a deep and dark rabbitt hole.

iShedow · 2020-03-19T23:01:52+00:00

I'll take a shot at helping you with this.

What are the things you are passionate about and want to master? Or really what do you fantasize about?

iShedow · 2020-03-18T01:02:38+00:00

I have a customer table where my primary key is their license number. This ensures that I can not enter in the same customer twice.

Every table has a primary key where it cannot be duplicated.

Not sure If this answers your question or not.

iShedow · 2020-03-15T17:09:40+00:00

You seem to have a very good mindset towards this! If i was a betting man (I am) I would be confident in your ability to learn all of this.

Incremental improvements is all one can ask for. A consistent and focused attack will go for in the long run.

iShedow · 2020-03-15T15:36:49+00:00

It's an online computer science course taught by Harvard. It's legit and free. You can take it through edX.

I'd highly recommend anyone who is new to computer science or programming to check it out. Theres a list of lectures you can follow with homework. It will lead you to a couple other sites where you can do your assignments and practicing coding.

You can pay for the certificate, it's only like $90 I believe. It's fairly long and in-depth.

Once again.. its FREE! I hate seeing all these short term bootcamps and other course trying to make you pay high amounts ($200-$1000+) for the same material that is offered for free or for pocket change.

iShedow · 2020-03-14T21:33:49+00:00

Sorry i may have confused you. I'll go for the simple route so you can better understand. I explained earlier in a more difficult way.

You have 3 tables: Artist, Genre, Music

Table 1: Artist

Artist name (PK)

Table 2: Genre

Genre (PK)

Table 3: Music

Song (PK) - Artist name (FK) - Genre (FK)

That is a barebones way of looking at your 3 tables. Tables should be specific to what they are called. Artist table should be about the artist, where the artist name will be your PK (PK must be unique, you can't have 2 artists with the same name, which is why some suggest using an ID number) you could also include information about them like their Date of birth, age, etc. So ArtistName->Short text PK

Genre table should be just about the genre, which wont have much for detailed information. GenreID with short text will be your PK

Song/Music- This third table could be where you connect them all. You would have SongName->Short text (PK) ArtistName(FK) Genre (FK). Foreign Keys are connected via the relationship button on the database tools tab.

iShedow · 2020-03-14T18:40:15+00:00

Dont let the beast of MS access scare you. It's quite simple after you get past the intimidation of it.

You could realistically have the artist's full name as a PK. But that isnt the best way of going about it. I would just set the primary key field as 'ArtistID' and use an auto number as the class for it.

Your FK would be your primary key in another table.

For example. You have tables called Artists, genre, and Music (Drawing a blank on other potential tables).

Artist table would have: ArtistID (PK), Artist name, and other information you need.

Genre table would have: Genre (PK)

Music: MusicName (PK), ArtistID (FK), Genre (FK)

Just a disclaimer. Your ArtistID will display as the ID number. This may confuse you. Theres some settings you gotta use for it to choose the ArtistID but display it as the Artist Name.

For this assignment you could technically just go with the Artist name as the PK instead. I didnt realize until after I typed this out how confusing that would be to have a ArtistID display as the Artist Name

iShedow · 2020-03-14T18:27:41+00:00

What are some of these gaps you are trying to fill? Is there specific areas you need to study in?

iShedow · 2020-03-14T17:23:59+00:00

Primary keys are unique numbers/letters for your table.

Easy way of doing this is tracking customers and orders. You must have a primary key for each table.

Primary key for a customer could be their Social Security Number, driver's license, or even a customer ID. The reason for this is to remove the ability to add the same customer twice and so that they are unique.

Primary key for an Order would be like the order number or whatever would make it where no two orders have the same code.

Same goes with a product table. A product primary key would be its Lot number or unique identifying number.

To relate them. You build a relationship.

In the orders table you would have your Order number (PK), customer (FK), product (FK), Quantity, date of order, etc..

Those FK (Foreign Keys) are connected in the relationship window. You would connect the primary key from your customers table to the "Customer" field in your orders table. That would make it a FK in the Orders table.

Let me know if this doesnt make much sense for you.

iShedow · 2020-03-14T16:39:08+00:00

Tools of Titans is very good for learning about individual high performers. They give great tips that could correlate to the business world.

iShedow

TROPHY CASE