PDA

View Full Version : Search specific Numbers with Different criteria



Adeel
03-19-2020, 03:29 AM
Hello All
My search criteria will be =right(range,7) for B4 and B3 will be for =left(range,3)
If B3 is blank than all numbers will be show off in result column other than only specific code numbers will appears!
Xx, yy, zz will be always different (mean it cannot be similar) for column c & for column D results %, Xx, yy, zz these all will be different!

If I simply type in B4 any number than It will show all numbers in range A which are they have in it in
Below are examples actually what I am trying to achieve, my criteria can be different for search but code should work in all aspects.

% it will stand as any number, could be any 0 to 9
xx,yy,zz any same 2 numbers, could be any 00 to 99
xxx,yyy,zzz any same 3 numbers,could be any 000 to 999
xxxx,yyyy,zzzz any same 4 numbers,could be any 0000 to 9999
Below are some examples
%%%xxx% first three any digits than any 3 same digit than again any digit
xxxyyy% first 3 same digits than again 3 same digits than any digit
xyxyxy% like 121212% or 232323% or 454545% ect ect
%xyxyxy like %565656 or %787878 or %525252 ect ect
xy%xyxy 45%4545 or 94%9494 or 35%3535 ect ect
xxyyzz% first two two 3 pairs than any digit
%xxyyzz first any digit than 3 two two pairs
%7888xx first any digit than as mentioned than two same digits
%%%1213 first three any numers than as mentioned
%%%xyxz like %%%1016, %%%0203, %%%7879
abcabc% 123123% or 456456% or 789789%(last will be any)
%abcabc %567567 first will be any
please review wbk for more examples !
Regards

Adeel

Adeel
03-21-2020, 01:07 PM
Also posted here
https://chandoo.org/forum/threads/search-specific-numbers-with-different-criteria.43877/
Adeel

大灰狼1976
03-23-2020, 07:27 PM
Please refer to the attachment.

大灰狼1976
03-23-2020, 11:42 PM
Please refer to the attachment.
1234 ect is difficult, because there will be other real numbers in it.

Adeel
03-24-2020, 12:01 AM
Hi sir, my apology may i haven't described well as i am not English!

if b3 is blank than code only show results as per B4 criteria in column c and if i make B3 with some pre numbers than its will shows results according to B3 and b4 criteria
please see attached

thnx for your help sir

Adeel

大灰狼1976
03-24-2020, 01:00 AM
"i am not English" ==>me too.


Please refer to the attachment.

Adeel
03-24-2020, 01:21 AM
thank you so much sir for your precious time and help! you are super star & thnx for your patience

Adeel