|
|
|
|
#1
04-20-2017, 09:28 AM
|
|||
|
|||
it's confidential and it's a pretty big file to change the content. I did try the formula in a small table of data and it works, but I'm working with close to 100,000 rows of data and for some reason it's not capturing the Max Value "1" in column D. 
|
|
| Tags |
| countifs, match/index, max |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Using IF Function where logical test is for range of values
|
guciolino | Excel | 10 | 02-13-2017 08:05 AM |
|
select a cluster of point from a range based on x and y values
|
sandcharles | Excel | 5 | 02-19-2015 06:15 AM |
| List Boxes with Values | winter4400 | Word | 5 | 02-19-2013 03:14 PM |
|
load list box from range in excel
|
Joe Patrick | Word VBA | 8 | 06-07-2011 09:31 AM |
|
comparing values from a range
|
struct | Excel | 1 | 04-01-2011 07:17 PM |
Windows 7 32bit 
Office 2013
Hybrid Mode