DonkeyOte, Paul, and a number of others have helped me with formulas to combine and sort two tables. This table contains an error that's apparently beyond my ability to find or repair. The results for Boat A become misaligned at the first result, and the final result for Boat B returns the wrong values. Thanks for any help.
Wouldn't this be simpler...
The zeros can be suppressed with cell formatting or by turning off zero-display in the Tools > Options setup screen, though I think they're fine as is.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the reply. I don't think it will work for the intended purpose of various charts. Here's the final product which I currently sort manually in the third yellow area. I'm attempting to automate the sorting to eliminate errors in sorting as well as time.
Based on file:
P7:S7 copied down to P30:S30
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Ahh, that works beautifully. Thank you so much - again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks