Can This Be Done?

[KN3M3SIS]

Name Desc Review Date
Berry asc O 9/01/02
Berry asc V 9/01/01
Berry asc E 9/01/00
Jamie salk V 9/01/02
Jamie salk V 9/01/01
Jamie salk V 9/01/00
Michelle rep U 9/01/02
Michelle rep U 9/01/01
Michelle rep U 9/01/00


Trying to weed out the values from three rows into one.

This forumala would be reading from sheet 1.
I would like to create a formula with this logic

If Review is an "O" or "U" AND date is 9/01/02
then input name,desc,review (from next 2 rows below), date

They can be coma delimted or put in different cells.

So the new row for the example above should have:
Berry asc O V E 9/01/02
Michelle rep U U U 9/01/02

 

[bluedragon2]

try:

=IF(AND(D2=37500,OR(C2="O",C2="U&quot),A2&","&B2&","&C2&","&OFFSET(C2,1,0)&","&OFFSET(C2,2,0)&","&MONTH(D2)&"/"&DAY(D2)&"/"&YEAR(D2),"&quot



Blue

If I wasn't Blue, I would just be a Dragon...

 

[KN3M3SIS]

Thanks for a prompt reply, but it is not working.
I'm not understanding the "D2=37500" value.

Did this work for you?
Please advise as I am stuck

 

[bluedragon2]

ah, the D2=37500 is looking for the serial date of 9/1/03. What format is your date column?



Blue

If I wasn't Blue, I would just be a Dragon...