All Questions
40
questions
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 ...
- 111
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 ...
- 31
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...
...
- 113
0
votes
1
answer
4k
views
Sort & Ranking Functions in Excel for Time AND Number Values in one Column
I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...
- 11
0
votes
2
answers
381
views
How to sort columns in Excel so that only one value appears in each row?
Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...
- 13.9k
0
votes
3
answers
2k
views
Excel filter duplicate values in column A and filter out rows which have column C blank
How to filter duplicate values in column A and filter out rows which have column C blank.
I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next 800 rows are ...
- 15
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 ...
- 13
-5
votes
1
answer
4k
views
how do you ignore empty cells?
I'm using this function to rank data:
=SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1
This version assigns 1 to the highest value
and sequentially increasing ranks to ...
- 1
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?
- 219
0
votes
2
answers
27k
views
Is there a dynamic sorting feature in Excel 2007/2010?
I have a task list spreadsheet that I maintain. Each task is given a ranking based on number of days until due date, weighted by high, low, or medium priority. The ranking is automatically calculated, ...
- 1,799