i have a worksheet called mulogs
first column A has dates and remaining have prices ... based on price entered i want it to check when the next date for close price is for the item. but it keeps giving #value when i use offset(1,0) for the upperval...but code works fine if i remove that and use simple c.value for the upperval just cant figure out y it doesnt work when i put in the offset code for upperval
Please Login or Register to view this content.
Bookmarks