I am running Windows 10, and I have many icons on my desktop. I would like to sort some of them (by name/date/etc), but when I Right click on my desktop and then do Sort By > Name all of the icons get rearranged. How can I only sort/mass rearrange selected icons? Answer Fences, a … Read more
I have an excel database with four columns (A, B, C, D). The fourth column (D) has integers. I want to know how to sort the data by summed groups of 30 from the data in D. For example this data: Four columns with the first three columns of unnecessary data and the fourth column … Read more
(There might be an answer to this question somewhere, but I can’t find it. Sometimes you don’t know how to ask a question in a search field. Sorry if I missed it.) I have a sheet that I update with new data every day and five or six columns that each have formulas to manipulate … Read more
I’m working on my webshop and I’ve found out there are many combinations I need to sort. I need to find all name duplicates and name them with the same ID number. I’m using a program called CSVed but any other program will do. All duplicates get the same ID code It does not matter … Read more
I want to switch the sorting from ascending to descending whenever the variable in a column of my dataset changes. An example to demonstrate the sorting I want is as follows. I tried adding another column to add an odd or even number and then sort ascending when even and descending when odd but donot … Read more
I have a list of 35k contacts, I need to sort unique after unique I demonstrated in this example how I want to sort contacts: I tried by removing duplicates then to copy unique and to go back to compare with original file, but that process takes time and it’s not easy. Answer On cell … Read more
I have an excel file with around 10.000 leads, categorized with Name, Email, Company name, Position, City, CheckedEmailAddress, Mail server Country Code, last one Mail server Country Code, there are 11 different Mail server Country Code, I need to take all 11 by 11 leads from all of them, that means 1 sheet 11 leads … Read more
I have a table where many columns are formulas that I don’t want users to overtype with values, so I have protected the sheet and unlocked the cells they are allowed to edit. However the user needs to be able to sort and filter the table. From what I have read I don’t think this … Read more
I have a MySQL table like this: id | num | name 1 | 102 | name 1 2 | 102 | name 2 3 | 102 | name 3 4 | 103 | name 4 5 | 103 | name 5 6 | 103 | name 6 7 | 103 | name 7 I … Read more
I want to filter if any of the H I J columns contain fields greater or equal to 10.0. I don’t want to use no Advanced filters because there are multiple tables across the way but I want to sort all of them. *I don’t think Advanced filter will work for me. Please help – … Read more
