Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help on formula
i want to transfer the data from column K and L to another page based on
the answer on column P. If the answer is Y then the data from cell K11 and L11 will transfer to another page, but if the answer is N then the data wouldn't transfer. I tried them before, but I couldn't make them go in order. because sometimes when the answer is N the data wouldn't transfer, but when the answer for the next row is Y the data would transfer but it would skip a row because the last row is N. So, how do I make them go in order so they wouldn't skip a row? thanks -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |