All Questions
40
questions
0
votes
0
answers
49
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
1
vote
10
answers
177k
views
Excel will not sort all columns on my worksheet
I have a very basic worksheet with multiple columns and rows. I usually will sort one column to sort a-z and normally all data for those rows would follow the sort. Suddenly I am finding that if I ...
0
votes
0
answers
27
views
Sort information in Excel displayed in "cards" [duplicate]
I'm looking to create data "cards" in Excel which is a way to visually display information next to an image:
The reason to display information this way is because I want to always be able ...
0
votes
1
answer
261
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
1
vote
1
answer
120
views
How can I best reorder data in mixed row/column format into a simple table?
I have (from a CVS file) data in the following format:
The data is a continued list (row by row of comma separated values) where in arbitrary locations columns are inserted or removed. At these ...
1
vote
2
answers
523
views
Excel / LibreOffice Calc: find item in column with latest first occurrence?
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 ...
0
votes
2
answers
1k
views
Excel Sort Command not working AT ALL as expected
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 ...
0
votes
2
answers
73
views
Sorting Function in sheets or excel
How do I do a repeated function in excel?
I want the pattern to go: (Vertical)
=a1
=b1
=c1
=a2
=b2
=c2
=a3
=b3
=c3
and so on. this will go on for until:
=a400
=b400
=c400
Example in sheets
0
votes
0
answers
48
views
Matching 2 Data Set rows with similar column headings
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 ...
3
votes
1
answer
352
views
Sorting fomulas in an Excel table
For my project I need to arrange locations based on the lowest driving time to different locations. I simulated the driving distances (Row D, E & F), but the height depends on the products which ...
1
vote
1
answer
512
views
Counting and sorting a cell in excel
I need help to sort out a list of agencies. I have now gotten the frequency for each agency but I need them to match.
Then, I need to sort out this list from Largest to Smallest frequency. That means ...
0
votes
1
answer
11k
views
How to keep references unchanged after sorting
In the following spreadsheet, the references will change after sorting and break the calculations.
Absolute referencing is not an option. The table has to be copied periodically to another sheet and ...
0
votes
2
answers
693
views
Blank cells outside of Excel sort selection affecting sort order
I'm struggling to correct an issue in a data set where I am trying to sort rows by two different columns, but some rows contain a blank cell. I am sorting by State and then by Company; however, it ...
2
votes
3
answers
2k
views
Does excel provide a method for sorting columns based on numbers and phrases contained within one cell?
I receive a packet of data in the form of a .csv file from our database manager. I import this data into excel for formatting and sorting. However, one column contains three pieces of info that I want ...
0
votes
2
answers
35
views
How to number the data based 2 set of rules (Date and Type)?
I am creating a database where different numbers will be assigned to each row based on 2 parameters.
Date
Manager Name
As shown in the image based on the consultant and the date of booking, the ...