+ Reply to Thread
Results 1 to 3 of 3

Variable cell value & Date Sort

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    LaFollette, TN
    Posts
    2

    Variable cell value & Date Sort

    Okay guys, I have two questions I'm sure you guys can knock out quick...

    I'm a total Excel newbie so bare with me.

    column a is listed by dates..

    How do you sort by dates in this column A if the columns aren't entered chronologically.

    2nd question - I'm adding two rows, say, in row d3 I have: =a1+b1

    However, for every row I have to retype that simple equation over and over, =a2+b2, =a3+b3... etc etc. IS there a way to use whatever row you're in as the variable such as "=%row+%row"

    And if so.. how do I add that forumla all the way down the column?

    Thanks guys

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    1st. Use "sort" Tool.
    Please Login or Register  to view this content.
    2nd. Just copy the first cell, then paste to the following rows.
    I need your support to add reputations if my solution works.


  3. #3
    Registered User
    Join Date
    09-16-2008
    Location
    LaFollette, TN
    Posts
    2
    Awesome, that worked! Thank you!

+ 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. inserting a date into a cell
    By cmf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2008, 08:47 AM
  2. Referencing date in another cell in text
    By wmorrison49 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2008, 09:13 AM
  3. Date Cell
    By Blink in forum Excel General
    Replies: 3
    Last Post: 08-02-2007, 11:38 AM
  4. copying various cells in ot different cells in a different sheet
    By MonkeyDeath in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-25-2007, 11:22 AM
  5. Variable Cell Number?
    By talR in forum Excel General
    Replies: 1
    Last Post: 06-28-2007, 09:45 AM

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