Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 27th 06, 05:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 15
Default Based on a condition in one column, search for a year in another column, and display data from another column in the same row look

Inspection Date Hot/ Cold Condition Code Comments
9/29/1989 H 0 Comment 1
11/10/1989 H 0 Comment 2
1/16/1991 H 0 Comment 3
6/21/1991 H 0 Comment 4
12/6/1991 C 0
3/18/1992 H 0
8/12/1992 H 0
3/1/1993 H 0
3/16/1993 C 0
3/23/1994 H 0
3/30/1994 C 0
4/1/1995 C 0
4/15/2003 H 0
5/6/2003 C 0
I need to search for the first year that the inspection was hot, in
this case 9/29/89 and 11/10/89, and return the condition code for the
last hot date in 89 in one cell and the comments for all hot dates in
89 in another, as i am consolidating into a table by years. This then
needs to be done again for cold. A formula using just the "next year
available" as the previous one needs to be used because i am leaving
space for additional dates to be added later.

To me, my question makes sense, to others it may not. Let me know if I
should rephrase this. Thankyou
-matt


  #2   Report Post  
Old December 27th 06, 06:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 527
Default Based on a condition in one column, search for a year in another c

try Data, Filters, Autofilter

You can also use advanced filters to create separate tables

Regards
Peter

" wrote:

Inspection Date Hot/ Cold Condition Code Comments
9/29/1989 H 0 Comment 1
11/10/1989 H 0 Comment 2
1/16/1991 H 0 Comment 3
6/21/1991 H 0 Comment 4
12/6/1991 C 0
3/18/1992 H 0
8/12/1992 H 0
3/1/1993 H 0
3/16/1993 C 0
3/23/1994 H 0
3/30/1994 C 0
4/1/1995 C 0
4/15/2003 H 0
5/6/2003 C 0
I need to search for the first year that the inspection was hot, in
this case 9/29/89 and 11/10/89, and return the condition code for the
last hot date in 89 in one cell and the comments for all hot dates in
89 in another, as i am consolidating into a table by years. This then
needs to be done again for cold. A formula using just the "next year
available" as the previous one needs to be used because i am leaving
space for additional dates to be added later.

To me, my question makes sense, to others it may not. Let me know if I
should rephrase this. Thankyou
-matt




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter - failure to display ALL data down a column Maurice Excel Worksheet Functions 1 September 11th 06 09:04 AM
Excel 2007 Display value based on values in another column range ChrisM Excel Worksheet Functions 2 September 4th 06 03:32 PM
How do I display the sum of 2 data series on a column chart? Sergrock Charts and Charting in Excel 1 August 25th 06 09:05 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017