|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
09-06-2008, 11:41 AM
|
#1 |
|
Anime:Any-may
Join Date: Sep 2002
Location: Kota Bharu, Malaysia
Posts: 2,447
|
How to remove excel 2002 sum function and get unique values?
Hi,
I am using excel and have keyed in some data. In one column is a sum function (=sum(a2:02) etc. I want to copy the entire results of the sum value but excel does not allow me. I know you need to remove the sum function. Is there a faster way to do it without me having to retype the answers in the next column?
__________________
CPU: Intel E-5200. Graphics: Saphire Radeon 4770 HD 512 MB. Motherboard: Gigabyte GA-EP43-DS3L. Memory: Corsair XMS2 Xtreme Performance 4 GB ( 2 x 2 GB ), Chasis: Antec Three Hundred. PSU: Corsair CX400W. Optical Drive: Sony Optiarc SATA DVD +-RW. Storage: Seagate Barracuda 7200.12 500GB SATA. Peripherals: Dell E1905EP 19" UltraSharp LCD; LG M227WD (Dual screen), HP 4180 Printer, Canon S400SP Printer & Lide20 Scanner; Philiphs HP 890, Edifier MP230. OS: Win 7 (64 bit). Laptop: Toshiba Satellite M50 |
|
|
|
09-08-2008, 07:32 AM
|
#2 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
You should have this already.
select the data then copy >right click > paste special > select >value only
__________________
Asus M4A77D, 64 X2 6000+, 4 GB Corsair DDR2 800 ram, Radeon 5770. |
|
|
|
|
09-08-2008, 05:40 PM
|
#3 |
|
Anime:Any-may
Join Date: Sep 2002
Location: Kota Bharu, Malaysia
Posts: 2,447
|
Thanks a lot
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
