I Have a sheet with store and Region

Store coloum has unique value under Coloum A

and each number under Coloum A is unique and will appear only in one Reg.

for eg. If Store 7010 will be under Reg3 - it wont appar in any other Reg.


I want to a list which will show what stores comes in what Reg.

A B C D E
Store Reg1 Reg2 Reg3 Reg4

9562 5602 5640 6002 6357
8352 5603 5641 6003 6358
7805 5604 5644 6004 6359
8362 5605 5645 6005 6361
5675 5607 5646 6006 6362
6378 5609 5651 6008 6363
5821 5610 5652 6009 6364
6441 5611 5664 7010 6368
7010 5613 5682 6012 6369
7508 5614 5685 6013 6370
7804 5615 5686 6015 6371
7803 5616 5688 6016 6372
7534 5617 5689 6017 6373
7504 5618 5691 6018 6374
5818 5619 6440 6019 6375


Thanks in advance

Deepak

This makes No Sense !! Try Again explaining what you want...


I Have a sheet with store and Region

Store coloum has unique value under Coloum A

and each number under Coloum A is unique and will appear only in one Reg.

for eg. If Store 7010 will be under Reg3 - it wont appar in any other Reg.


I want to a list which will show what stores comes in what Reg.

A B C D E
Store Reg1 Reg2 Reg3 Reg4

9562 5602 5640 6002 6357
8352 5603 5641 6003 6358
7805 5604 5644 6004 6359
8362 5605 5645 6005 6361
5675 5607 5646 6006 6362
6378 5609 5651 6008 6363
5821 5610 5652 6009 6364
6441 5611 5664 7010 6368
7010 5613 5682 6012 6369
7508 5614 5685 6013 6370
7804 5615 5686 6015 6371
7803 5616 5688 6016 6372
7534 5617 5689 6017 6373
7504 5618 5691 6018 6374
5818 5619 6440 6019 6375


Thanks in advance

Deepak

On Dec 29, 6:55*pm, Jim May wrote:
This makes No Sense !! *Try Again explaining what you want...



I Have a sheet with store and Region

Store coloum has unique value under Coloum A

and each number under Coloum A is unique and will appear only in one Reg.

for eg. If Store 7010 will be under Reg3 - it wont appar in any other Reg.

I want to a list which will show what stores comes in what Reg.

* A * * * B * * *C * * * *D * * * E
Store Reg1 Reg2 Reg3 Reg4

9562 5602 5640 6002 6357
8352 5603 5641 6003 6358
7805 5604 5644 6004 6359
8362 5605 5645 6005 6361
5675 5607 5646 6006 6362
6378 5609 5651 6008 6363
5821 5610 5652 6009 6364
6441 5611 5664 7010 6368
7010 5613 5682 6012 6369
7508 5614 5685 6013 6370
7804 5615 5686 6015 6371
7803 5616 5688 6016 6372
7534 5617 5689 6017 6373
7504 5618 5691 6018 6374
5818 5619 6440 6019 6375

Thanks in advance

Deepak- Hide quoted text -

- Show quoted text -

Try this formula in row 3

=IF(COUNTIF(B$3:E$17,A11),INDEX(B$1:D$1,MIN(IF(B$3 :E$17=A11,COLUMN(B
$1:E$1)-COLUMN(B$1)+1))),"")

confirmed with CTRL+SHIFT+ENTER and copied down the column

I have reconstructed the requirement, sorry for inconvienience

==============================

The actual file

Store R1 R2 R3
9562 5602 5640 8352
8352 8362 5641 6003
7805 5604 9562 6004
8362 5821 5645 6005
5675 5607 5646 6441
6378 5609 5651 7805
5821 5675 5652 6009
6441 7804 5664 6010
7010 5613 5682 6378
7508 5614 7508 6013
7804 5615 7010 6015

The Result should be as below

Store R1 R2 R3
9562 ---- ---- 8352
8352 8362 ---- ----
7805 ---- 9562 ----
8362 5821 ---- ----
5675 ---- ---- 6441
6378 ---- ---- 7805
5821 5675 ---- ----
6441 7804 ---- ----
7010 ---- ---- 6378
7508 ---- 7508 ----
7804 ---- 7010 ----

******************************************

"barry houdini" wrote:

On Dec 29, 6:55 pm, Jim May wrote:
This makes No Sense !! Try Again explaining what you want...



I Have a sheet with store and Region

Store coloum has unique value under Coloum A

and each number under Coloum A is unique and will appear only in one Reg.

for eg. If Store 7010 will be under Reg3 - it wont appar in any other Reg.

I want to a list which will show what stores comes in what Reg.

A B C D E
Store Reg1 Reg2 Reg3 Reg4

9562 5602 5640 6002 6357
8352 5603 5641 6003 6358
7805 5604 5644 6004 6359
8362 5605 5645 6005 6361
5675 5607 5646 6006 6362
6378 5609 5651 6008 6363
5821 5610 5652 6009 6364
6441 5611 5664 7010 6368
7010 5613 5682 6012 6369
7508 5614 5685 6013 6370
7804 5615 5686 6015 6371
7803 5616 5688 6016 6372
7534 5617 5689 6017 6373
7504 5618 5691 6018 6374
5818 5619 6440 6019 6375

Thanks in advance

Deepak- Hide quoted text -

- Show quoted text -

Try this formula in row 3

=IF(COUNTIF(B$3:E$17,A11),INDEX(B$1:D$1,MIN(IF(B$3 :E$17=A11,COLUMN(B
$1:E$1)-COLUMN(B$1)+1))),"")

confirmed with CTRL+SHIFT+ENTER and copied down the column