Hey guys,
I'm new here and have a good one. I'm trying to find a given value in an array, then return the column and row headers.
So, let's say I have a sheet with dates as colum headers, and states as row headers. I then want to look at the largest ten numbers from the array. So I do a LARGE, etc. to get those 10 numbers, but now I want to know where they are?
Ideas?
I'm new here and have a good one. I'm trying to find a given value in an array, then return the column and row headers.
So, let's say I have a sheet with dates as colum headers, and states as row headers. I then want to look at the largest ten numbers from the array. So I do a LARGE, etc. to get those 10 numbers, but now I want to know where they are?
Ideas?