• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filling Blank Column Taking Values From Two Different Columns

AAP

Member
Hello SuperUsers, I have a situation where column 2 needs to be filled. Values will be taken by first from column 1 but if some rows are empty in column 1 then take values from column 3 and fill column 2. My normal files contains 700,000 rows. If I loop then it takes 10 minutes to complete operation. I am looking for an efficient way to do this operation. Please advice.
 
Hi ,

Graeme is right ; I tried the formula over 800000 rows , and it recalculated in less than a second.

See this file.

Narayan
 

Attachments

  • Fill Data Sample.xlsm
    945.8 KB · Views: 0
Hi ,

Graeme is right ; I tried the formula over 800000 rows , and it recalculated in less than a second.

See this file.

Narayan
Hi, Actually this operation is a part of many other operations like, concatenation, clean, trim, duplicates finding, text to columns, Splitting strings, removing odd language characters therefore I was trying to fit every operation in a single vba code with an efficient manner so the whole operation takes as less time as possible. Suggestion is brilliant however, Salute :)
 
Hi ,

See the attached file ; check2 is much faster than check !

Narayan
 

Attachments

  • Fill Data Sample1.zip
    934.5 KB · Views: 0
Hi Jaya ,

These symbols are :

< stands for less than

> stands for greater than

Thus , together they stand for less than or greater than ; a variable 'x' which is less than or greater than another variable 'y' means 'x' is not equal to 'y'.

Thus , another way to read these symbols together is not equal to.

x <> y is read as x is not equal to y.

Narayan
 
Back
Top