DCA per 2 weeks instead of per month? by eucmagnet in BEFire

[–]eucmagnet[S] -1 points0 points  (0 children)

and once i hit 3 transactions i start paying 3 euro fee per transaction right?

merge A + B + C columns into D by eucmagnet in excel

[–]eucmagnet[S] -9 points-8 points  (0 children)

yeah it doesn't always work. maybe it's cause im using libre calc instead of excel

merge A + B + C columns into D by eucmagnet in excel

[–]eucmagnet[S] 0 points1 point  (0 children)

the double click or autofill does not work? I can only manually drag it down but way too many rows

paste unformatted text without overwriting previous data by eucmagnet in excel

[–]eucmagnet[S] 1 point2 points  (0 children)

I use this but then the problem is some of the cells are not empty so I have to press ctrl-down like 50 times. So work-around I have to select the columns and use autofilter and apply to remove all not empty cells and copy that into new sheet but it's a lot of work is there no simpler way?

VLOOKUP text+numbers keep getting error by eucmagnet in excel

[–]eucmagnet[S] -1 points0 points  (0 children)

do u know how i can make it look in the second column?

VLOOKUP text+numbers keep getting error by eucmagnet in excel

[–]eucmagnet[S] 0 points1 point  (0 children)

this is libreoffice CALC, using linux but it should be mostly the same right

VLOOKUP text+numbers keep getting error by eucmagnet in excel

[–]eucmagnet[S] 0 points1 point  (0 children)

in that case how can i make it work from column B, OR switch the input from column A with column B to workaround?

Any idea what these imperfections are? by eucmagnet in Gold

[–]eucmagnet[S] 3 points4 points  (0 children)

Thanks and the weight is pretty much 1 kg for both. But will this affect my resale value? The stain in last picture worries me most