|
|
#2
09-03-2018, 04:07 PM
|
|||
|
|||
How about something like this. I would suggest you create an unique ID field which is in column L.
1. I'm guessing you are saying, if the Transaction No. is blank, then that row should not be returned. The formula is in E16:E19 and everything to the left pulls from the unique ID in E16:E19. 2. You didn't say what the two criteria are. 3. Look in column K. Along with the formula I used a custom format. The formual returns the rank based on the Date Approved and the custom format fills in the 2018- 
|
| 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 Vista 
Office 2007
Threaded Mode