what formula could I use?

P

petevang

If I have a data from a1:g8 and I want to be able to copy a row of dat
to another location, if the row row contains data that meets a certia
criteria, what is the best formula to use? Is this possible. Thanks:
 
P

PowerWheels

I don't think a formula is what you are looking for, you could howeve
use the advanced filter within Excel. Try the Data/Filter/Advance
Filter menus
 
Top