+ Reply to Thread
Results 1 to 2 of 2

doing a function on a whole column

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    yorkshire, England
    MS-Off Ver
    Excel 2011
    Posts
    1

    doing a function on a whole column

    Hi,

    I have two columns, column A has lots of rows of numbers, and in column B i want to take away 30% from the numbers in column A next to them in column B, is there a way i can do this all at once?

    Thanks, Sam

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: doing a function on a whole column

    Manually, you can use this formula in B1 and copy down. =A1*.7
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-13-2013, 12:27 AM
  2. [SOLVED] Expand on Parse Function/ Column to Column - Contiguous Data to include quantities
    By arcamp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2013, 05:18 PM
  3. Worksheet function to Autofill formula in column A when data entered in column B
    By boylers75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 02:27 PM
  4. Replies: 0
    Last Post: 09-13-2012, 03:47 AM
  5. Replies: 4
    Last Post: 09-01-2010, 10:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1