Web Development

Ask something
Discussion Locked

Excel move selected contents to another

0 helpful
8 replies

by hurdk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using Excel
I have data field contents in column 1
I perform a search for a spcific value in column 1
If the value is found I need to move that value to another column

8 replies

by dklippert

Do you need to move the value (erase it from one location and put it elsewhere) or have that value appear in another column (leaving the original).

by rlh1

I PUT IN COLUMN A ROWS 1-7 THE VALUES 1-7.
THEN IN COLUMN B PUT =IF(A1>4,A1,0) AND COPY IT DOWN. THIS MAY NOT BE EXACTLY WHAT YOUR LOOKING FOR, BUT IT WORKS.

This discussion is closed to new replies.