LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nitenurse
 
Posts: n/a
Default How do I make an entire column do the same calculation across a r.

Sort of going through all 140 rows and typing the formula individually, how
do I get data from two columns to average, or find diferences. I know how to
do it manually but surely there is an easier way. The books all show how to
work with columns but how do you work with multiple columns?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change case in an entire column of text in Excel linpengie Excel Worksheet Functions 9 April 1st 05 12:32 AM
Excel: How do I type a letter in a column and make a check mark a. BauerY Excel Worksheet Functions 3 March 24th 05 06:34 PM
My entire Excel SS is locked-up. I cannot make any changes in any first presbyterian Excel Worksheet Functions 0 March 21st 05 09:03 PM
How to add the same value to an entire column? Brita Excel Discussion (Misc queries) 2 December 22nd 04 12:55 AM
How to calculate the data in excel 2002 including only the last 9. TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"