You're welcome, moshin - glad to help.
If you're satisfied your query has been resolved, can you please use the thread tools to mark it "SOLVED". Thank you.
EDIT You most likely got a circular reference warning because the cell containing the formula was contained in the range the formula was working/calculating on.
EDIT # 2 And thanks for the rep
Last edited by BB1972; 03-11-2013 at 06:21 PM.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks