tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
need some help please,
I have a list of values in column D anything up to 10000 rows, and a set of numbers in column J and the words "Large" "Small" or "Tiny" in column I,
The following array formula does exactly what I want, but I'm copying it down 10000 lines so its just not running,
basically what i'm trying to do is find the highest value of the data in D for the cells that match the number thats in column I,
I've done a small diagram to show the results I need,
I don't mind if this is a macro or formula , I just need a solution please.
<TBODY>
</TBODY>all the data will be together as you can see, but it could be any number of rows.
I hope someone can help me, been struggling with this all day!
Thanks
Tony
need some help please,
I have a list of values in column D anything up to 10000 rows, and a set of numbers in column J and the words "Large" "Small" or "Tiny" in column I,
The following array formula does exactly what I want, but I'm copying it down 10000 lines so its just not running,
Code:
=IF(I3="Large",MAX(IF($J$3:$J$10000=J3,$D$3:$D$10000)),"")
basically what i'm trying to do is find the highest value of the data in D for the cells that match the number thats in column I,
I've done a small diagram to show the results I need,
I don't mind if this is a macro or formula , I just need a solution please.
D | j | i | ||
Value | number | small / large/tiny | results I want is the highest number of all of them that say large but only within there number group. | |
3 | 40 | 2 | large | 50 |
4 | 30 | 2 | large | 50 |
5 | 50 | 2 | large | 50 |
6 | 20 | 2 | large | 50 |
7 | 50 | 3 | small | |
8 | 40 | 3 | small | |
9 | 20 | 3 | small | |
10 | 30 | 3 | small | |
11 | 40 | 4 | large | 60 |
12 | 50 | 4 | large | 60 |
13 | 60 | 4 | large | 60 |
14 | 20 | 4 | large | 60 |
15 | 20 | 5 | tiny | |
16 | 30 | 5 | tiny | |
17 | 20 | 5 | tiny | |
18 | 30 | 5 | tiny | |
19 | 40 | 6 | large | 40 |
20 | 20 | 6 | large | 40 |
21 | 30 | 6 | large | 40 |
<TBODY>
</TBODY>
I hope someone can help me, been struggling with this all day!
Thanks
Tony