Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
Hi everyone..
This is what I am looking for.. When I enter "W" on Cell K4 and then "W" will automatically enter on Cell O9 When I enter "L" on Cell N4 and then "L" will automatically enter on Cell O10 etc... etc... Is it possible to do that??? Please let me know and thank you~~~~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
Perhaps this might suffice ..
In O9: =IF(K4<"W","",K4) In O10: =IF(N4<"L","",N4) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Astroboy" wrote: Hi everyone.. This is what I am looking for.. When I enter "W" on Cell K4 and then "W" will automatically enter on Cell O9 When I enter "L" on Cell N4 and then "L" will automatically enter on Cell O10 etc... etc... Is it possible to do that??? Please let me know and thank you~~~~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
Hello Max,
Thank you for the reply. But I am new to the Excel so where and how do you put those formula? Please let me know.. Oh and Cell K4 and Cell N4 it could have "W" or "L" So if I put W it will shows W on other Cell and if I put L then it will shows L Thank you... "Max" wrote: Perhaps this might suffice .. In O9: =IF(K4<"W","",K4) In O10: =IF(N4<"L","",N4) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Astroboy" wrote: Hi everyone.. This is what I am looking for.. When I enter "W" on Cell K4 and then "W" will automatically enter on Cell O9 When I enter "L" on Cell N4 and then "L" will automatically enter on Cell O10 etc... etc... Is it possible to do that??? Please let me know and thank you~~~~ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
... Cell K4 and Cell N4 it could have "W" or "L"
So if I put W it will show W on other Cell and if I put L then it will show L Ah, perhaps try this then .. Put in the formula bar for O9: =IF(K4="","",K4) Put in the formula bar for O10: =IF(N4="","",N4) You could just select the formula from the post, copy it. Then in Excel, select the formula cell, eg O9, then click inside the formula bar, then right-click paste, and press ENTER. Repeat likewise for the formula that's meant to be placed in O10. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Astroboy" wrote in message ... Hello Max, Thank you for the reply. But I am new to the Excel so where and how do you put those formula? Please let me know.. Oh and Cell K4 and Cell N4 it could have "W" or "L" So if I put W it will shows W on other Cell and if I put L then it will shows L Thank you... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
Hi Max,
That works, great and thank you~~~!!!! I am so sorry for keep asking the questions.. On Cell K4: If input is "N" then Cell O9 shows "N" If input is "W" then Cell O9 show "L" If input is "L" then Cell O9 show "W" How can I set up the formula for above task??? Once again thank you for your great help~~~~~~~ "Max" wrote: ... Cell K4 and Cell N4 it could have "W" or "L" So if I put W it will show W on other Cell and if I put L then it will show L Ah, perhaps try this then .. Put in the formula bar for O9: =IF(K4="","",K4) Put in the formula bar for O10: =IF(N4="","",N4) You could just select the formula from the post, copy it. Then in Excel, select the formula cell, eg O9, then click inside the formula bar, then right-click paste, and press ENTER. Repeat likewise for the formula that's meant to be placed in O10. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Astroboy" wrote in message ... Hello Max, Thank you for the reply. But I am new to the Excel so where and how do you put those formula? Please let me know.. Oh and Cell K4 and Cell N4 it could have "W" or "L" So if I put W it will shows W on other Cell and if I put L then it will shows L Thank you... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Cell??? so could enter just once...
"Astroboy" wrote:
.. On Cell K4: If input is "N" then Cell O9 shows "N" If input is "W" then Cell O9 show "L" If input is "L" then Cell O9 show "W" Put in the formula bar for O9: =IF(K4="N","N",IF(K4="W","L",IF(K4="L","W",""))) I've presumed you want O9 to appear "blank" if the input in K4 is other than what you described above. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |