Check If Numbers In Range (Dynamic Range)

Try this in E4:

=IF(MEDIAN(D4,LOOKUP(2,1/($E$3:E3=""),$D$3:D3),LOOKUP(2,1/($E$3:E3=""),$D$2:D2))=D4,1,"")

Thanks Phuocam for reply.

It works fast on small data but slow on large data (300k rows)

p/s : I have found the solution.

Example of solution:

Please Login or Register  to view this content.

Artik

@jolivanes, Sorry, I found the solution/code while search on Google, edit a few code lines and edit my data layout to make the code work.
I only have test the code on a few data, I afraid the solution/code is not true/working 100% for others.
I marked the post "SOLVED" so the experts not look at my post and instead spend their time to look for other post to solve.

This is the original code:

Please Login or Register  to view this content.

I change the code and my data layout to this:

Please Login or Register  to view this content.

Edited data layout : temp solution.xlsb

For the code, I add colum, remove a variable, remove a few line, rename variable,etc...(Not sure if it is correct but the code working as for now)
For the data, I add column B and C for max and min value from D column to match the 'edited code'.


@Artik

Thanks for the code, the code working on Data, attach on first post.
When I try it on the data that have decimal number, it is not working.
But when I change the decimal point to integers, the code is working. Example on Sheet3:

Change decimal number to integer : temp solution 2.xlsb

My bad for attach data example one first post not in decimal points.
My thought of attach data example in integers so that it is easier to understand the problem than decimal points.

your, all you need to do in my code is to change the declarations of the variables lMin and lMax from type Long to type Double and the code will work as you intended. The code does not require auxiliary columns, only the data in column D.

Artik

Thanks @Artik, the code is working 100%.