Retrieve a set of values between two numbers

**skrispriya** · 02-23-2010, 05:47 AM

Hi

I have a row containing a set of values.
I have also min_val and max_val in another row.
I need to fetch values between min_val and max_val from first row using formula.

In short

1 2 3 4 5 6 7 8 9

2 7

Expected ans is 3 4 5 6

Thanks n advance

**D_Rennie** · 02-23-2010, 07:16 AM

hello,

you could try using the mid function.

=MID(A1, FIND(C1, A1), (FIND(D1, A1)-FIND(C1, A1)))

where C1 is the Min Value and D1 is the Max value

cheers

**martindwilson** · 02-23-2010, 10:11 AM

if numbers are unique then see attached "unique" if you want betweeen first instance and last instance see other sheet input in pink cells helper formulas in tan ,results in green
i could have combined some functions but it didnt seem worth it