Forum Discussion
Extract data using text within set of data
Don't understand why my simple solution shouldn't work. Used Patrick's file to illustrate how it works.
Hi Riny, i tried your solution, see above reply to flexyourdata. it didnt work. i hope i applied correctly.
Don't understand why my simple solution shouldn't work. Used Patrick's file to illustrate how it works.
Another thing this formula works for extracting the max value for the given substring. if i use min instead of max, it is returning 0 instead of the value 17 (among all SLS). But if there is a -ve value it returns that. Can you please also check for that. Thank you.
min should give value from cell E7=17 but is returning 0.
if theres a negative value(E8) in the range, min returns that.
Try this then (based on the data in the file I sent earlier):
=MIN(FILTER(F7:F5000,ISNUMBER(FIND($Q$5,C7:C5000))))
Hi Riny
Can you pls help me out here. in cell F2, i want the max out of ULS 1,2,3 (C2:C4) but its returning value from C5 based on the formula i have used. Can you pls suggest required correction in the formula. i'm afraid i'm unable to attach file in reply.
Thanks Riny for providing the solution.
I understood now how it works. i had applied the entire range of the columns (C:C, F:F) which is not correct. you applied C7:C5000 with F7:F5000; this works because the return reference starts from the numeric F7 cell. if you put any other ref F1 or F6 it wont work and the corresponding C column also need to start from exactly the same range, i.e. C7 for F7