sorting

<tbody> F G H I J 8 -8 123 -8 7 3 -8 6 -8 -5 -4 5 132 -2 -3 131 5 -8 4 999 </tbody> Dear all, I’ve been struggling with the ending of my ratherlarge macro converting information out of our Financial bookkeeping system. Little bit of context...

Hello, I need to create quite a complex macro and so far I was pretty much unsuccessful. In the first sheet I have those data (the real sheet has about 4000 rows): <tbody> P-Number Note Code n/a number n/a number Value 00315678001 O9873 23037 00345989001 O9873 14535...

when sorting a table e.g. A-Z or Z-A, the first cell does not change like the rest. Why is this?

This one's driving me nuts. I have code to sort the active sheet of an xlsm file. Below is the code: With ActiveSheet.Sort .SortFields.AddKey:=Range("A2:A75000"), Order:=xlAscending .SortFields.AddKey:=Range("B2:B750000"), Order:=xlAscending...

I have a date in column A formatted as 1/10/2017. I am using concatenate(Year(a2),"-",Month(a2)) and it returns 2017-1. I need the month to show as 2 digits for sorting. how can I get it to return 2017-01 or if month is October, 2017-10.

hi, i have a daily total players list, i wanted to make a list and chart, which has number of average players by weekdays (rightside of the picture) in descending order. i used AVERAGE(IF(WEEKDAY($V$4:$V$34)=6;($X$4:$X$34))) and ctrl shift+enter ; but is give a ˝value˝ error, when any cell...

Hi Everyone, In a formatting step of a larger macro, I am trying to select a variable number of rows beginning with cell C9:J, and then sort alphabetically. Below is what I have written, but it doesn't seem to be working so far (no errors given though). Dim LRowC As Long LRowC =...

Hi, The below macro does not help me to sort data. Can someone help me in to sort the data through macro or correct the below coding and help me to identify what the mistake is. Sub sorting() ' Sorting Macro 'CODING TO CHECK THE NETTING UPLOADED MsgBox "open Netting uploaded...

Hi, I need to sort column A, but not like 'smallest', or 'largest'. I don't know how to explain, but please look at the below table. It's sorting like first number. <tbody> Area 1 297 2 2973 3 29734 4 29735 5 2974 6 29741 7 3 8 34 9 3401 </tbody> I want to sort like this...

Hello all. I am trying to reference in a new Tab a list of all the items that hae an "X" against them I.E. A B <tbody> Cats X Dogs Parrots X Shrimp Pandas X </tbody> instead of...

Can someone help me figure out the code for grouping 2 columns together before sorting by columns? example data: where columns A & B need to be grouped together, C & D together, E & F together, etc... When the sort is done it is only to sort by the name column (first column in each group of...

Sorting a pivot table A-Z keeps giving me Bad Debt Bank Charges Depreciation Dues & Fees Tax-Real Estate Advertising Employee Benefits Insurance Everything after Insurance is sorting properly. If I copy and paste the values outside of the pivot table and sort A-Z it sorts correctly. Any idea...

I never knew this was possible, but i came across a dashboard where input is magically simplified because other tables when refreshed, "fetch" specific data wich was inserted on the main table. It's not formulas or anything, lemme tell how it works so someone can explain me how to reproduce it...

I have a long list of contact information that I'd like to sort by ones that have a phone number in the name column. An example: Bob Johnson Joe WALMART John Smith 555-555-5555 There are numerous entries but I'm trying to sort a column so I can group the entries that have a phone number like...

Hi All, I've a query regarding sorting columns via headers in few sheets of one workbook. The data to sheets 2 + will be copied daily but with same columns (in different order). I've a workbook with few sheets full of data, and all have same columns in different order (for example column C...

I have created a table in excel with column name Month and data in Month column like Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar When i am using slicer its sorting it aToZ or zToa, but i need same like in Month Column Any Solution

Dears, I want to sort the cells A to Z , but the cells does not contain any datas presently. If datas are coming through another program into this excel, then the excel will be automatically converted to pdf with sorting the values. Is any body can help how to sort the empty cells A to Z in excel.

Hello, I would like to make the custom sort I have set "reapply" when I open, cloese, or save (any will work) the workbook. I currently need to click "reapply" in the sort menu to sort the data, but this spreadsheet will be used by everyone in the office eventually, so I would really like to...

Hi everyone. I have a worksheet with work shifts that take up 4 columns per day with Start, End, Shift number & Duration. Sun in C-F sorting by E. Mon in G-J sorting by I Tue in K-N sorting by M Wed in O-R sorting by Q Thu in S-V sorting by U Fri in W-Z sorting by Y Sat in AA-AD sorting by AC...

Hi there, I would like to help out some of our sorting guys at our company. We receive parts with barcodes and sometimes without. They are car parts from junkyards. I want to make the sorting process better since things get incorrectly identified and I end up re sorting them. I bought a...