# Thread: Determine Value

1. ## Determine Value

<img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Excel 2000

Ok...I promise this is the last one....

Example

A2=1650 M2=6/25 N2=3 (the count between dates) 02=??
A3=1655 M3=""
A4=1701 M4=""
A5=1711 M5=6/26 N5=1 O5=(the last value in "A" before the new date is entered, in this case "1701")

How can this be determined...Again all suggestions are appreciated.

2. ## Re: Determine Value

Roberta,

In your example the formula should work. Just enter it in Column O, for the extent of your data.<pre> =IF(M5="","",A4)</pre>

Andrew

3. ## Re: Determine Value

Andrew,

<img src=/S/blush.gif border=0 alt=blush width=15 height=15>So Sorry my fault I didn't make it clearer..(that part of it I have)..I need O2 (??) to show the value of "1701"

Thanks again for your help

4. ## Re: Determine Value

Riberta,

Sorry for the delay in getting a response, and for picking you up wrong last time.

The following Function might do the trick :

Function ValueForDate(rng As Range, oSet) As Long
Application.Volatile
Dim rngAddr As String
rngAddr = rng.Address
ValueForDate = Range(rngAddr).offset(oSet - 1, 0).Value
End Function

Use it as follows - In O2 enter <pre> =IF(M2="","",ValueForDate(A2,N2))</pre>

assuming that you entered the previous function (or Brooke's formula) in N2 and Column A is the column you want the value from.

Andrew

5. ## Re: Determine Value

Andrew,

OMG....U R so GOOD!!!!!! TY TY TY....

Just wish I knew what u did...lol.

I am not sure I understand what the coding is saying...but it works GREAT....

Again TY

6. ## Re: Determine Value

Andrew,
This is the solution I was referring to.
Jeff

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•