All Questions
8
questions
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
0
votes
1
answer
107
views
Vlookup or index/match to match a value to the left side of the numbers in a column
I am trying to figure out a way of performing a vlookup for a given value. The value I am looking up in correct in its form (six character number). But the values in the column that i am trying to ...
0
votes
1
answer
230
views
Excel - Vlookup within Vlookup dependent on drop-down
Please bear with my explanation here - I want to be as clear as possible. I have about 8 different tables (different categories), which contain ranges that correspond to point values. I have been ...
0
votes
1
answer
93
views
Filter Out Values by Category into new Table with vlookup
I have the following data that contains a list of Agents and their respective Manager:
I need to filter out the agents by manager and put them into a new table for each Manager?
I tried with the ...
2
votes
1
answer
70
views
How can I lookup a value in a column for multiple rows?
I have a table with a column giving week number (1-52) in Column A, and I would like to get an average of all items listed in Column D of the same table. So every week is represented by 5 rows.
The ...
0
votes
0
answers
220
views
Matching two columns in Excel
I am having trouble getting excel to match two columns.
I have 3 columns in total, 1 is blank, 2 contains a list of companies and 3 contains another list of companies.
I want to match column 3 with ...
0
votes
1
answer
297
views
Using VLOOKUP across worksheets without referencing the original worksheet
I've got a workbook that runs a few macros to pull in copies of sheets from a number of other workbook. I'm trying to set up one file that users can copy to their project folders and then just use ...
6
votes
2
answers
9k
views
Range mapping in Excel
I have a column of data in Excel with numbers [0..100]. I need a new column, which maps these to a new set of values such that:
> 90 : 4
80-90 : 3
70-79 : 2
60-69 : 1
< 60 : 0
I attempted to do ...