sorted

Hi, I wonder if someone can help me. I need to know how over due something is based on TODAY() from say column K but, to ignore this if, column R is populated. I've got the first bit sorted ok, it's the second part that I'm having trouble with. My formula is below, I cant work in the...

Hi Apologies if this is really straightforward but I just couldn't get my head around it. I have a range of random numbers in B2:D20. All values in column B are red, in column C are amber and in column D are green. When the random range is sorted into a single column A, how do I make sure...

I have a 1 column array of names sorted alphabetically. I want to find the first row for a name starting with a specific letter - ex., the row number containing the first name that starts with the letter "C". I've run in circles trying to accomplish this using Find, Search, Left, etc...

Hi I have a Custom List added to my Sort options. This contains 10 names of people that need to be at the top of the list. (Person A - Person J) That works fine with the list. BUT... The table contains also other names. (Person K - ...) And I don't want them to be sorted alphabetically -...

Hi guys, I want to insert 12 pictures into excel from cell A1 to A12 and lock them in place. So when I do a sort if the picture in A2 and the information beside is sorted to move to line 1 all the info plus the pic moves with it.

Dear MrExcel Team, I created the following table in the same worksheet as the original table (with the source data): <tbody> Region Country Event 1 Formulatext of Event1 LaCan COLOMBIA 3 =VLOOKUP(A6,A6:B26,2,0) EU ESTONIA 20 =VLOOKUP(A7,A7:B27,2,0) EU GERMANY 149 =VLOOKUP(A8,A8:B28,2,0)...

I want to create a command button that when clicked will sort by the "name" columns (F, H, J, L,...etc) The issue I am having is how to keep the corresponding column (I'll refer to as the "date" column) 'connected' to it after its sorted. So 'G' needs to stay with 'F', and 'I' needs to stay...

Hi all, I'm new to this forum and was looking for a vba code for my excel to auto sort data. Please read further for the description to my excel. My excel has 20 columns starting from A through T. Some of these are loading data from an external source and others are calculative. I have three...

Hello, I would like to extract a sorted unique list from Sheet 1 (column A) and Sheet 2 (Column A) onto Sheet 3 (Column A). Illustration is provided below. The only thing that is important is that the data on Sheet 1 and Sheet 2 are dynamic, meaning they expand or shrink based on the data feed...

I have a drop down list with numbers from 1 to 20 which I use in a form. The numbers when sorted appear like this: 13 14 15 1 2 3 4 I would like to change numbers 1 to 9 to 01, 02 etc so that numbers when sorted appear like this: 01 02 03 However i am afraid to edit the numbers in the drop...

Hi, I have a table and when I update it, it loses its "Sort largest to smallest", and I have to press the filter and then set the criteria again. I would like to avoid this and "keep" the table sorted by my first column that has the large and small numbers in it. Any idéa on how to keep a...

Hi all, I hope someone can help with this tricky one. My Excel Table "Tracker" is sorted using the values in column "Index", I have a column named "Status" which can have several values, one of them being "Cancelled". I want to sort my table so that the rows where the status is "Cancelled" are...

Hi, I have data in excel sheet in several columns (lists are flexible): <tbody> s1 s2 s3 s4 s5 s6 s7 s8 s9 s10 s11 s12 s13 s14 s15 s16 s17 s18 s19 s20 s21 s22 s23 tr1 iuhu1 e8zu9 uzsiu4 erd1 wef5 ew6 wefw7 wefe3 erg8 3wef3 efwe8 rge9 ef1 erf6 wdq5 ui9 fgr6 r4 reg4 erg3 ef6 ed4 tr2 iuhu2...

I downloaded some data into a spreadsheet from a website that I want sorted by date. The dates came in as "Mar-14-12" with the cells formatted as "General". I also got those little green triangle in the left hand corner which then tells me "This cell contains a date string represented with...

Hi, I have the following table sort code but im missing something. Column BC is sorted into the list below. HU100 HU101 HU64 HU66 NSN14 But it should be sorted like so. HU64 HU66 HU100 HU101 NSN14 Sub LOCKPICKINGINFO()' ' LOCKPICKINGINFO Macro ' ' Range("Table20").Select...

Hi guys! I have 6 users in seperate workbooks entering data into a form I created in excel. The form then pastes all of the values entered into a nice clean list (in their workbook) which includes text and numbers. I would like to have a master workbook which will allow me to see all of the...

I have a question about sorting in pivot tables. The pivot table shows the <tbody> Sum of ITEM_TOTAL_SALE Sum of TOTAL DISCOUNT AMOUNT Sum of Gross Margin </tbody> in the left columns is the Customer Code and Customer Name The table is sorted by ITEM_TOTAL_SALES with all SALES_REPS ( the...

I am looking for some help and I don't know if I can just use a formula or if I need a macro for this... I have a 2-column worksheet In Column A is a product Listing. In Column B is a number listing based on the alpha sort from column A People will be adding products into cell B2. How do I get...

Hi All - Struggling new VBA-er here! I have a sorted table that contains 8 columns of data. I want to have vba define a range (A-H) based on the eighth column which could either have a number (all sorted to the top) or a space (sorted at the bottom). I want to go on and make a pivot table...

Our accounting office has this certification being issued for a student and it fits into a short bond paper. All those records are in a single sheet only. Now, we need to save them as PDF but they must be sorted alphabetically using the last name of the student. I am out of ideas on how to do...