Hello,
I would like to know if there is formula to copy only first value of the cell.
For an example. A1 has at the begining value 1, after some time I change it to 2 etc. etc., but I need in B1 only the first value. So the option =value(A1) can not work, because it would change B1 always when I change A1.
Is it possible?
Thank you.
If you are open to a VBA solution, try this code.......
To apply this code to your workbook, follow these steps....
Please Login or Register to view this content.This code will place the very first value which you entered in any cell of col. A into corresponding cell of col. B.
- Open your workbook.
- Right Click on the Sheet Tab --> View Code.
- Paste the code given above in the opened code window.
- Close the VBA Editor.
- Save your workbook as Excel Macro-Enabled Workbook.]
- Done.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thank you very much for your effort, but I am unable to view code. I guess it is because I do not have VBA editor? I did some google check and i custumized ribbon > checked Developer, still however I am not able to "view code". Really thank you very much for your effort and help, but is there any other solution to this? Thank you
You literally just want the first character? Wouldn't this work?
=MID(A1,1,1)
Maybe this...Originally Posted by hoyasaxa215
=LEFT(A1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
touche, sir.
Hi guys, thank you, but none of this work.
All I am trying is to capture the first value in cell A1. In this cell numbers will change all the time, but in order to do further calculation I need memorised first value, which happens. And this value must be copied to B1. Classical function in B1... (=value(A1)) is not an option, because if number in A1 changes, it also does change in B1, where as I have said, I need only the first value of A1
The number in A1 is changed manually or by a formula? And in B1 you want to put the first ever number entered in A1?
I get the number over link... it is somehow exported or loged to excell and it changes constantly. Basically there is no formula.
And yes, I would like to put in B1 the first ever number, which apperas in A1. If it is 1, then it is 1. If it is 20340, then it is 20340.
You say you want the first entry.
Does that mean at the beginning of the day (or whenever) that the cell is empty? Then, as the day goes by, the cell entry changes many times but you only want the very first entry that appears?
If the cell doesn't start out as an empty cell there's no way to tell which is the very first entry.
Yes, the cell is empty, it's is conditioned to start capturing values... But as i I have said. I can't imagine how to capture the first value of the cell.
Depending on what type of link you have, a formula using intentional circular references may work.
Do this first...
Goto>File>Options>Formulas
Check Enable iterative calculation
OK out
Assuming cell A1 is the linked cell.
Enter this formula in B1:
=IF(A1="","",IF(B1="",A1,B1))
B1 will return the initial original value of cell A1 until cell A1 is cleared and the cycle starts again.
Hey Tony, this works perfect. Thank you very much!!! I appreciate it a lot.
As well many thanks to Sktneer and Hoyasaxa215. You rule guys!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks