Perhaps if you posted a sample spreadsheet of your data, it would be easier to supply you with a workable solution.
Perhaps if you posted a sample spreadsheet of your data, it would be easier to supply you with a workable solution.
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
How do I post a sample spreadsheet?
Thanks
See attached, an unmanageable and grotesque formula, but it seems to work. There must be a better way. Would a user defined function be acceptable (a macro)?
Bookmarks