Skip

2 posts tagged with excel by demagogue.
Displaying 1 through 2 of 2.

I love Excel... when I know what I'm doing

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

Excel Noobery

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

Page: 1
Posts