Author

Topic: 0.008 btc To 1st Person To Help Me With Excel Solution Must Work (Read 1130 times)

hero member
Activity: 826
Merit: 1000
Dammit!

I didnt see this sooner.. you got anything else you need help with? lol.
full member
Activity: 178
Merit: 100
...and do you know if I can close a thread or just lock it?

To answer this question, there should be a "lock topic" option in the bottom left-hand corner (if you scroll all the way down).
newbie
Activity: 9
Merit: 0
legendary
Activity: 1789
Merit: 1008
Keep it dense, yeah?
Wish I had seen this earlier. The solution provided is something called absolute cell referencing just so you are aware in future Smiley

I like threads like these. Not enough of them for my liking hehe.
full member
Activity: 238
Merit: 100
good job guys.
I wish the forums had a bounty section. Yeah yeah I know their is services and project dev, but still.. bounty section would be nice.
perhaps i'll suggest it in the meta section..

We should. Did you suggest already or should I myself?
hero member
Activity: 508
Merit: 500
While I'm glad OP found a solution to his problem in excel, I cannot help but notice his ignorance when he chose to post in the Bitcoin Discussion forum. But I do understand his frustration, we've all had those 'I'm stupid' moments.

PS: Marketplace - Services, that would have been a better place to post.

legendary
Activity: 966
Merit: 1000
Ah seems i'm late althought i'm glad you've solved it.

good job guys.
I wish the forums had a bounty section. Yeah yeah I know their is services and project dev, but still.. bounty section would be nice.
perhaps i'll suggest it in the meta section..
That would actually be good idea Smiley
legendary
Activity: 910
Merit: 1000
★YoBit.Net★ 350+ Coins Exchange & Dice
good job guys.
I wish the forums had a bounty section. Yeah yeah I know their is services and project dev, but still.. bounty section would be nice.
perhaps i'll suggest it in the meta section..
hero member
Activity: 700
Merit: 500
Daily Bitcoins for your Paypal/Skrill
Paid-

Thanks again
newbie
Activity: 9
Merit: 0
Cool, glad it worked.

12qy2a4p5QJAE3Q8cNCTtk6xXXYnQ49YWD

I'm not familiar enough with Bitcointalk to know if you can close this thread or not or how to do it.
hero member
Activity: 700
Merit: 500
Daily Bitcoins for your Paypal/Skrill
Just need your address and do you know if I can close a thread or just lock it?
hero member
Activity: 700
Merit: 500
Daily Bitcoins for your Paypal/Skrill
Put a $ in front of either the letter or number in a cell name to make it stay constant when replicating.  Perhaps look at this explanation:  http://blogs.office.com/2011/08/17/making-sense-of-dollar-signs-in-excel/

So make your first 4 rows this instead:
c2&d$2
c3&d$2
c4&d$2
c5&d$2

and they should copy just fine after that making your 5th c6&d$2

jnwood wins  THANKS SO MUCH 

A FUCKING $ SIGN  Wow!

I do like that I can just send some btc and PayPal or any of those other scams don't get none.
hero member
Activity: 700
Merit: 500
Daily Bitcoins for your Paypal/Skrill
I'm going to go try it.  If it works, give me your address
newbie
Activity: 9
Merit: 0
Put a $ in front of either the letter or number in a cell name to make it stay constant when replicating.  Perhaps look at this explanation:  http://blogs.office.com/2011/08/17/making-sense-of-dollar-signs-in-excel/

So make your first 4 rows this instead:
c2&d$2
c3&d$2
c4&d$2
c5&d$2

and they should copy just fine after that making your 5th c6&d$2
hero member
Activity: 700
Merit: 500
Daily Bitcoins for your Paypal/Skrill
I'm totally am an imbecile , I have accepted that fact.

I am trying to do something fairly simple an have had an excel headache all day.

I have a spread sheet like shown below


The problem is that the HTML code in column D is way too long and if I drag it the length (2500 rows) it causes the file to go up past 50mb and causes excel crashes and the max the file can be is 15mb.

So, I simply need a formula for column F to bring over the C column and have column D follow it

so F2 would show:     cool car  

That is easy for cell F2 by using =(c2&d2)  but now I need to populate F all the way to 2500 rows but I cannot drag the D html 

So why can't I say (c2:c2500&d2)?

Or when I drag, it always changes the d2 so how do I keep it constant

I also tried filling in the first four formulas

c2&d2
c3&d2
c4&d2
c5&d2

and dragging but again, the next one in sequence becomes c6:d3

So Somebody know how?

0.008 btc to the person that gives me an answer in an hour...  7:22 PST    I need to be done by 8:22pm
Jump to: