Max values in various Columns

[soniagdefreitas]

I have the following problem.
I need to first group the NODOB(T) column to the same nodes. For example group all the PVAB0001... PVAB0002... then for that group find the maxium value in the following columns [F:I] that correspond to that group. There is a sample of the excel file.
I need to apply a macro as this is a sample and the original file has 62300 to process. Any help would to great.

[Richard Buttrey]

Hi,

You don't need a macro. An array formula will do, but first remove the Merged Cell in your columns J:M - as a general rule always try to avoid merging cells since they are more trouble than they are worth and not only get in the way of efficient spreadsheet design but often cause unexpected results.

So, in J2 and entered with Ctrl-Shift-Enter then copied down.

=IF(C2<>C3,MAX(IF($C$2:$C$119=C2,$F$2:$F$119)),"")

[oeldere]

With a pivot table.

See the example.

I see you have merged cells in you sheets.

Try to avoid that, you get trouble with it sooner or later.

Do you have questions, on this item, just ask.

[soniagdefreitas]

With a pivot table.

See the example.

I see you have merged cells in you sheets.

Try to avoid that, you get trouble with it sooner or later.

Do you have questions, on this item, just ask.

Thanks a lot I will take a look at your solution... just a small question, you inserted a unique ID is this automatic or did you insert it.

[oeldere]

I added it, and forget to remove.

I though it would be the begin of the solution.

But i choose for a pivot table, and for that (the pivot table) it's useless information.