I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for...
Hi there. I've been struggling with a problem for almost a week now. I'm trying to assign a rank score to some data based on 3 criteria. The end result should be in a single cell (in fact, I'm using nested if statements to add different combinations, but this is the toughest one).
Criterion 1...
I'd like to use conditional formatting to shade a cell that contains, for example, "G8 Math 2". If it says, "G8 Math 3", I'd like it to be a different color. And, if it says, "G6 Math 2", yet another color. Some of my cells also contain additional text, such as a co-teacher's initials, and I...
<tbody>
A
B
C
D
E
AA
AB
AC
1
Invoices
2
Year
Remaining
Task
Funding
Invoice
Task
Fund
Amount
3
2017
3014.03
97
M
0
5
2015
6460.71
98
L6
60.71
98
L6
60.71
7
2018
580.28
99
F
0
100
A
5600.74
10
2019
6956.39
99
F
0
11
2017
5510.74
100
A
5510.74
13
2018
8737.52
100
A...
I am attempting to create a tool where I input a list of values (20-25 as I don't want the code to take forever) and then Excel does a search across multiple workbooks and for each value in the list and returns what workbook it is located in and where it is within that workbook.
On another page...
Hello everyone, I am stuck to find nth smallest value from a range of cells with multiple criteria. I have a formula to extract nth largest values but not being able to reverse that formula to get the nth smallest value.
The formula i'm using to extract nth largest value is as follows...
Hi guys,
Hopefully someone out there can help, cos this has me beat.
I need to keep a total of hours, for people working shifts that can be different lengths. I have a formula in place in the ‘Shift Start’ column that does this for the month...
Hi,
wonder if anyone can assist, I am trying to work out an average from multiple criteria that is in the same column.
I have criteria in column F and ratings from these in column H, but from the criteria I don't want to include certain elements.
I have made a range list of the elements and...
I have a spreadsheet where I'm trying to put together an IF statement which meets multiple criteria. Outline below:
Column B - Type - "Risk" or "Issue"
Column I - Probability - "1/2/3/4/5" (validated cell)
Column J - Impact - "1/2/3/4/5" (validated cell)
Column K - Rating - product of Column B...
I am trying to return a value (a date) based on 2 criteria.
Column A has a purchase order, column J has a part #, and column E has the date.
All columns have some repeating numbers, but the 2 criteria together makes it unique.
Because of the sheet layout I can't use vlookup so I would have...
Good day,
I am hoping someone can help me simplify a project to rank our sales force. We need to rank them by 4 criteria and each has a different weight. Here are the columns, criteria and weights:
<tbody>
<tbody>
Weight
0.4
0.2
0.25
0.15
Rep
% of Budget
% of PY
PY $ Change
Subjective...
Hi guys! I am having trouble figuring out how to do the following. Basically, I have a spreadsheet that I need to add controls to so the end user can re-sort the log based on how they want to see the data.
Rows 1:6 are headers
Print Range is A7:AG1525, but range will grow as new rows are...
I have a question on returning X customer's discount percentage Y, based on their Z spend amount.Ie: I have a list of 5000 customers, Various min and max spend and its corresponding discount. For customer John, i can locate John by index match among the list of customers. Then when at customer...
<colgroup><col><col><col><col></colgroup><tbody>
A
B
C
D
NAME
DOI
Dept
OSHA
John
3/8/2019
Grocery
Yes
Isa
3/19/2019
Perishable
No
Dave
3/24/2019
Grocery
No
Phil
3/25/2019
Perishable
No
Eric
3/26/2019
Perishable
Yes
Anne
3/28/2019
Grocery
Yes
Jack
4/1/2019
Perishable
Yes
</tbody>...
I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping.
I have two fields for...
Hi,
I have a table that looks like this:
<tbody>
Item
Class
Start
End
Item1
A
50
80
Item2
A
60
150
Item3
A
120
160
Item4
A
150
250
Item5
B
300
400
Item6
B
400
500
Item7
C
50
300
Item8
C
70
150
Item9
C
150
300
</tbody>
If my lookup looks like this:
<tbody>
Class...
Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula
<tbody>
MBR...
I'm trying to calculate standard deviation based on multiple criteria. I've used suggestions show on this site and on Google, but it keeps returning the SD of the entire list, not just those that match.
Here's the formula I'm using:
=STDEV.S(IF($C$2:$C$10=$L2,IF($E$2:$E$10=$M2,$H$2:$H$10)))...
I would like to use a formula to return a value based on multiple criteria from multiple tabs. I would also like the formula to be built in a way that it automatically updates if there are any changes to the criteria.
Example:
Three tabs in excel:
Tab # 1 - Complete Data Set
Column A has...
Hi all,
My first time ever posting a question on a forum, but after using google for 2 days to find an answer I have given up on google. And after searching for best excel forum, MrExcel.com came out on top. I hope you can help me with your knowledge.
I am trying to use countifs to sort data...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.