# Sort and report Question

#### kohlhammond

##### New Member
 1 monday amount label 10 gas 20 lunch 35 food 78 insurance

<tbody>
</tbody>
Hello I am brand new to the forum and have a question I don't know anything about excel except that I know it is more powerful than what I am using it for. I am creating a budget and in this budget I have a group of cells that is 2 columns by 7 rows, it is used to represent a single days expenditures with the first row expressing the day I.E. (1 Monday) the next row separates the group of cells into a table with the first column being amount and the second column being label. Now the rest of the group of cells gives data. I.E. (10.00 gas, 20.00 lunch) I would like a formula that will take as its argument this table and tell me how many lunches there were with the total for every lunch that appeared. basically I have a table for the whole month and I want to sort through that table, and keep the data cells "amount" and "label" together and have them sorted by label. I would like this formula to populate a table in a new sheet with label specific data, I.E. I have a sheet labeled auto that will organize all related data "gas, insurance, oil change, ect." The formula must be able to take multiple label cells and sort them into tables in another sheet. something like sort((label column: "gas","insurance","oil")To auto!)

Any help from a excel guru would be nice thanks

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Smitty

##### Legend
Welcome to the Board!

You'll be much better off entering all of your transactions sequentially, like:

Date | Amount | Label

Then you can use a Pivot Table to summarize the data however you want. If you have Excel 2010+ you can use a Slicer on the Label field to quickly summarize it by any category.

The way you have it the records that you entered are technically orphans since there's no way to tie them to the day, so you'll be hard pressed to summarize anything.

HTH,

Replies
0
Views
709
Replies
0
Views
316
Replies
5
Views
164
Replies
1
Views
313
Replies
1
Views
468

1,195,994
Messages
6,012,751
Members
441,724
Latest member
Aalbid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back