Pasting the sorted data of Auto filter

  • Thread starter Thread starter harvindersingh1
  • Start date Start date
H

harvindersingh1

I have some data written in 3 columns A B and C. Then I applie
Autofilter on this array. Than in column B I clicked on item
appearing ‘n’ no. of times(say) at different places in that column.
received the values against item X because of Auto filter. Now in tha
filtered array I apply a formula in column D to club the values o
column A and B (using function concatenate). Now I want those clubbe
values appearing in column D to be pasted in respective C column
 
Instead of typing the formula in column D, you can enter it into the
top-most visible cell in column C and then copy it down over the other
visible cells in column C - it will only apply to the visible cells, so
when you remove your filter you will have what you want.

Hope this helps.

Pete
 
Back
Top