ExcelFilter: I have Worksheet1 and Worksheet2. Both worksheets contain PersonName on the X-axis, ClassName on the Y-axis. I need to run some comparison between the two. Thinking of doing this on a 3rd worksheet. Here's where it gets tricky:
1. There are several thousand PersonNames.
2. There are about 100 CourseNames.
3. There is volatility in the PersonNames and CourseNames; they will be constantly changing, especially, the PersonNames. [more inside]
posted by demagogue
on Feb 15, 2011 -
5 answers

ExcelFilter: I need to write something pretty simple in Excel. I have big spreadsheet of data. Some rows are fill-colored, and some columns are fill-colored. I need something that will show me (hopefully in a table or something) the cells that have their entire column colored AND have their entire row colored. Returning the value of the cell would be helpful too. (I have a feeling this is an embarassingly easy question to answer)
posted by demagogue
on Mar 9, 2010 -
5 answers

About Ask MetaFilter

Ask MetaFilter is a question and answer site that covers nearly any question on earth, where members help each other solve problems. Ask MetaFilter is where thousands of life's little questions are answered.