This is easily accomplished with a formula : =MAX(IF(A$2:A$5000=N2,F$2:F$5000,"")) . I copied the list of names in Column A and pasted them...
Roger Haney Today, 04:17 AMTry with your revisited code, maybe it's closer to your needs.[CODE]Option Explicit '...
rollis13 Yesterday, 11:58 PMYep, that's the type of of ordering I'm talking about. Personally, I never re-order columns as I always load data to the data model anyway.
...
Interesting approach.
I do have some merges and sorts in the model. For reordering, are you talking about the column order? I try to keep...
Need formula to create totals using only certain data
My apologies- you wanted the Sum, not the Max. Change MAX to SUM....
Roger Haney Today, 04:52 AM