I have a spreadsheet containing 45 different rows representing network lines, a column has line speeds (128,256, 512..) and another column has the maximum Kbps for that particular line for a particular day. I'm trying to retreive into a cell the maximum Kbps for a line speed. I know the large function gives me the maximum for a column. I've tried vlookup, match, sumif,countif and arrays however to no success. How do I find the largest value for all the 128 lines? I'm really stumped. %-)
Dan
Dan