Help with sheet
Closed
kab0102
Posts
2
Registration date
Sunday July 5, 2009
Status
Member
Last seen
July 5, 2009
-
Jul 5, 2009 at 07:07 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 5, 2009 at 08:37 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 5, 2009 at 08:37 PM
Related:
- Help with sheet
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- Windows network commands cheat sheet - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 5, 2009 at 08:37 PM
Jul 5, 2009 at 08:37 PM
suppose your data is like this in sheet A1 down
task done?
a x
s y
d x
f x
g y
h n/a
j y
the column headings are necessary for this.
highlight any cell in this data range, click data(menu)-filter-autofiler
you will get arrows at the column headings.
click the arrow in column B and choose y
you will get only the rows which has y in column B
highlight this filtered data ONLY COLUMN A, click control+C and go to sheet 2 A1 and click control+v.
now go back to sheet 1 and click data-filter autofilter. the original data is recovered in sheest 1.
task done?
a x
s y
d x
f x
g y
h n/a
j y
the column headings are necessary for this.
highlight any cell in this data range, click data(menu)-filter-autofiler
you will get arrows at the column headings.
click the arrow in column B and choose y
you will get only the rows which has y in column B
highlight this filtered data ONLY COLUMN A, click control+C and go to sheet 2 A1 and click control+v.
now go back to sheet 1 and click data-filter autofilter. the original data is recovered in sheest 1.