I have several rows of objects, each row with a specific date.
Currently, the spreadsheet is ordering the rows by date increasing, using the ROW function.
However, I need to introduce a new ordering ...
i noticed Windows Explorer and many apps like Winrar sort folders by name like this order:
but in some other apps like 7z and unlocker, i ...
In a Calc or Excel sheet I have a column with bunch of names. Each name can occur one or multiple times.
Each name has a 'first occurrence' i.e. the first row in which it appears.
I'm looking for an ...
I am trying to get a pivot table data set to sort dates in ascending order. The first step I took was to ensure the year was populated first. So, this is sorted by the year. However, the months are ...
I have a list of subnets for eg.
I would like to know how to link specific rows when sorting a table in excel. I have already made the table and in each row contains data for a specific person. Each person has two rows. My boss would ...
I created a custom sort list of fiscal weeks that I use for my reports in Excel. For many reports I also use them as a Slicer. I have come across the issue where this custom sort list works perfectly ...
So I've gone through a whole lot of sorting which isn't relevant to the question,
but for elaboration I'm getting 10 results out of 14. These results will be in order from 1-14 as I get them through ...
So the workflow I'm going for is saving the active webpage as .MHTML using a keystroke and make it go into a pre-set save location, so there's no interruption to browsing. I can easily get the .MHTML ...
I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways:
the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
(First post here, so forgive me if I get anything wrong.)
I'm an artist, so I have a lot of image folders, and a lot of images in those folders. I order them by date to avoid confusion, but whenever I ...
I have one folder where ALL downloads go. I want to open it via a desktop shortcut (win 10). In order to manage its content (delete/save/move/show etc.) I would like this folder (and only this one) to ...
I want to always display deleted items sorted by Date Deleted (I am using detailed view). But whenever I open Recycle Bin it auto sorts by Name. When I sort it by Date Deleted and close the window, ...
I have a file in the following format
222 aaaaa 2021-12-24
333fd bbb 2021-09-1
444 cc 2022-01-16
555 zzz 2021-08-21
6666 www 2021-09-5
777 yyy 2021-03-14
888 xxx 2021-11-27
999 ffffff 2021-12-4
I am ...
I am trying to do an offline comparison of two lists generated on two different systems. They both have GNU coreutils so to aid the diff'ing, I sort both lists using sort before transferring them.
Recently I started using Batocera, and I am collecting games. I found on my drive tons of amiga games, which in most cases are in multiple files e.g.
exile - ...
I have a list of items with set of properties. Some of the properties are unique, some are the same. I want to sort the properties through all items to see which items have equal properties.
I have a large table in which I want to sort as follows:
Sort by column F
If a value in column F is between 5000 and 6000, sort these rows by values in column B
If a value in column F is between 6000 ...
I use the sort by Date Modified a lot, but this is absolutely useless for folders as it always defaults to when the folder itself was created, not when new files are added to said folder. I need a way ...
I have two graphs that are based off of the same dataset. I had an issue with sorting the graph chronologically, so I sorted by a YearMonNum column. The data looks something like this:
I have a great deal of folders. Each contains more than 30 files. I’d like to sort these files in a custom order. How do I create a custom order and have it sorted out the files the way I want?
I was ...
I have 2 data sets A-Q (left) and U-AA (right)
I am trying to match the rows on the (right) U-AA with the rows on the (left) A-Q
Once a record on the right matches the first like record to the left ...