Your original question was:

I need Column D to show an "x" if the adjacent cell in Column C (dollar amounts) falls within the Top 30% by date.

If it is simply a question of the time of day in a column cf.

I'd still have to copy and paste the Time of Day into a column

then see column F in the attached.

But be aware that on my system the file is almost impossible to work with due to slowness. It might be of some help to set Calculation to Manual (File, Options, Formulas, Calculation options, Manual, OK), but then you must remember to press F9 each time you change something in the file.

If you can't work with it you might want to ask your question in some VBA forum.

I have no further suggestions.

Attached Files

Percentile_2.xlsx (230.1 KB, 9 views)