## Excel newbie table question

Non-investing personal finance issues including insurance, credit, real estate, taxes, employment and legal issues such as trusts and wills
Topic Author
guppyguy
Posts: 57
Joined: Tue Jan 30, 2018 4:24 pm

### Excel newbie table question

Longtime Numbers user trying to learn Excel......

I have a table with 20 rows. Lets say that each row is an asset type, either "equity", "bond", or "toilet paper"...

I want to make 3 separate tables which mirror each of the asset types above individually. So there would be a table with only "equity" entries, for example.(Yes I know I can just filter the original table to only show one or more asset types at a time).

Is there a way to do this in Excel? Pivot tables maybe?
Posts: 1286
Joined: Thu Mar 03, 2011 7:20 am

### Re: Excel newbie table question

Pivot tables.

Master the pivot tables and you can do almost anything. (And Vlookup).
Topic Author
guppyguy
Posts: 57
Joined: Tue Jan 30, 2018 4:24 pm

### Re: Excel newbie table question

Thanks, I'll check it out!
pondering
Posts: 1095
Joined: Fri Jan 30, 2015 11:04 pm
Location: 412-977-3526, originally 718-273-2422

### Re: Excel newbie table question

I typically sort on the column. If I want separate sheets I create them.
--Robert Sterbal | 412-977-3526 call/text, I find speech easier than writing
MBB_Boy
Posts: 188
Joined: Sat May 12, 2018 4:09 pm

### Re: Excel newbie table question

Normchad wrote: Sat Sep 05, 2020 1:41 pm Pivot tables.

Master the pivot tables and you can do almost anything. (And Vlookup).
Boooo! Get that Vlookup out of here. Index match FTW!
Mudpuppy
Posts: 6445
Joined: Sat Aug 27, 2011 2:26 am
Location: Sunny California

### Re: Excel newbie table question

You can also do an array-based equation that will only return results that match your input string. But that's rather advanced Excel and if you're getting what you want from pivot tables, I'd say pivot tables are much easier to understand.
#Cruncher
Posts: 3052
Joined: Fri May 14, 2010 2:33 am
Location: New York City
Contact:

### Re: Excel newbie table question

guppyguy wrote: Sat Sep 05, 2020 1:39 pm(Yes I know I can just filter the original table to only show one or more asset types at a time.)
Besides Excel's filter display option, there is a new FILTER function available in some versions. It would seem to do what you want, guppyguy.
midareff
Posts: 7138
Joined: Mon Nov 29, 2010 10:43 am
Location: Biscayne Bay, South Florida

### Re: Excel newbie table question

Right click on any tab and then on Insert. Then insert worksheet. Label new worksheet with name desired and headers as appropriate for your needs.
Topic Author
guppyguy
Posts: 57
Joined: Tue Jan 30, 2018 4:24 pm

### Re: Excel newbie table question

So I spent an afternoon with pivot tables.....overkill for what I am after.

I just want a table with ALL of my investment positions by account then tables extracted from that consisting of either Equities or Bonds for allocation purposes. I think I like the FILTER recommendation above.

Side question....anybody know a way to lookup dividend yields in Excel? It is not part of the Stock function. Web query??