Excel functions help

Hi Sothear!

In all cases the formula you want goes in you "TO column.

So the first requirement involves a formula in column P

Example of column P formula
=IF(J1="A",F1,"")

Second:
Example of column N formula
=IF(J1="O",F1,"")

Third:
Example of column M formula
=IF(J1="P",F1,"")

I've assumed that where the conditions are not met you want to return
a "" (making the cell *look" empty)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Sothear" wrote in message
...
I'd like to achive an excel functions of the following scenario:

Column F (value), Column J (Code) A,O,and P, Column M, Column N,
Column P

- If Column J with code "A", return value in column "F" TO column
"P"
- If column J with code "O", return value in column "F" TO column
"N"
- If column J with code "P", return value in column "F" TO column
"M"

Thanks
Sothear

Sothear,

You should use three functions to do that:
In P1 place =IF(J1="A",F1,"")
In N1 place =IF(J1="O",F1,"")
In M1 place =IF(J1="P",F1,"")

Then copy down the three formulas as far as you got data in columns F and J.

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl

"Sothear" schreef in bericht
...
I'd like to achive an excel functions of the following scenario:

Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P

- If Column J with code "A", return value in column "F" TO column "P"
- If column J with code "O", return value in column "F" TO column "N"
- If column J with code "P", return value in column "F" TO column "M"

Thanks
Sothear

Hello Norman,

Additional help...

I'd like to able to type in code: A or O or P in column J, and value in column F would shift to each destination column automatically?

Thanks
Sothear

----- Norman Harker wrote: -----

Hi Sothear!

In all cases the formula you want goes in you "TO column.

So the first requirement involves a formula in column P

Example of column P formula
=IF(J1="A",F1,"")

Second:
Example of column N formula
=IF(J1="O",F1,"")

Third:
Example of column M formula
=IF(J1="P",F1,"")

I've assumed that where the conditions are not met you want to return
a "" (making the cell *look" empty)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Sothear" wrote in message
...
I'd like to achive an excel functions of the following scenario:
Column F (value), Column J (Code) A,O,and P, Column M, Column N,
Column P
- If Column J with code "A", return value in column "F" TO column
"P"
- If column J with code "O", return value in column "F" TO column
"N"
- If column J with code "P", return value in column "F" TO column
"M"
Thanks
Sothear

Sothear,
If I read you correctly, this appears to be the same question as before except that you want to clear the value from column F. If you want to actually clear the cell in column F after transfering the data to the other column you will need to use VBA.

Regards,
Mark Graesser


----- Sothear wrote: -----


Mark,

Addition help...

I'd like to able to type in code: A or O or P in column J, and value in column F would shift to each destination column automatically?

Thanks
Sothear



----- Mark Graesser wrote: -----

Sothear,
You can do this by entering IF statements in the cells in P, M, and N

Assuming row 2

in P2 enter =IF(J2="A",F2,"")
in N2 enter =IF(J2="O",F2,"")
in M2 enter =IF(J2="P",F2,"")

The "" will make the cell appear blank when the condition is not met.

Regards,
Mark Graesser


----- Sothear wrote: -----

I'd like to achive an excel functions of the following scenario:

Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P

- If Column J with code "A", return value in column "F" TO column "P"
- If column J with code "O", return value in column "F" TO column "N"
- If column J with code "P", return value in column "F" TO column "M"

Thanks
Sothear