LinkBack URL
About LinkBacks
coxis 
Hi there
with the offset function how do I find a value of a particular cell in a column of data
eg I have a list of talk time hours i want to find how many hours the 99nth call was
hope you can help
Hi there
with the offset function how do I find a value of a particular cell in a column of data
eg I have a list of talk time hours i want to find how many hours the 99nth call was
hope you can help
coxis,
welcome to the forum.
The offset function may or may not be the ticket. It depends. You'll probably fare better with Index().
Post a data sample for perusal.
If using your example it's the 99th call and these are sequentially numbered on the sheet, you may get away with using a LOOKUP function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks