Copying into ranges

carlito_1985 · #1 06-19-2005, 09:36 PM

Hi everyone, sorry about the title, but I wasn't entirely sure what to call the thread.
What I'm working with is a small list of numbers in one database (List A), and a large list in another (List B), and I want a formula to check through List B, and any number thats in List A, I want to copy a new formula to the neighbouring cell.
EG.

List a
100
105
106
109

list b
100
101
102
103
104
105
106
107
108
109
110...

I want it to come out like this

100 Formula in next column
101
102
103
104
105 Formula in next column
106 Formula in next column
107
108
109 Formula in next column
110...

Thanks

#2 06-19-2005, 11:05 PM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#3 09-05-2005, 10:05 PM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#4 09-05-2005, 11:05 PM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#5 09-06-2005, 12:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#6 09-06-2005, 01:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#7 09-06-2005, 02:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#8 09-06-2005, 03:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#9 09-06-2005, 04:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#10 09-06-2005, 06:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#11 09-06-2005, 07:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

#12 09-06-2005, 10:05 AM

Hi!

Ok, so if there are dupes you want "some" formula in the next column. What
formula is that? Do you want a formula that identifies the value in column B
as also being listed in column A? If so:

=IF(COUNTIF(A$1:A$4,B1),"Dupe","")

Biff

"carlito_1985" <carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com>
wrote in message
news:carlito_1985.1qwk6c_1119233104.4444@excelforum-nospam.com...
>
> Hi everyone, sorry about the title, but I wasn't entirely sure what to
> call the thread.
> What I'm working with is a small list of numbers in one database (List
> A), and a large list in another (List B), and I want a formula to check
> through List B, and any number thats in List A, I want to copy a new
> formula to the neighbouring cell.
> EG.
>
> List a
> 100
> 105
> 106
> 109
>
> list b
> 100
> 101
> 102
> 103
> 104
> 105
> 106
> 107
> 108
> 109
> 110...
>
> I want it to come out like this
>
> 100 Formula in next column
> 101
> 102
> 103
> 104
> 105 Formula in next column
> 106 Formula in next column
> 107
> 108
> 109 Formula in next column
> 110...
>
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
> http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=380436
>

Welcome to the Excel Forum

Forum Statistics