+ Reply to Thread
Results 1 to 5 of 5

Increase in horizontal way instead of vertical

  1. #1
    Registered User
    Join Date
    05-02-2014
    Location
    Malaysia
    MS-Off Ver
    Office 365 version 2203
    Posts
    10

    Increase in horizontal way instead of vertical

    Hi, I got a question on let say

    sheet1:

    A3:1 B3:8 C3:5 meaning that ( A3=1 , B3=8, C3=5)


    Sheet2:

    F5: = sheet1A3
    F6: = sheet1B3
    F7: = sheet1C3


    How can I do the formula for F column in sheet2 to relate variables in sheet1. Thanks.
    Last edited by jaden5165; 05-02-2014 at 01:14 PM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Increase in horizontal way instead of vertical

    Try this......

    On sheet2, in F5......

    Please Login or Register  to view this content.
    and then drag down.

    Is this what you want?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    05-02-2014
    Location
    Malaysia
    MS-Off Ver
    Office 365 version 2203
    Posts
    10

    Re: Increase in horizontal way instead of vertical

    Wow,cool.Thats what I want.Thanks @sktneer.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Increase in horizontal way instead of vertical

    Glad to help you. Thanks for the feedback and rep.

  5. #5
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Increase in horizontal way instead of vertical

    Cell F5:
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Excel 2007 : Horizontal to vertical
    By godfredafrifa in forum Excel General
    Replies: 1
    Last Post: 11-06-2011, 11:54 AM
  2. Horizontal to vertical
    By godfredafrifa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2011, 10:18 AM
  3. Horizontal To Vertical
    By khanjee in forum Excel General
    Replies: 3
    Last Post: 02-22-2008, 03:48 AM
  4. Vertical to Horizontal
    By billykiller05 in forum Excel General
    Replies: 3
    Last Post: 12-06-2007, 12:04 PM
  5. from horizontal to vertical
    By mlecho in forum Excel General
    Replies: 5
    Last Post: 05-06-2007, 06:47 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