ordering

Hello, I need to make a spreadsheet about exports by type of product for every year (rows=type of product, columns=year). Rows have to be ordered according to the latest year data, example: Product 2020 2021 Cars 3 5 Plastic 6 2 Silver 1 1 The problem is, whenever I have data for a...

Hi i need a macro please, please there is A and B column (word and meaning) under them there are two rows merged A and B (for sentence) so every word is with two other rows. i want to sort and ordering with column B word in 1-4-7-10-13-16-19... i need a macro to order with these 3 multiple...

Hi, Thank you for giving me the possibility of posting here my issue. I am a Surgeon, and I am doing a research project. My job is to perform a chart review and record patient's variables. Thus the structure of my excel files is pretty simple: patient identifier=rows and variables=columns. My...

Hi everyone, I appreciate you looking at my thread. I'm still new to this excel thing, and I've only just started getting my hands dirty with this program and it's quite addictive. Ok so now here's what I need to accomplish: I have a form where my Team Leaders order totes of product that we use...

Hi there, I have 2 sheets, one called 'Scraping List' and one called 'Initial List'. I need a formula that searches whether a name listed in Col B of 'Scraping List' matches any entry into the 'Initial List' names in Col E of that sheet. Every name on the 'Initial List' sheet has a...

Hi there, First of all, I'm sorry because I don't know if I can explain this in a understandable way (I don't know how to search for it). And maybe is not posible. I'll have a file with electoral results with this structure (simplified): Place 1 name | Voters | Blank votes | 1st party | votes...

Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...

Hi, I have data that looks like this: <tbody> A B C D 1 a b c d 2 g c d 3 h i d 4 d </tbody> and I need a formula to convert it to look like this: <tbody> A B C D 1 d c b a 2 d c g 3 d i h 4 d </tbody> (i.e. the order reversed, and the last values (as per...

Hi experts I have an userform, where under certain circumstances a label (lblA) might overlap 2 different labels. One label (the smaller one) appears below lblA as expected. The other larger label however is above lblAI have tried sending this label to the back but it makes no difference. I have...

Hello,<o:p></o:p> I’m trying to do a comparison so that two different sets of columns are duplicates/paired with duplicates in the Zip Codes.<o:p></o:p> So I want to change this:<o:p></o:p> <TBODY> State<o:p></o:p> Program Name<o:p></o:p> Grantee<o:p></o:p> City<o:p></o:p> Zip <o:p></o:p>...

I apologize for the title, but I really can't find a good way to way to describe what I want to do. I will do my best. Suppose cell A1 has a numeric value of 4. I want column B to have values 1, 1, 1, 1, 2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4, and so on, where each number is in a different cell...

Hello, I have an Excel file that has columns in random order. The order I would like to have them in is listed under 'MyArr.' The problem is that not all of the column names which are listed in 'MyArr' are in the file. They are also in random order. The macro below seems to be a good...

Hi There, I have an Excel 2007 table already ordered by one key (one of the table´s fields). I need to get in VBA the current order (Ascending or Descending) of the table. I've tried somethis like this: MsgBox ActiveWorkbook.Worksheets("MySheet").ListObjects("MyTable").Sort.SortField.Key...

I have a rather large database. One table contains Area Manager names, Divisions, and numerous statistics/totals. These statistics are labeled with the month from which they are from. I am trying to make a report that will show the top 25 managers, sorted by one column of statistics. A Third...

I have a database of employee information such as Level (e.g., associate, manager, senior manager, executive), Skills (e.g., accounting, marketing), Skill Proficiency (e.g., low, medium, high). I have created custom lists for Level and Skill Proficiency where, for example, an executive is ranked...

Hi, I figure this is easy, but I can't figure out how to do it ... I have a 2 columns list (10 rows or so). I would like to reorder the items in a separate list using a formula. (order based on 2nd colum) Let me know :) Thanks! Alex Original: Canada -- 4% USA --10% Germany...

I have a list of domain names ending in different country-extensions *domain1.org *domain2.net *domain3.com *domain4.co.uk *domain5.co.id *domain6.com *domain7.co.uk *domain8.co.id All these domains are in one column but I need to find a way to sort the according to their extension, with all...

I have a pivot table that has 5 columns They are currently arranged 31452 I would like them (and obviously the information in the columns) to be arranged 12345. Is there any way to do this (in the wizard, right clicking, advanced options, etc) The only way I can think of is to copy/Paste...