update

[Guest]

two columns
column A-date
column B-value (source- input elsewhere, linked to workbook)

wish to have single daily value ( today() ) to plot, automatically
up-to-date, or how do i get a blank cell to correspond to column A with
column B's input, i tried
=if(A:A=today(),B:B,na()) and wouldn't work
thanks in advance!

 

[Guest]

I am not sure that I really understand what you are trying to achieve. If my
suggestions below do not help then perhaps you can post an example of what
exists and what you want it to be.

You can insert the formula as below and copy it down a column but because it
refers to cells in both column A and column B it must be in another column
like in Cell C1.

=IF(A1=TODAY(),B1,NA())

You can't refer to the entrie column as you have done in your example.

You could have TODAY() in another single cell on the worksheet say cell Z1
and use the cell reference in the above formula. However, remember that you
would have to reference Z1 as ($Z$1) which is absolute mode if you are going
to copy it down to other rows as per the next example:-

=IF(A1=$Z$1,B1,NA())

Regards,

OssieMac