Morning/Afternoon,
Can someone please help me in resolving this issue , i currently have a data capturing device set up that fills excel with the data, due to the size of the data area being captured , i use a separate sheet to quantify and categorise everything, then i pull the top 10 values from each sheet, i currently have the issue of if as shown on the picture i get duplicate values of say '10' the x-lookup will only return the first adjacent data , and never looks for the next data set that belongs to ten.
(Left image is correct return i'm looking for but i only get that through sort & Filter which due to the array of data being collected isn't good for me as i need to ideally automate the form with formulas)
(Centre image displays the formula used)
(Right image is the current return from my formula)
Can anyone please help as i would be really grateful , If someone knows how to return blanks on the zeros within the same formula that's pulling large that would be ideal also, thanks for taking the time to read Guys & Girls.
Can someone please help me in resolving this issue , i currently have a data capturing device set up that fills excel with the data, due to the size of the data area being captured , i use a separate sheet to quantify and categorise everything, then i pull the top 10 values from each sheet, i currently have the issue of if as shown on the picture i get duplicate values of say '10' the x-lookup will only return the first adjacent data , and never looks for the next data set that belongs to ten.
(Left image is correct return i'm looking for but i only get that through sort & Filter which due to the array of data being collected isn't good for me as i need to ideally automate the form with formulas)
(Centre image displays the formula used)
(Right image is the current return from my formula)
Can anyone please help as i would be really grateful , If someone knows how to return blanks on the zeros within the same formula that's pulling large that would be ideal also, thanks for taking the time to read Guys & Girls.