Hi everybody,
My issue is filter excel data in term of two variables, I would be highly appreciated for taking a look at my attachment and let me know how to filter simultaneously data for "E-value" and "Identity" columns (variables) so that just data (row) with "E-value" equal or less than 0.05 and "Identity" equal or greater than 50 is appeared. Thanks for your help and time
See attached workbook for the example.
You need to use the FILTER tool in the DATA menu.
Then you can add specific restriction for each column by clicking
on the little array that appears on the right of each title cells.
Hope this helps
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Many thanks for your prompt reply. Just one so basic question, could you please let me know if there is any way to count the excel row number instead of scrolling down and see row number?
N2=if(and(C2<=$R$1,F2>=$S$1),"yes","")
in which R1 holds 0.05
in which S1 holds 50
After that filter on column N.
In that case you are more flexible (just change the criteria in R1 or / and S1 and filter on yes).
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks a lot. Both solutions were great
you could also put this formula in cell T1 which does not need to filter the data:
It uses the limit values you have in cells R1 and S1.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks