sorting data

https://skydrive.live.com/redir?resid=2B056BF5C3A60DD1%21207 I have a list of 3-letter codes in column A which are associated with dates in column B. This list contains dates for the entire year of 2014, and must be sorted by column A, alphabetically. On sheet 2 (titled Returns per Month)...

First Post - Hope I do this right....:) Currently we are using Dynamic Great Plains for our MRP system. I'm trying to make a report that shows a bunch of information and i'm having a very hard time sorting the data so i will try and list everything I have so far. We have a view that was...

OK here is my problem... I need to extract data from one main sheet to a couple of different sheets. That have been done by a excel genius for me. It work like a dream. All data is extracted as it should! See post...

I have two tables. The first table contains data which is referred to by a second table. I would like to sort the first table; however, when I do the references do not "follow" the data in the second table. Is there a way to do this, so that when I sort the first table the references in the...

I'm building an inventory report based upon a daily report downloaded from a website. The downloaded report changes from day-to-day. All of the data I need remains there, but the location of the columns changes, with the exception of "BOL". I need to sort all of this data in a macro. I have most...

Hello, I have data consisting of 20 numbers from 1 to 63. Within 20 some numbers can appear twice or even more. I want excel to sort this numbers in smallest to largest format ignoring repeating numbers. Thank you

In cell A1 if have a number 9921 i would like to know which formula i should use to extract the non duplicate digits in the number. the number would display in 2 in b1 and 1 in b2 sometime the number might have 3 duplicate digits example: 9991 but if the number has 2 sets of duplicate digits...

Hello, I'll make my problem short so any can help me out... I have data on a master sheet with all employees information. I have a second worksheet called "groups". Under the master sheet people are assigned group numbers.. I would like for my "groups" worksheet to copy only the...

on my sheet I am trying to make a drop down list for a date range. Now I would want my source data from sheet 'Weeks' and it would be filtered like so: 1st: in C5 a year would be selected in the weeks sheet, Weeks!B6:B41 is where the years are located (12 lines of each year - 2012,2013,2014)...

Hi Several weeks ago, you really helped me by recommending the following program to help me sort data in Excel 2007: <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

additional infor.. i broke it down to the rudimentary code, and still only two of the 4 work... Sub craptest() LastRow = Range("A65536").End(xlUp).Row For k = 1 To LastRow Step 1 If Cells(k, 19) = "Rewash" Then Cells(k, 26) = Cells(k, 19) Else If Cells(k, 19) = "Virgin" Then Cells(k, 26) =...

Hi, I have multiple columns and rows, of which two columns(Say column G & column H) have similar data(text) but in different order. The second column H has the right order and should remain as it is. Now, I want to sort rows for all columns from A to G(but not H), such that the resulting...

Hi all, I'm using a (probably very ugly) macro to sort columns in a worksheet, and I keep getting an error when it gets to column AQ. Has anyone else ever run into this? Is it a sort limit? Here's the line that's getting the error: ActiveWorkbook.Worksheets("Sheet6").Sort.SortFields.Add _...

How do I create names that will stick with my data even when I move it around? I have my data in a table, to make it easier to sort. It looks likes this: Project Value Timing Stage Confirmed(Y/N) Proj1 $100 3/15/11 Confirmed TRUE Proj2 $50 4/1/11...

...condense and sort a long list of suburbs and zip codes. I have a customer database with many repeats on zip codes and suburbs. I would like to condense it into a small list showing one of each suburb/zip code with a total number of customers for each area. Any suggestions on how to go about...

Dear Excel expert, I have a whole column filled with information like the following example: G1:0 G2:0 G3:0 G4:Amsterdam G5:0 G6:0 G7:0 G8:Groningen ... etc. The whole column is filled with zero's and citynames in fixed sequential order. I want to filter the Zero's out in a different column...

I have a page in excel that has sales information for multiple company's and they may reoccur several times on the page depending on how many times they purchase from us per month. each sale starts with the company's name and a 4 digit number to identify them and all the sales information is in...

Hi I was hoping someone could help me compare 4 columns of data. For my data I am just comparing the outputs of two programs (for example the x-y coordinates of a map). So in columns A & B I have the x-y coordinates from 1 program and columns C & D I have the x-y coordinates from another program...

Using Excel 2007 and Windows XP So I've programmed before in C, C++, Java, Python, but this VB stuff isn't clicking with me - I know what I want to do, but finding out how to do that from resources seems very difficult. If someone could help me with figuring out what commands I should be...

Hi all, i am new around here. I have what i think is a unique problem with excel. In column A i have thousands of student names and column B i have scores of these students for a test. Most students in column A have appeared twice and have got different scores, and hence their name appears...