1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sorting columns

Discussion in 'Business Applications' started by MariaPreto, Feb 9, 2005.

Thread Status:
Not open for further replies.
  1. MariaPreto

    MariaPreto Thread Starter

    Sep 22, 2004
    I have a worksheet with 2055 records in excel. And I have two columns,
    A and B, with numbers as a records witch I to match them.
    For instance if column A has the number 1101, I have to find out if the column B has the same number 1101.

    In order to do that I'm going to use the VLOOKUP function.
    My problem is I can't sort by ascending order the column A.
    I think has something to do with the cell format.
    I'm using Excel 2000 on my PC (windows).
    Please help me, and here is some sample

    A B
    1101 1101
    1102 1102
    1103 1103
    11000 1201
    11001 1301
    1201 11000
    1301 11001
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/328545

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice