how can i get data of spesifec cell

M

M.K

hi all

if i have the following coulma

file123 33 33 58
file124 23 34 36
file123.a 27 26 64
filees123 22 27 67
file345 23 44 36
file123 11 99 44


how i can make new sheet include the file which have 123 so result will be

file123 33 33 58
file123.a 27 26 64
filees123 22 27 67
file123 11 99 44

thank you
 
S

Scott

Assuming your original data is on Sheet1 from cell A1 to D6,

on the new sheet:
A1 =IF(ISERROR(FIND(123,Sheet1!A2)),"",Sheet1!A2)
B1 =IF($A1="","",Sheet1!B2)

Copy cell B1 and paste it on C1 and D1.
Then copy the entire row and paste it on next row(s).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top