Thread
:
tough lookup question
View Single Post
#
9
Posted to microsoft.public.excel.misc
Bonnie
external usenet poster
Posts: 82
tough lookup question
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.
Reply With Quote
Bonnie
View Public Profile
Find all posts by Bonnie