Automatically create a list of column contents based on criteria

[danielstone121]

Hey gurus!

I have a spreadsheet that lists dates in row 6, columns V through BE. We use these dates to log attendance for kids, so under each date there may be one of many symbols, such as "x" if the student was there. I would like to create a list of the dates that meet one of two criteria: either blank or containing "WR". So, let's say (all in row 7) that columns V and X are blank and Y has "WR" in it. In column FB I would like a list of all of the dates that were blank or WR, so I would want the dates contained in row 6 for V, X, and Y. Is there a function that will 1) look for a blank or WR across a row, 2) find the associated date for that blank in row 6, and 3) write the in another column in the form of a list, each date separated by commas?

I know that sounds really complicated. I just thought I would ask. Please let me know if you have any questions. Thanks!

 

[venkat1926]

please post a SMALL extract of your data and explain with reference to that.

 

[danielstone121]

V	W	X	Y	Z	AA	AB	AC	...	FB
1/20	1/21	1/22	1/23	1/24	1/27	1/28	1/29		List of Dates Absent
x	x	x	WR		x	x	x		1/23, 1/24
	WR		x	x	x	x	x		1/20, 1/21, 1/22
		WR		WR		WR			1/20, 1/21, 1/22, 1/23, 1/24, 1/27, 1/28, 1/29

<tbody>
</tbody>

Hey!
This is what I'm thinking. I am looking for a function of some kind to automatically fill in the dates that are blank (or that contain "WR"). So, column FB is the desired result, namely a list of all of the cells in that row (from columns V through BE) that are blank or contain "WR". Does that help?