Data Selection
Closed
Boffo
Posts
2
Registration date
Wednesday October 15, 2014
Status
Member
Last seen
October 31, 2014
-
Oct 15, 2014 at 09:12 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 01:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2014 at 01:47 AM
Related:
- Data Selection
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
- Spectrum data usage - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 16, 2014 at 01:03 AM
Oct 16, 2014 at 01:03 AM
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
if necessary copy FILTERED data to another sheet and remove filter from original data
will this satisfy you
Boffo
Posts
2
Registration date
Wednesday October 15, 2014
Status
Member
Last seen
October 31, 2014
Oct 31, 2014 at 10:26 PM
Oct 31, 2014 at 10:26 PM
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.
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.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 1, 2014 at 01:47 AM
Nov 1, 2014 at 01:47 AM
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
autofiler picks up data you want -see excel help on "autofilter"
you can just copy filtered data to another location by one stroke
