LinkBack URL
About LinkBacks
Hi all.
I know it's simple (there is a code) but don't know how to do it...
For example in column A some data is inserted, I want the same data to be filled automatically in column X in the same row.
Thank you in advance.
Hi all.
I know it's simple (there is a code) but don't know how to do it...
For example in column A some data is inserted, I want the same data to be filled automatically in column X in the same row.
Thank you in advance.
Hi
Try this in X1: =A1
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Originally Posted by Fotis1991
Thank you, but it doesn't do what I want.
When I type something in a cell in column A, it should automatically fill the data in column X.
Your solution is not automated.
.....=if(a1)<>"";a1;"")
Is this what are you looking for??
Formula contains an error.
\1
Using: MS Office 2003
hi,
"Try this in X1: =A1" provided by Fotis should work, in cell x1 type =a1 and copy down.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
=if(a1)<>"";a1;"")>.>Wrong
=if(a1<>"";a1;"")>>OK!!
Now it's working, still this is not automated like a VBA code, but does the job.=if(a1)<>"";a1;"")>.>Wrong
=if(a1<>"";a1;"")>>OK!!
Excuse me, but you did't mentioned in your first post that you are looking for VBA code..
Also any Excel formula, is automated !
Everything is fine, thank youExcuse me, but you did't mentioned in your first post that you are looking for VBA code..
Also any Excel formula, is automated !
Carma +1
You are welcome. Glad to helped you.
Pls mark the thread, as SOLVED.
Extremer: Is the formula mentioned by Fotis =if(a1<>"";a1;"") is working?
I believe, there is a minor change in this is instead of ; we have to use ,
Kindly do correct if I am wrong.
And the reason behind writing this, is someone newbie joins this, they should not get confused with the given answer on this Forum.
Regards,
Kunal Kumar
Actually I think your wrong, ";" is working quite well, tested with "," and I got an error.
Regards,
...And As proof of this.....
Extremer, I believe you did not understand my point.
My point is, Is formula =if(a1<>"";a1;"") is working properly, coz I am getting error when I am using this exact formula in my excel 2010
Now when I am using =IF(A1<>"",A1,"") this is giving me the correct result...
Sorry if I am wrong somewhere, but my question was about the correct and incorrect formula..
Regards
Fotis, you are right, I seen you excel and the same was my opinion too.. Extremer, just read my post and see the formula used by Fotis. That's the same I am saying too.
Regards
...And As proof of this.....
Bump!=if(a1)<>"";a1;"")>.>Wrong
=if(a1<>"";a1;"")>>OK!!
Another question, what is the proper formula if I want to multiply numbers from different columns...
=IF(A1<>"";A1;"")+IF(B1<>"";B1;"")+IF(C1<>"";C1;"") - this formula is kind of working but it shoes like an error, what is the correct formula ?
Thank you.
Hi
This formula, does not multiply. Give us an example of which cells of which columns you want to multiply and by which criteria??Another question, what is the proper formula if I want to multiply numbers from different columns...
=IF(A1<>"";A1;"")+IF(B1<>"";B1;"")+IF(C1<>"";C1;"") - this formula is kind of working but it shoes like an error, what is the correct formula ?
Actually it works..
\1
From the screen I think you will understand what I need.
So the formula is placed in "F4".
This formula adds. does not multiply!
Adds and 3 cells, although there contents.
So, why don't just use =SUM(A4:C4) ???
Because it shows "0.00" when the cells are blank and I don't want that.
I Try hard to understand..
Yes. If all three of cells are blank, will show 0.
What is the result, that you want to shows, in this case??
I want it to be blank and not 0.
Ok!.So try this.
=IF(AND(A4="";B4="";C4="");"";SUM(A4:C4))
Change the semi-colon by gomma, if you have to do!
Is it ok now?
It works like a charm, thank you again Fotis1991
You are welcome
So, as you found your solution, pls mark your thread, as SOLVED.
I can't find this option.
Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
Unfortunately I can't edit my first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks