Well my first whack would be to slap a helper column on the end to do a simple Boolean go/nogo, and then throw the data into a Pivot Table, and then Filter the PT by the helper column.
But formulatically building a table of data would be a lot rougher, I wouldn't do it unless it was really necessary, because you might end up using some dark magic.
Can you post an example spreadsheet?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks