Data Selection [Closed]

Report
Posts
2
Registration date
Wednesday October 15, 2014
Status
Member
Last seen
October 31, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
I am looking for a macro or formula in excel to select some information according to the same criteria:
eg. from this table
A 3.32 10 12 pass
B 3.43 01 03 out of tolerance
C 3.18 04 01 out of tolerance
D 3.26 02 01 out of tolerance
E 3.14 11 16 pass

I would like to get a table show all information of the point which out of tolerance

out of tolerance B 3.43 01 03
out of tolerance C 3.18 04 01
out of tolerance D 3.26 02 01

Thanks in advance for your answer!

Boffo

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
autofiler according to column E criteria being "out of tolerance"


if necessary copy FILTERED data to another sheet and remove filter from original data

will this satisfy you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Wednesday October 15, 2014
Status
Member
Last seen
October 31, 2014

Thanks for your answer.

Actually, I have two columns show the result is pass or out of tolerance, such as,
Pt CH Hz. V. Hz. result V. result
A 3.32 10 12 pass pass
B 3.43 01 03 out of tolerance out of tolerance
C 3.18 04 01 out of tolerance pass
D 3.26 02 01 out of tolerance out of tolerance
E 3.14 11 16 pass out of tolerance

but I have a lot of data in a speadsheet and I only want to pick the data which out of tolerance (no matter Hz. result or V. result). If I use autofilter and copy to another sheet, some data maybe duplicated, I need to take much time to remove duplicated data.

So I'm looking for a way which can only pick the data I need in one time, can I do that in Excel?

Thanks in advance for your answer.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
not clar

autofiler picks up data you want -see excel help on "autofilter"

you can just copy filtered data to another location by one stroke

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!