sorts

I am familiar with using Custom Sorts for secondary sorts in tables. However, I was wondering if there is an easier way. Generally, one can simply click on the drop down arrow in a column header while holding the control key to designate it as a secondary sort, but that doesn't seem to work in...

Hi, I am trying to find a text in a row, A9:AP9 where this value is: id: "bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b" I then want to take the value between the " (speech marks) and return it to another cell, so I would have bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b Is this possible? I have tried all...

Should be pretty simple stuff, but I have run out of possibilities. The code sorts data in Column I, first in an ascending order, then allows me to print the results, then resorts in descending order by Column A, putting it back to its original order. Here is the code <code> Private Sub...

Hi, Is there a way to modify the way Excel sorts cells? This "A to Z" or "Z to A" algorithm is faulty as hell and apparently hasn't been updated since the dawn of time. It constantly sorts words in many languages in a horribly wrong order. Is it possible to create custom sorting routines...

https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...

Hi guys, Im looking for a little help with my spreadsheet. What im trying to do is a sort using row K largest to smallest then row I largest to smallest, however, the selection of rows is different each time I do the sort. I tried to record a macro after highlighting my selection but it just...

Hello this code sorts B automatically from B2 downwards when a change is made. How would I alter the code so that it only sorts B3 and down, so B1 the title of the column and B2 are constant. Tried a few alterations to the below without any success. Thanks. Private Sub Worksheet_Change(ByVal...

Hello, I would like to be able to sort a priority list using VBA. I would like to sort first by priority override, simple number sort that trumps anything else. Next I would like to do a "combination" sort. First sort on absolute need date, then on priority: high, medium, low. Then I would...

Hi, very new to this so please be gentle. Im trying to make a round robin draw for my local league. 20 players to play each other 3 times, `Ive searched the web and tried all sorts of different things to no avail, please if any help is available would much appreciate it.

I would think this has such an easy solution but I have been to Mars and back and still have no solution. I am attempting to copy the text from a TextBox1 into the Windows10 copy buffer by using a command button. I've used all sorts of suggested code and shortcuts. Any suggestions that don't...

Morning all Data, as follows: A - list of dates B - list of names C&D - list of £ amounts E - list of figures between 0 & 4 F - list of dates: 01/11/16, 01/12/16, 01/01/17 etc I need a formula that: > pulls out all dates from A within a month of the date in F > sorts by the names in B > sorts...

I am using Access to analyze data in a very large real estate database. In the reports that I generate, I like to sort the properties by location. The fields I use are: [ACCOUNT_NUMBER] Key field [SITUS_STREETNAME] Name of the street, i.e., MAIN ST, UNION AVE, 1st ST, etc. On vacant land...