Sorting Rows To Subcategory

Jul 31, 2014

I want to be able to download bank transactions in a csv file and have excel sort them according to rules I could define.

The csv file is organized as one transaction per row, with each row having several columns, one of which is a description that typically indicates the merchant.

I want excel to recognize a given merchant in the description cell, and then sort the associated row to be placed into a subcategory (linked to the given merchant) and then summed up.

For example,
a transaction with the description "Joe's Diner" would be sorted to Restaurants subcat
a transaction with the description "Dave's Supermarket" would be sorted to Groceries subcat
a transaction with an unrecognized description would be sorted to Misc subcat

View 2 Replies


ADVERTISEMENT

Pivot Table Grand Total SubCategory

Jun 12, 2008

I have a Pivot Table With 2 Row field:-

1st Column = Product - Apple and Orange
2nd column = Region - US and Europe

Now Pivot Table look like this

Apple - US: 100
Apple - Europe: 200

Orange - US 50
Orange - Europe 20

Total - 370

How to show instead of Total - 370
Show:-

Total - US 150
Total - Europe 220
Master Total - 370

?

View 9 Replies View Related

Sorting Many Rows At Once

Nov 14, 2008

I'm running Excel 2003 on Windows 2000. I'm working with a worksheet that is about 10,000 rows long and 25 columns wide. The first and second columns all have data in them, and the third through twenty fifth could have data. From row to row, if there is data present it will be in columns from left to right. By that I mean that if there is data in four columns of a particular row, it will always be in columns 1-4, not spread out throughout the 25 columns.

What I'm trying to do is sort the data in each row so that values ascend from left to right. Here's a very simple version of what the data looks like:

A B C D E F
1 a 6 3
2 b 5 9 2 8
3 c 6 5 2
4 d 9
5 e 3 9

When I'm done I would want the data to look like this:

A B C D E F
1 a 3 6
2 b 2 5 8 9
3 c 2 5 6
4 d 9
5 e 3 9

[url]

View 9 Replies View Related

Sorting Of Rows

Jun 4, 2009

how do I cut rows and paste into another sheet/file based on the values in a row.
For example in row A

A
1 123
2 123
3 123
4 333
5 333
6 444
7 333
8 444

I need to copy all the 123 into a sheet/file and the 333 into another sheet/file.

View 9 Replies View Related

Locking Rows Together When Sorting

Apr 30, 2009

I need to lock consecutive rows together before sorting. e.g. A1 contains a name and A2 is blank: B1 contains data related to name in A1 - so does B2, and so on. Therefore need to lock rows 1 and 2 together, then 3 and 4 together and so on, but sorting on the data in the first cell of the group e.g. A1

View 3 Replies View Related

Sorting Data Across Rows?

Jan 22, 2014

I've attached the spreadsheet I want to use. As you can see there are three sets of "bootcamper name" and "time" columns

I wanted to know how I can sort by name or time if I were fill in data that started from A7 and B7 all the way down to A43 and B43 then restarts at C7 and D7 all the way down to let's sat C30 and D30

If I wanted to list all the data alphabetically ( or by time ) from A7 and B7 all the way down to C30 and D30, how can I do that?

Terrible Tuesday.xlsx‎

View 5 Replies View Related

Sorting Where Rows Are Dynamic

Feb 27, 2014

Here is my code.

Currently I get a 1004 error. "Method of Range of Object _Global Failed" on "Range(Selection).Sort.SortFields.Clear"

Code:
Sub sortBacklog()
Dim appExcel As Excel.Application
Dim myWorkbook As Excel.Workbook
Dim myWorkSheet As Worksheet
Set appExcel = CreateObject("Excel.Application")
Set myWorkbook = appExcel.Workbooks.Open("C:Backlog.xls")
Set myWorkSheet = myWorkbook.Sheets(1)

[code]....

View 1 Replies View Related

Sorting Columns Instead Of Rows

Jan 14, 2009

I have some data that is 300 rows x 43 columns.

I'd like to sort the 43 colums by using some of the rows. Is this possible using normal excel?

Alternatively is there a simple way to sort the colums in VBA?

View 9 Replies View Related

Sort Rows Without Sorting

May 18, 2009

I have data being fed from an application where it's difficult to sort the rows into ascending order. So is there a way that VBA can sort them and produce a value according to the order?

For example, Column A contains 5 rows.
Row 1's value is 4
Row 2's value is 1
Row 3's value is 2
Row 4's value is 3
Row 5's value is 5

If I were to sort these into ascending order, I'd get 1, 2, 3, 4, 5 in Column A. But I can't sort the rows so I need code to tell me which is the lowest number (1), which is the second lowest number (2), etc.

The purpose of the code will be to put values in Column B according to what's found in Column A. For the the lowest number, 1, the value in the cell next to it in Column B would be "a". For number 2, it would be "b", etc.

View 9 Replies View Related

Keeping Blank Rows When Sorting

May 16, 2008

I have a spreadsheet that I want to keep the blank rows that seperate the data for asthetic reasons. Can I sort just the rows with data in them and still keep the blank rows where they are?

View 9 Replies View Related

Sorting Rows On Different Tabs By Date?

Oct 23, 2012

I have a excel doc that have multiple tabs (different clients) with information (task, date due, who's responsible, and client), and I want to have a master tab that lists all tasks on any tab put in order by date. Essentially so everyone in the office can quickly see what their most pressing task's are.

View 3 Replies View Related

Sorting By Columns But Keeping Rows Together?

May 23, 2013

I'm trying to sort by City first, then by Report #, but keeping the highlighted rows together. If I use the custom sort it will through my D2's at the bottom and not keep them with their city, report, and D1. How do I get them to stay together? I have attached my document example.

View 4 Replies View Related

Select Rows By Group For Sorting

Oct 29, 2009

I HAVE THIS CODE THAT SELECTS ALL THE ROWS THAT CONTAINS CORTAR IN "I" COLUMN

View 14 Replies View Related

Sorting While Preserving Relationships In Rows

Feb 19, 2010

can anyone help me on how to create a formula or a macro that will automatically sort while preserving the relationships in rows without having to press any button? I have attached a sample workbook. Basically column ABCD under row 8 to 15 contains manual inputed values. While column ABCD beginning from row 24 to 26 should contains the automated sorted preserved relationship values.

View 7 Replies View Related

Sorting With Multiple Rows Per Entry

Feb 24, 2006

I've come upon a problem with sorting that I don't know how to tackle... I have entries in a workbook that I want to sort by a transaction number, but each entry spans multiple rows. One "entry" might look like this, for example:

TransID PassengerName Ticket#
leg of travel: Departure Arrival
leg of travel: Departure Arrival

I need to be able to sort by TransID or PassengerName while keeping the "legs of travel" attached to the correct TransID/Ticket#.

View 17 Replies View Related

Sorting Rows Based On Columns

Jan 20, 2009

I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

I am using Excel 2007.

View 9 Replies View Related

Sorting Rows On Whether They Contain A Specific String

Sep 7, 2009

Lets say I have a 2 column sheet (A and B). And I want to sort on column B with all the rows that contain a given string, i.e. /g or Äåßôå.

Something like doing a find all but then being able to select/copy/cut etc those rows.

How can this be done?

View 11 Replies View Related

Inserting Blank Rows And Sorting

Nov 21, 2012

Below is just a part of my very long list of statement that I posted into column A, B and C of excel worksheet:

10
67.12
03-Oct-12

10
85.16
02-Oct-12

[Code] ........

Any formula or macro that can automatically change to below expectation such as inserting 3-blank rows, totaling and sorting the date.

10
85.16
2-Oct-12

10
67.12
3-Oct-12

[Code] .........

View 7 Replies View Related

Sorting Multiple Rows Horizontally?

Apr 11, 2013

I have over 300 rows with a username in the column A followed by 3 fields in the following columns B,C,D. I want to just sort all 300 rows alphabetically by column B,C,D.

Eg. Cormac, Santa, Atlas, Egg
After search Cormac, Altas, Egg, Santa.

how to do this easily in Excel without VB as I am not good as it.

View 6 Replies View Related

Sorting Rows By Comparing Cells ...

Mar 13, 2007

the system works by whoever has the most points wins.. i already have my formulas and everything done..

i want the excel program to move the entire row, if possible, by whoever has the most points to the top..

(i.e If ryan d. has the most points he will be is vince v.'s spot)

can this be done automatically in excel or do i have to do it by hand?

View 9 Replies View Related

Sorting In A Large Number Of Rows

Oct 29, 2007

I am trying to sort in rows, a large number of rows. I can do text to columns, delimit by colon, and sort individual rows. But I have spreadsheets that are 100s of rows long. Is there anyway to automate?

View 4 Replies View Related

Error When Sorting More Than 1400 Rows

Oct 12, 2008

I have a long list of records/rows. Each record has about 22 cells (columns).

Recently the number of records/rows exceeded 1400 and I started noticing that Excel no longer can sort my records correctly. I sort them according to the first column, which is called PRIORITY. And these values go from 0-2500 and more. But very often my list looks as follows

2500
2437
2355
102
108
107
2102
169
1982
1970

And so on.

The funny thing is if I sort less than 1400 entries, it does it right. Actually, the cutoff line is somewhere between 1410 and 1425. Usually below 1410 it will work fine, above 1425 it will not, and between 1410 and 1425 it is erratic.

View 9 Replies View Related

Display Multiple Rows & Sorting

May 2, 2006

Please ref attached spreadhseet.

1) Is it possible to hide all cols save D & E and also all blank rows in Col D

2) I would like to have an initial If statement saying stating that if the answer to the question in D2 is Y then don't display anything else other than the info in B2 & B3.

£) the sorting seems to have gone funny - not sure what I've done here, I'd like it sorted by phase (col A)

4) where there is a blank in the cell under a question (for example D3) - this means that the same question applies and that multiple docs should be returned (e.g for Q1 D2 docs 1 & 2 display, for qu D37 docs 36 - 39 display)

View 9 Replies View Related

Sorting Rows In Pivot Table

Jun 2, 2006

I have a pivot table and i am trying to display the rows in order of relevance. I have a bit of code that will sort the rows into the order I want them which I have included. My problem is that sometimes I will have rows that will not be there, If position 3 doesn't exist I would expect it to display 1,2,4,5 but instead I get an error message.

ActiveSheet.PivotTables("PivotTable11").PivotFields("Baan Order").PivotItems("Nomination") _
.Position = 1
ActiveSheet.PivotTables("PivotTable11").PivotFields("Baan Order").PivotItems("Full") _
.Position = 2
ActiveSheet.PivotTables("PivotTable11").PivotFields("Baan Order").PivotItems("Equal") _
.Position = 3
ActiveSheet.PivotTables("PivotTable11").PivotFields("Baan Order").PivotItems("Target") _
.Position = 4
ActiveSheet.PivotTables("PivotTable11").PivotFields("Baan Order").PivotItems("None") _
.Position = 5

View 2 Replies View Related

Sorting And Merging Data From Two Rows

Apr 26, 2007

I have two rows of data that I need in one row and then sorted, it is possible that the data will be difffering lengths depending on input conditions. I also need the option to sort it either ascending or descending. The data in the two separate rows depend on other parts of the system and in turn this data will be used in another part. So I need it sorted automatically. I have tried ranking the data and then sorting it by rank but for some reason this does not appear to be working.

View 9 Replies View Related

Sorting Rows With A Combination Of Text And Number?

Aug 3, 2013

I'm currently trying to make a sort macro that sorts a row of data that has a combination of numerical data and the text entry "N.A."

e.g.:

My field:
1
2
N.A
4
5
N.A
9

I want to sort the cells by descending value. But the result appears as:

My field:
N.A
N.A
9
5
4
2
1

But I want to numbers to appear first and have the "N.A."s to be after the number, since I have about 100 columns and some rows have like 30 N.A., which is pretty bad for usability if all that appears in the first screen are "N.A."

EDIT: by the way by ascending the data is fine since it orders by smallest number to largest and THEN the "N.A."

View 5 Replies View Related

Sorting Columns And Keep Information In Rows Intact

May 26, 2009

I am trying to sort/filter the information by columns but I need the information in each row to stay together for instance...

1 2 3 4 5
2 3 4 5 1
3 4 5 1 2
4 5 1 2 3
5 1 2 3 4

I need to sort the numbers in column 3 in ascending order or filter them but i need the entire row to move when sorted so it needs to look like this


4 5 1 2 3
5 1 2 3 4
1 2 3 4 5
2 3 4 5 1
3 4 5 1 2

I am using the list function to sort and filter the data in the columns but when i try to sort them in ascending order i get....

1 2 1 4 5
2 3 2 5 1
3 4 3 1 2
4 5 4 2 3
5 1 5 3 4

I don't know how to write formulas or VBA's or anything but am willing to try.

Is it possible to sort the data and get a result like the second set of data? and is there an easy way to make this fool proof so people that use the spreadsheet will not mess up the data?

View 8 Replies View Related

Sorting Non Unique Rows Of Data Into Another Worksheet

Jul 7, 2009

I have one worksheet which acts like a data dump (actuals) where data is just pasted in. This worksheet is sorted and edited on a continues basis. I need this data to be sorted into their respective coded worksheets (110, 120, 130).

I would like a function in Worksheet 110, 120, 130 that captures the data for that 'code'. Now the issue is that much of the data is non-unique, dates, codes, accounts may sometimes be duplicated however i still want to display the entries separately in their respective coded worksheets. (I had a solution using column numbers however it isn't viable because the data gets resorted often)....

View 14 Replies View Related

Sorting Rows Of Data Into Columns With Headings

Aug 30, 2013

I have hundreds of rows of data which I need to sort into headings in a new tab.

E.g Column D has about 40 names which occur many times. Column G has 4 digit numbers which are unique.

I want to create in a new tab a column for each of these 40 names, using that name as the heading and then list the 4 digit numbers unders that heading. So if the name name "John" appears 20 times in Column D, it will get a heading in the new sheet and there will be 20 unique numbers listed below it from the data in Column G.

View 3 Replies View Related

Advanced Sorting With Blank Rows In Columns?

Jun 10, 2014

I have been trying to sort an excel spreadsheet to no avail. I have read mutliple posts and searched online but I can not find a solution. This is what I have. I have three columns of data. column A is an account name. column b has some insurance coverage info and may have multiple rows that go with column A. Column C has the effective date of the coverages in column B. I want to sort column A in alphabetical order but when I have tried it does not keep column B and C together with column A.

Column A Column B Column C
company 1 General Liab 5/1/14-15
Workers Comp 2/1/13-14

company 2 workers comp 2/1/13-14

company 3 crime 5/5/14-15
D&O 5/5/14-15
Fee 4/15/14-15

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved