All Questions
40
questions
4
votes
3
answers
18k
views
Excel: searching for a maximum lower than X
From the sorted list of values, I'm looking for a maximum that is lower than X
Example:
A B C
1 1 X=7
2 3
3 5
4 8 ANS=5
Do you have any smart ideas for this problem?
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 ...
3
votes
2
answers
410
views
How can you set up several sorting rules in Excel to sort a column?
I got a list of mail addresses, let's say we have the list
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
...
3
votes
1
answer
144
views
Varying Format Part Number Sort Issue
(Current Sort Sample:)
2-1203-4
2-1206-3
2CM-
3-1610-1
3-999
…
AR3021-A-7802
AR3021-A-7802-1
B43570-
B43570-3
I am working on an 8000+ record parts list. The challenge I am running into is that ...
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 ...
2
votes
3
answers
1k
views
I need an excel formula to tell how many numbers and alphabets are in a cell
Hey Guys I need help sorting series of plate numbers out on excel.
so I have a sample BMA759JA, and I need a formula that tells me how many Alphabets are contained in the cell and how many numbers ...
2
votes
3
answers
2k
views
Sorting data without mixing rows
I have three sheets. First sheet renamed General:
Dave Henderson 21/05/2014
Elton Rus 22/06/2014
John Smith 20/05/2015
Second sheet renamed Licence:...
2
votes
1
answer
197
views
How do I duplicate column data and preserve row relationships across worksheets?
I have a large amount of data on one worksheet, and would like to split it between two separate linked worksheets.
Assume I have these columns on my first worksheet (Worksheet A):
Apple | Red
...
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 ...
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 ...
1
vote
2
answers
5k
views
Excel compare cells in columns A and B, show in column C cells only unique to column A
I know there's a formula for this in Excel but I can't get it right.
I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A ...
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
1
answer
113
views
How can I match values based on criteria?
I have two tables with various columns in an Excel sheet. In these two tables I have two columns (one per table) in which I have some alphanumeric values.
For example,
table 1 col A:NAMES: AB34092, ...
1
vote
1
answer
1k
views
Excel Sort and Lookup Values Formula
I am trying to create some sort formulas on excel.
An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...
1
vote
2
answers
8k
views
Sort Excel Row Based on Values in Another Row
Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do.
I have a lot of spreadsheets where I have something like:
A|B|C|D|E|F...
...