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

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

FAQ

Thread Tools

Display Modes

#16

07-26-2017, 06:47 AM

FarStar

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

Office 2016

Novice

Join Date: Jul 2017

Posts: 10

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 PM.