data sorting

I have read a million different web pages and lost myself down a thousand rabit holes and I am not sure this is even possible but what I am looking to do is sort data by ascending values in Column Y but keep duplicate values in Column A together. As a very crude example I would want the...

Hi Guys please help me with this, I need to sort this as per below criteria. ABC1Actual Data2Order IDProductsQty32018000499421D Capsules,C Cider Vinegar,AB Oil2,1,142018000486403D Capsules,C Cider Vinegar,AB Oil2,1,152018000499744S Xtreme Power - 1,C Cider Vinegar,D Capsules,AB...

Hello All, I've got a very large data set (setup layout below), which I am trying to sort without disrupting the adjacent column references... Column "A" has the headers, while columns B+ have successive months worth of data (e.g. Jan, Feb, Mar, etc), however, the data is being sourced from two...

I have the following data excel code that looks at a sheet of data and sorts the data based on a number and copies it to a new template sheet. A B C............ Line: 51106-02 AB ZONE 51106-02-904-601...

Hi all, My first time ever posting a question on a forum, but after using google for 2 days to find an answer I have given up on google. And after searching for best excel forum, MrExcel.com came out on top. I hope you can help me with your knowledge. I am trying to use countifs to sort data...

Hello, everyone! Every day, I use several reports that look like the table below (I can export as csv or xlsx.) I need to be able to pull data only from certain headers - specifically all 1900 and 3900 groups. (In my actual data, that will include 1901, 1902, 1903, etc.) But I need to exclude...

Hi, I have acquired two set of datasets with Time versus Data; T1 vs D1 and T2 vs D2 T1,T2 is timestamps in hh:mm:ss.00 and D1,D2 is data in Numbers format. T1 and T2 intervals are different, while the T1 has ~1second interval, T2 has ~100 millisecond interval. However the overall time period...

Hello EveryOne, I have three excel columns for A,B and C. The Data in all of three columns is dynamic which updates on basis of formulas in these columns. The data in column A is "number formating". 1) First I want to all of the data should be pasted as values in D,E and F...

Hello! I am trying to figure out a way to sort raw data into a desired format. This is the format of the raw data: <tbody> Raw Data Name Parameter Value A100 Temp 5 A100 Press 10 A100 Flow 15 B200 Temp 20 B200 Press 25 B200 Flow 30 C300 Temp 35 C300 Press 40 C300 Flow 45...

Hi Experts, I need your help. I am actually converting addresses into GPS coordinates "Longtitudes and Lattitudes". I am using a website where input around 200 addresses and they provide output in a csv. You can see the image below. The formating is little bad. All the data is good but they are...

I wrote a code that allows me to sort a long worksheet of data that consists of lists of objects that contain other objects onto individual worksheets based on the main objects name. The code works well but I am trying to simplify it. It is dependent on me knowing exactly what the object name is...

Dear All, I have large amount of data to sort and to assign id for database bulk upload. It is really hard to manually assign its own id for each data. So if anybody knows ,can you please tell me how to do this in excel. The data is shown as below <tbody> City State email website...

I have categories with certain info. Sometimes the info requires the category to be changed. Can this be done with a formula when I press the enter button?