wrong result Paste within same row while filtered condition applie

[Sherly]

senario
col A col B col c col D
P1 9 9 9
P2 1 9
P3 9 9


my steps apply in sequencial order
1) filtering the column B - selected only 9 (P1 & P3 was being sortlisted in
this case)

2) I copy the filtered ranges from P1 & P3, paste to col C "expected" to see
into same row P1 & P3 only (exclude P2 becaused it was not selected)

3)Result as the original p1 & p3 was copies into wrong row at P1 & p2 like
above col c

4) I am interested to have the result sample in col d
whereby original row of P1 & P3 paste into col D

appreciate have some tips for handling this

 

[Ms-Exl-Learner]

1) Your First Step is Ok that is Filtering the column B - selecting only 9
(P1 & P3 was being sortlisted in this case)

2) Don’t copy the P1 & P3 from A COLUMN Cell & paste it in C COLUMN when it
is in Filter. Do like this. Place the cursor in C COLUMN that is where the
FIRST 9 is present. Now press the EQUAL Key (=) and refer it in the A Column
P1 cell and press enter. Now copy the cell where you have applied the
formula and paste it to the next cell (i.e. In Second 9).

3) Now in D column do like you have previously done for C Column. That is
place the cursor in D column cell and press = and refer it to the A Column P1
Value Cell. Now copy that cell and paste it for the remaining cells.

4) Now remove the filter. Place the cursor in C Column and press
Cntrl+Spacebar. Now the total C column will be selected. Do Copy (Cntrl+C)
and Do right click and select Paste Special (Note that the Paste Special will
get enabled when the Copy (Cntrl+C) is done) and select VALUES and give ok.

Like this Place the cursor in D Column and press Cntrl+Spacebar. Now the
total D column will be selected. Do Copy (Cntrl+C) and Do right click and
select Paste Special (Note that the Paste Special will get enabled when the
Copy (Cntrl+C) is done) and select VALUES and give ok.

That's all.

Remember to Click Yes, if this post helps!