Thread: [Solved] Return Multiple values from data except blanks with two criteria
View Single Post
 
Old 09-05-2018, 11:41 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
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?
Reply With Quote