Return Multiple values from data except blanks with two criteria

Marcia · #3 09-05-2018, 11:41 AM

Thank you JeffryBrown. Column K was the clincher. Re the two criteria, I just added another IF in the formula that you suggested. But the sequence numbering in column K is quite odd, if I type the same date on two or more rows, the RANK formula throws serial numbers for these same rows with the largest number on the first row.. Like this...

Approval Date------------Number--------Could this be arranged into
Jan 3----------------------2018-04-------2018-02
Jan 2----------------------2018-01-------2018-01
Jan 3----------------------2018-03-------2018-03
Jan 3----------------------2018-02-------2018-04
Jan 5----------------------2018-06-------2018-05
Jan 5----------------------2018-05-------2018-06

Is there a way for the RANK formula to start the lower sequence number from the first row of the same dates?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet	mcronin	Excel	1	05-09-2016 09:43 AM
How to return a value in a data table using vertical and horizontal criteria	oswald	Excel	1	02-08-2015 02:01 AM
using if and compare with multiple criteria and ranges of values	bill3kradio	Mail Merge	7	11-17-2014 01:06 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Data analysis with four conditions then copies certain values that meets the criteria	AieMPhy	Excel	0	04-24-2014 08:41 PM