Help with sheet

[Closed]
Report
Posts
2
Registration date
Sunday July 5, 2009
Status
Member
Last seen
July 5, 2009
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

i have an excel sheet whereby in column A i have a list of 10 things to do on a call. I want make list on a new sheet to display of all those things i missed for example

column A

greetes customer
took refrence
gave info
has built rapport

etc.

in column b i mark "y" if done, "x" if not done and "n/a" if not required.

i want on a new sheet a list of all those in column a that have x marked in column b

and i want them shown however many missed and not show. for example if in column b there was an "x" marked next to gave info, then i want the shet to show only "gave info" missed. and under that cell only show another that has missed


please help....very confused.....probably sounds like it by my explanation above too

ta

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.