Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 26th 05, 04:24 AM
rtjeter
 
Posts: n/a
Default Using a Vlookup to return values in a data list?

I have a data list. In column A it gives account number, in Column B is
gives account name, in column c it gives amount. The Account number is
Column A can be given several times. For example:
A B C
7 shoes $700
8 dresses $100
7 shoes $500
9 shirts $300

I want to be able to go to another tab and look in Column A. I see 7 return
the account number 7. Then go to the next value in Column A, which is 8.
And return account number 8. Then go to the next value in Column A, which is
7. I already have 7 so I don't want to return 7 again (don't want to
duplicate values).
Then go to the next value in column A, which is 9 and return the value 9.
The data set is huge with over 800 lines. Many account numbers are repeated
3 or 4 times. But I only want a listing of account numbers with the account
number listed only once. I only need the account number listed once from a
data set where they are listed in Column A numerous times.

Is this possible??

  #2   Report Post  
Old April 26th 05, 05:54 AM
Rowan
 
Posts: n/a
Default

Select Column A. Use DataFilterAdvanced Filter to select Unique records
only. Copy column A and paste onto new worksheet. This should give you the
list of unique account numbers.

Hope this helps
Rowan

"rtjeter" wrote:

I have a data list. In column A it gives account number, in Column B is
gives account name, in column c it gives amount. The Account number is
Column A can be given several times. For example:
A B C
7 shoes $700
8 dresses $100
7 shoes $500
9 shirts $300

I want to be able to go to another tab and look in Column A. I see 7 return
the account number 7. Then go to the next value in Column A, which is 8.
And return account number 8. Then go to the next value in Column A, which is
7. I already have 7 so I don't want to return 7 again (don't want to
duplicate values).
Then go to the next value in column A, which is 9 and return the value 9.
The data set is huge with over 800 lines. Many account numbers are repeated
3 or 4 times. But I only want a listing of account numbers with the account
number listed only once. I only need the account number listed once from a
data set where they are listed in Column A numerous times.

Is this possible??

  #3   Report Post  
Old April 26th 05, 05:56 AM
Biff
 
Posts: n/a
Default

Hi!

Try this using a filter:

Goto the other sheet tab and select the cell where you want the account
numbers.

Goto DataFilterAdvanced Filter
Click: Copy to another location
Click inside the List Range box
Navigate to the sheet where your current list is and select the range of
accounts numbers including the header
Click in the Copy To box
Select the cell where you want the new list to start.
Click: Unique records only
OK out

Biff

"rtjeter" wrote in message
...
I have a data list. In column A it gives account number, in Column B is
gives account name, in column c it gives amount. The Account number is
Column A can be given several times. For example:
A B C
7 shoes $700
8 dresses $100
7 shoes $500
9 shirts $300

I want to be able to go to another tab and look in Column A. I see 7
return
the account number 7. Then go to the next value in Column A, which is 8.
And return account number 8. Then go to the next value in Column A, which
is
7. I already have 7 so I don't want to return 7 again (don't want to
duplicate values).
Then go to the next value in column A, which is 9 and return the value 9.
The data set is huge with over 800 lines. Many account numbers are
repeated
3 or 4 times. But I only want a listing of account numbers with the
account
number listed only once. I only need the account number listed once from
a
data set where they are listed in Column A numerous times.

Is this possible??





Reply
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 you prevent data from changing values when sorting linked . Cassie Excel Discussion (Misc queries) 0 March 4th 05 11:45 AM
How do I create a list in excel that contains external data? [email protected] Excel Discussion (Misc queries) 1 February 15th 05 03:45 AM
Add same set of formulae at defined intervals to list of row data PC-Nut Excel Worksheet Functions 10 January 14th 05 06:46 AM
Using Validation List from Another Workbook with Dependent Data Mike R. Excel Worksheet Functions 5 January 8th 05 08:06 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 04:24 PM


All times are GMT +1. The time now is 10:53 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017