instantaneous cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably incredibly simple but I've been going in circles with it for
some time. I'm looking for a way to grab and hold the instantaneous value of
a cell whose contents are constantly being updated. Any thoughts?
 
You can "fix" the values of a cell by <copy>, then select another cell
(maybe in another sheet) and Edit | Paste Special | Values | OK. This
would leave the formula in the original cell to continue to update
itself.

Hope this helps.

Pete
 
thanks for the reply. this works as a "manual" solution but how can I assign
only the contents of a cell in a formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing the value of the content of cells by one. 2
Instantaneous cell values from a PLC 8
Scrolling to a cell in formula 4
Windows 8 Something Running All The Time 14
Trendline Question 0
Excel Run macro upon cell edit 0
Excel Typed text appears in wrong cell 0
somewhat complicated conditional formula 2

Back
Top