If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i extract worksheet cells with the same contents?
Office Pro Microsoft Excel . I import three separate lists into one worksheet
and want to extract only cells with similar contents to a separate worksheet. |
#2
|
|||
|
|||
How do i extract worksheet cells with the same contents?
Define "similar".
If it is "the same" and those entries are in the same column, then you could use data -- autofilter on that column and copy the rows left in view to the other worksheet. "doncuba" wrote: Office Pro Microsoft Excel . I import three separate lists into one worksheet and want to extract only cells with similar contents to a separate worksheet. |
Thread Tools | |
Display Modes | |
|
|