Re: Filling in Blank Cells

Tech-Archive recommends: Fix windows errors by optimizing your registry

Kan,

Thanks.

You wrote <<Been there too many times when I've not done it and then
regretted it>> It's nice to know I'm not the only one.

This technique is also useful when merging (large) databases. The URN is
the only stable piece of data on otherwise changing data. It is, therefore,
easier to then sort on this to bring any duplicates together. I usually
then add a further field =IF(a2=a1,1,0) to identify the duplicates and then
copy / paste special / values in that column. It's then easy to Find
records with "1" and delete the appropriate duplicate records.

Regards.

Bill Ridgeway
Computer Solutions

"Ken Wright" <ken.wright@xxxxxxxxxxxxxxxxxx> wrote in message
news:%2322ehxlWFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> Personally I'd do both. Anytime I'm going to sort I will always add a
> unique field no matter what. Been there too many times when I've not done
> it and then regretted it (Have to close without saving and lose what
> you've
> done to get back). I'll use Domenic's method for the blanks, but SORT =
> UNIQUE ID every time.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Bill Ridgeway" <info@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:d69hbj$95b$1@xxxxxxxxxxxxxxxxxxxxxx
>> Peo,
>>
>> Thanks for that. This is better than my suggestion for Rebecca for
> filling
>> in blanks.
>>
>> Regards.
>>
>> Bill Ridgeway
>> Computer Solutions
>>
>> "Peo Sjoblom" <terre08@xxxxxxxx> wrote in message
>> news:uOOAZ4XWFHA.3928@xxxxxxxxxxxxxxxxxxxxxxx
>> > Sure
>> >
>> > "Try the following...
>> >
>> > 1) Select/highlight your data (five columns)
>> >
>> > 2) Edit > Go To > Special > Blanks > Ok
>> >
>> > 3) Enter your unique character
>> >
>> > 4) Press CONTROL+ENTER
>> >
>> >
>> > --
>> > Regards,
>> >
>> > Peo Sjoblom
>> >
>> >
>> > "Bill Ridgeway" <info@xxxxxxxxxxxxxxxxxxx> wrote in message
>> > news:d684ip$9bh$1@xxxxxxxxxxxxxxxxxxxxxxx
>> >> Peo,
>> >>
>> >> I don't have Domenic's solution (not received or deleted in error)
> could
>> >> you please re-post it?
>> >>
>> >> Thanks.
>> >>
>> >> Regards.
>> >>
>> >> Bill Ridgeway
>> >> Computer Solutions
>> >>
>> >
>>
>>
>
>


.

Relevant Pages