I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

.... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

Oops, I tried to send it but it came back undeliverable? I used:

?

Thanks,

"Toppers" wrote:

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

Thanks, I'm sending it over.

"Toppers" wrote:

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

yes ... should be OK

"Bonnie" wrote:

Oops, I tried to send it but it came back undeliverable? I used:

?

Thanks,

"Toppers" wrote:

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

It says "Destination not valid with DNS." Can you receive an Excel file or
should I zip it?

"Toppers" wrote:

yes ... should be OK

"Bonnie" wrote:

Oops, I tried to send it but it came back undeliverable? I used:

?

Thanks,

"Toppers" wrote:

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.

I have received both before without any problem. If you continue to have
problems, post your address and I'll contact you!

"Bonnie" wrote:

It says "Destination not valid with DNS." Can you receive an Excel file or
should I zip it?

"Toppers" wrote:

yes ... should be OK

"Bonnie" wrote:

Oops, I tried to send it but it came back undeliverable? I used:

?

Thanks,

"Toppers" wrote:

I may have a solution but I would like to try it on a good sample of data.
Can you send a w/book to:

toppers <at NOSPAMjohntopley.fsnet.co.uk

Remove NOSPAM

"Toppers" wrote:

I am sure VBA will be required to do this: I don't have a formula solution
but that doesn't mean there isn't one!

"Bonnie" wrote:

Yes exactly. But in case I didn't explain it well enough, there are many
columns that have last and first names and I want to fill them all with the
nearest previous NUMBER #999. Do you know how to do this?

Thanks in advance.

"Toppers" wrote:

... and the result from your example would be ..... ??

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname 1234


"Bonnie" wrote:

I think this is complicated but here goes:

I have a spreadsheet that looks like this:

col1 Col2 Col3

bunch of junk
more junk
NUMBER #1234

firstname lastname


This repeats over and over. What I would like to do is populate col3, when
col2 is not null, with the value of the closest previous row that has NUMBER
#9999. Does anyone know a formula or code to do this?

Thanks in advance.