display value if conditions meet

**slin** · 01-11-2011, 01:49 PM

Hello,

I have a question in excel that I hope you can help.

I have spreadsheet that contain serial#, order#, shipping date and pricing. Right now I want display order# in Column E if one of the shipping date> 12/31/2009 under the same serial#.

Here is the sample data

Any advice is appreciated.

**NBVC** · 01-11-2011, 01:52 PM

Try:

=IF(COUNTIFS(A:A,A2,C:C,">12/31/2009"),B2,"")

copied down

**BeerKing** · 01-11-2011, 01:57 PM

This seems to work, enter this in cell E2:

Please Login or Register  to view this content.

E2 will be blank since the formula returns FALSE, but if you copy it to E3 you'll see it works.

**NBVC** · 01-11-2011, 02:00 PM

BeerKing,

How about the check for the same serial number?

**slin** · 01-11-2011, 02:17 PM

It works! Thank you so much!

**BeerKing** · 01-11-2011, 02:25 PM

It's possible I didn't fully understand the question, but I can't really see what I've missed. For each serial# I see 2 or 3 different order#. What have I missed??

**NBVC** · 01-11-2011, 02:33 PM

It will up to the Original Poster, Slin, to clarify which is the "working" solution.

But I interpreted the question as: If the particular serial # has any dates listed that is greater than 12/31/2009, then he/she wants the Order # from the same line to as the formula is in to show...

Yours, just looks at the date and selects the order number if it is the date is greater than the 12/31/2009.

Possibly that is what was required... OP please arbitrate.