All Questions
5 questions
0
votes
1
answer
63
views
Sorting and ordering two expense lists by a third list of categories using Excel 2016
I want to use Excel 2016 to sort two expense lists by a third list of categories.
The first catch is that I want to place the value in the same cell like the categoris list – It's not a simple sort, ...
- 147
-1
votes
1
answer
72
views
Can I change the default match method in Excel from "Less than" to "Exact match"?
By default, MS-Excel uses 1 - Less than as match method in functions like vlookup and match.
Apparently Excel assumes the data is sorted and if the value I am looking for is missing, the value just ...
- 245
1
vote
1
answer
125
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, ...
- 13
1
vote
1
answer
2k
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
0
votes
1
answer
205
views
Use Excel to select the most recent row from a CSV?
I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas.
I'm experimenting with Pivot Tables, and just now Rank and VLookup....
- 2,365