Thread: [Solved] Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range
View Single Post
 
Old 07-26-2017, 07:52 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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
File Type: xlsx Percentile_2.xlsx (230.1 KB, 9 views)
Reply With Quote