|
|
#1
06-01-2015, 07:16 PM
|
|||
|
|||
formula, 2 criteria, one result
I have three columns, Column A has the "lookup value", mulitples, column B the dates of entries, column C the criteria I need returned. The data comes in daily, I need the value in column C of the most recent date, (max), in column B for the value in column A
|
|
#2
06-02-2015, 12:02 AM
|
||||
|
||||
|
Hi
please post a sample sheet. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
06-02-2015, 09:44 AM
|
|||
|
|||
|
excel formula
I need to pull odometer from sheet 2, using Unit # from sheet 1 and Vehicle # from sheet 2, but only the most current date. so one result per vehicle #. sheet two gets data feed live, so sheet one will be updating as new odometer readings come in daily
|
|
#4
06-02-2015, 12:10 PM
|
||||
|
||||
|
The attached looks promising
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#5
06-02-2015, 09:17 PM
|
|||
|
|||
|
thank you. I need to look at this more closely. It looks like it is giving me an error where there shouldn't be.
I will get back to you on it. Again, thank you
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Show result of formula as a value in another cell
|
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
|
Formula with 3 Criteria
|
bremen22 | Excel | 3 | 09-24-2013 11:39 AM |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
|
If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
Windows 8 
Office 2010 64bit
Linear Mode
