|
|
#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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode