Lookups & Rtning Unique Records

[Rzr]

I am attempting to find a function to search column "X" so that unique
numbers are the product column "Y". Is there such a function to perform what
can be manually done via Sort and Filter>>>Adv Filter >>>Unique Records Only?

Thanks in advance.

 

[Rzr]

I just realized there is a whole "functions" forum to this site. /oops


In regard to your question, here's an illustration for which I am seeking a
resolution:

On Tab 1, let's say data exists in cells A1:B10 as follows:
- Column A represents account numbers
- Column B represents account balances

100100 $100
100200 $125
100100 $175
100300 $225
100700 $100
100500 $200
100900 $375
100600 $275
100800 $150
100100 $250

On Tab 2, is there a function that can be set up to return...
100100
100200
100300
100700
100500
100900
100600
100800
....in column A without having to perform a manual sort via the Adv Filter
option?

 

[Francis]

try this
assuming data start from row 2, place this formula in B2 of Sheet2

=SUMIF(Sheet1!$A$2:$A$11,Sheet2!A2,Sheet1!$B$2:$B$11)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another