Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range

FarStar · #16 07-26-2017, 06:47 AM

Quote:

Originally Posted by xor

I have attached a file which might be of some interest although it is awfully slow (with about 3500 rows). With 18000 rows as in your Google spreadsheet I guess it will kill Excel completely.

Columns H:M are helper columns.

Anything you can do to point me in the right direction would be appreciated.

xor · #17 07-26-2017, 07:52 AM

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.

FarStar · #18 07-26-2017, 07:55 AM

Quote:

Originally Posted by xor

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.

There we go! That solved it. I'm so happy and grateful to you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Color-fill a range of cells, based on text in a different sheet. Possible?	unittwentyfive	Excel	2	06-01-2014 06:48 AM
Sum Formula in the range with Numeric and NonNumeric data cells	Spanec	Excel	2	01-12-2012 09:15 AM