Search results

uploading the file should make it easier to see

I'm trying to sort this data so that Q ends up in descending order. Currently you can see it's not at AY521. skusku1QP AF121C60AF121C60 AK18025AK1802569 AK18025128.5 AK18025248 AK18025367.25 AB411FIRAB411FIR354 AB411FIR652 AB411FIR1250 AB411FIR2448 AE120AUSAE120AUS360 AE120AUS656.25...

I'm using a macro to transpose some data in excel. Attached is an example of the file. As you can see in it when you get to the last item in the ex the 3rd column is not sorted correctly. So I tried sorting the file before running the macro doing the sort on the first 3 columns in order to...

I will give it a shot....thanks guys

I'm trying to modify a macro for transposing some data and it's not working. Here is the original macro: Sub TransposeQandP() Dim X As Long, Ar As Range With Range("A1:A" & Cells(Rows.Count, "B").End(xlUp).Row).SpecialCells(xlBlanks) For Each Ar In .Areas For X = 1 To Ar.Count Ar(1).Offset(-1...

that's not feasible when it has years and years of information in it

so the sales comp for each month needs to be sorted independently of the other months...not sure if the spreadsheet needs to be set up slightly different

I need to sort two separate columns at the same time and where each should yield different results...

Is there a way to do multiple independent sorts at the same time on the same sheet? I have data for multiple months in the same sheet and want to be able to sort them all at the same time but each sort should be independent of the others since they will all not have the same sales data in them.

never mind....was able to get help with a macro to do what I needed

uploaded the file...hopefully someone can help me

I want it to go to a new row at each change in Itm

Itm Itm All Q P AK18025 AK18025 6 9 AK18025 12 8.5 AK18025 24 8 AK18025 36 7.25 AB411FIR AB411FIR 3 54 AB411FIR 6 52 AB411FIR 12 50 AB411FIR 24 48 AE120AUS AE120AUS 3 60 AE120AUS 6 56.25 AE120AUS 12 53.13 AE120AUS 24 50 AY521 AY521 3 169.75 AY521 6 162.5 AY521 9 159 AY521 15 156 AY522 AY522 3...

What would be the best solution to format this information horizontally? ItmItm AllQP AK18025AK1802569 AK18025128.5 AK18025248 AK18025367.25 AB411FIRAB411FIR354 AB411FIR652 AB411FIR1250 AB411FIR2448 AE120AUSAE120AUS360 AE120AUS656.25 AE120AUS1253.13 AE120AUS2450 AY521AY5213169.75 AY5216162.5...

never mind....text to columns duhhh

the seperater was suppose to be : character

I'm trying to use the MID function on a string to be able to put all sections of data but the problem is that the starting point on each section throughout the document can be in different places and I want to be able to use a FIND within the MID to look for an occurrence of each separater(:) to...

i got it now...nevermind

on excel 2010. trying to run an index match but if it can't return a value I want the field to be blank instead of coming back as #N/A. my formula is: =INDEX(Sheet2!$A$2:$A$17746, MATCH(Sheet1!V2,Sheet2!$B$2:$B$17746,0)) please help

anyone with an idea of how this could be done?

right....but how can I set it up so that the user can select and months he or shes wishes and be able to then take those sales data and compare that to the entire year those months occur in to see the percentage of sales those months had for the year

I have a pivot table with sales data and it has the month that the order occurred in along with customer information. I'm trying to see if there is a way to make a pivot table so that I could select multiple months(lets say jan and feb for 2013 and 2014) where orders occurred in and see what...

right but the problem is that the number that needs to be formatted that way ends up in the middle of a string of other numbers and information

in excel I have a number 13.9500 where I need those 4 decimal places. When I put that number into a formula to add other information onto it that I need it loses to 2 zeros at the end but I need 4 decimal places. Is there a way to fix that?

got it...when I was switching between sheets it was adding that sheet to the formula opps