Macros - find largest number in range

How to automate the process of finding the highest number in a dynamic range meeting a criteria?

New data added/updated every day (new come, old gone).

The attached file has a properly displayed data.

Thanks,
hmgrts

Give this macro a try. Be sure to remove those notes off to the right or it will interfere with the "find" commands.

Please Login or Register  to view this content.

Repost your sheet with the corrected data and your corrected needs, I'll take a look.

1) You have the macro in the wrong place. In the VBEditor, click on INSERT > MODULE and place the regular macro into a regular module.

2) Put the code back exactly the way it was when I gave it to you. It works fine with this data, too. The 15:00 is a visual number format, it's still 3:00:00 PM in the cell, so the macro can find the 3:00 just fine.

3) Make sure you remove all the "notes" you put in off to the right, they WILL interfere with the macro.

The first data set had only 3:00 AM, and the macro works great.
The second data set had only 3:00 PM and the macro works as designed.

Is there a reason you haven't simply presented a dataset with ALL the parameters and times needing to be dealt with and supplied sample results from that data?

Ah, ok, simple enough. Just change the 3:00 to 3:00:00 AM and it will return to expected operation.

Please Login or Register  to view this content.

It's always best to work with the actual data instead of simplified versions. From our point of view, we presume you are presenting all the parameters and our suggestions/methods are affected...and may be incorrect based on what you might have left out.

Anyway, this is good to go, yes? If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)