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 ...
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 ...
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 ...
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 ...
0
votes
1
answer
406
views
Excel - Find unique values in one column and corresponding values from another
I have a database export of components and labels in two columns. Column A contains a component and column B contains the labels associated with the component. The same component can show up multiple ...
0
votes
2
answers
61
views
Fairly complex excel decision formula. Data processing
I am not sure where can I ask my question, but after a small research I decided to ask here:
If I had a question with Excel, which site would I use? [duplicate]
I have a question regarding the ...