I have a spreadsheet for my senior project in Political Science that contains lists of members of Congress. Each sheet also has data for gender (0 - male, 1 - female), party (0 - Democrat, 1 - Republican), state (listed by US Postal Service abbreviation) and several other variables. For some reason, when I Sort and Filter (Excel 2007), sometimes the row associations are lost and I've had to re-enter two columns so far. Like I said, some variables stay "in place" (row associations not lost) but others lose them as soon as I sort. For example, a sort by Party ended with McCain a Democrat, Kerry a Republican and other oddities. I specified that the cells with Numbers are, in fact numbers using Format Cells.
What's going on?
Excel destroyed my data!
Excel destroyed my data!
Play
Q6600 @ 3.2GHz :: 8GB DDR2-800 :: eVGA 9800GX2 :: 7900GTX (secondary) :: abit IP35 Pro :: 150GB Raptor 10k RPM :: 2x750GB WD Caviar :: 120GB WD :: X-Fi XtremeMusic :: NEC 4551A :: BenQ DVD Combodrive (52x32x52) :: Dual 22" Acer AL2216W :: Thermaltake Armor Black :: Logitech Z5500 5.1
Work
Core 2 Duo @ 2.53GHz :: 4GB DDR3 @ 1067MHz :: 3670 :: Intel PM45 Chipset :: 500GB 5400RPM SATA :: Integrated Audio :: BD-ROM/DVD Burner :: 16" 1920x1080 RGBLED
Q6600 @ 3.2GHz :: 8GB DDR2-800 :: eVGA 9800GX2 :: 7900GTX (secondary) :: abit IP35 Pro :: 150GB Raptor 10k RPM :: 2x750GB WD Caviar :: 120GB WD :: X-Fi XtremeMusic :: NEC 4551A :: BenQ DVD Combodrive (52x32x52) :: Dual 22" Acer AL2216W :: Thermaltake Armor Black :: Logitech Z5500 5.1
Work
Core 2 Duo @ 2.53GHz :: 4GB DDR3 @ 1067MHz :: 3670 :: Intel PM45 Chipset :: 500GB 5400RPM SATA :: Integrated Audio :: BD-ROM/DVD Burner :: 16" 1920x1080 RGBLED
Re: Excel destroyed my data!
Hit the Insert key. Sometimes that gets pressed and wipes the cells instead of allowing changes.