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

FarStar · #1 07-25-2017, 08:42 AM

Ok... hope this is what you meant.

The file shows the conditionally formatted Top Ranked values of 30% highlighted in green for each day. My goal is to have a way to note the time of day in the cell in column D. In other words, having it tell me 10:25 AM in D12.

Having an X or Y or something else works as well, because I can then simply sort D and then copy and paste the times into column E. I already created a formula that would count the times of day and tell me which times occur the most, but I need the data first. Thanks.

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