The "Pay ALL your debt off by Xmas 2012" challenge - PART 2!!!

mf0u1098

HelenPie wrote: »

I tend to find using combinations of match/index/offset is faster than using h/vlookup (though more of a faff to put the formulas together).

Otherwise, have you thought about writing it in VBA and just running periodically so that the formulas aren't stored in the cells? (Don't know how familiar you are with vba but it's not too bad once you get the hang of it )

H x

I think I know how I'm going to be spending my sick day... I've never used "match/index/offset", completely self taught so I know there are probably big gaps! I've used VBA a few times to correct Macros and things but there must be some free online tutorials out there for me to play with.

Thanks for the tips Helen :A xxx

PedroMatias

Gemma... email sent. One more test....


The Trusty Team:

001 :j mf0u1098 £5,000 /[STRIKE] £16,386.45 [/STRIKE] 30.51%

Remainder removed. It works

DorsetGirl_2

mf0u1098 wrote: »

It's ok DorsetGirl, I've had this before, it just takes a few days to clear and then will come off Opus xxx

That makes me feel a better - was panicking it would have come off someone elses card!

mf0u1098

camuk81 wrote: »

See now you should go on a date you share you love of office programs and formulas.

Morning everyone!

Busy few days, payday tomorrow and have £40 more then I though so waiting till I get paid tonight to put some more just incase!

Just a little payment No 149 new paid total amount is £5132.41 total paid off is 35.99%

Feeling very proud of hitting 35.99% Little more in the bank to throw at it tonight so might be on a head start for next month!

That is such an amazing achievement camuk81 :T:T:T We're all very proud of you too xxx

antonia1 wrote: »

I am however a little annoyed at my other flatmate. I was driving back to mum's on friday and said I'd give her a lift home, even though it is half an hour out of my way. Then she asked me to pick her up from a different place (adding another 20 mins:mad:) and when I got there she wasn't even ready on time (adding another 20 mins:mad::mad::mad:). All in all, taking her cos me an extra £10 and 1hr 45mins over the weekend, and she didn't even offer to pay towards petrol:mad:! Considering the journey is normally only 3hrs and £25 each way, that is quite a substantial addition. And then she had the cheek to assume she'd get a lift next time I drive home! I think I'll just say nothing for now, not offer again and if she actually asks directly then I'll have to say no.

HOW RUDE!!!!!! Stick to your guns hun as that is just cheeky and completely out of order! xxx

camuk81 wrote: »

Having just at that I realise why I have felt so down, cleared £1,082 off this month! No wonder I feel drained!

:j:j:j:j:j Just think though, it's tough now but the sooner it's gone then the sooner you can spend the money (or save of course) on things you [STRIKE] want[/STRIKE] need

mf0u1098

DorsetGirl wrote: »

That makes me feel a better - was panicking it would have come off someone elses card!

No, I think it just takes a while for one account to talk to another and there is a delay as things are checked xxx

mf0u1098

PedroMatias wrote: »

Gemma... email sent. One more test....


Remainder removed. It works

Cool, just got it so am gonna do a test now... xxx

p.s. VERY impressed!

mf0u1098

The Trusty Team: 001:j mf0u1098£5,000/[STRIKE]£16,386.45[/STRIKE]30.51%002:j charleyroo£8,000003:j CW2£4,874/[STRIKE]£12,459[/STRIKE]39.12%004:j loubie_lou£1,876.94/[STRIKE]£13,876.93[/STRIKE]13.53%005:j kerri_dfw£1,855.32/[STRIKE]£5,030[/STRIKE]36.89%006:j Suzitiger£133/[STRIKE]£5,353[/STRIKE]2.48%007:j mumfirst£9,958.67008:j Shopping_addict£6,431009:j eldestofthree£12,000010:j rjh35£3,511.76/[STRIKE]£15,461.76[/STRIKE]22.71%011:j antonia1£1,035/[STRIKE]£3,895[/STRIKE]26.57%012:j his missus£1,525/[STRIKE]£6,583[/STRIKE]23.17%013:j fritterprincess£1,900/[STRIKE]£8,500[/STRIKE]22.35%014:j debtfreeeju£1,559/[STRIKE]£9,650[/STRIKE]16.16%015:j emiesq£10,000016:j jakes-mum£2,635.81/[STRIKE]£8,806.89[/STRIKE]29.93%017:j beachie£1,117.01/[STRIKE]£4,000[/STRIKE]27.93%018:j RoobyNooby£1,800019:j mazy_m£6,900020:j Deniseg4£17,550021:j Flossy87£949.82/[STRIKE]£8,334[/STRIKE]11.40%022:j Clarienne£679.79/[STRIKE]£8,379.50[/STRIKE]8.11%023:j Natlie£1,361/[STRIKE]£9,800[/STRIKE]13.89%024:j forgottendreams£901/[STRIKE]£6,100[/STRIKE]14.77%025:j Bobley£6,000026:j MrsAckroyd£10,000027:j GreenSaints£1,806.19/[STRIKE]£22,922.39[/STRIKE]7.88%028:j banwa£2,658/[STRIKE]£15,000[/STRIKE]17.72%029:j lulalolly£1,619/[STRIKE]£8,276[/STRIKE]19.56%030:j salkunh£848.22/[STRIKE]£38,028.13[/STRIKE]2.23%031:j savingforarainyday£222.58/[STRIKE]£7,145[/STRIKE]3.12%032:j catapa£3,600033:j jimmytwoshoes£3,373.96034:j moneymakermum£9,521035:j sydneybean£216/[STRIKE]£5,592[/STRIKE]3.86%036:j Shellgsxr£1,721.22/[STRIKE]6,157.85[/STRIKE]27.95%037:j alamaya£46,042.38038:j Miss Information£430/[STRIKE]£2,529.33[/STRIKE]17.00%039:j jamescarsonlee£497.81/[STRIKE]£10,442.39[/STRIKE]4.77%040:j GemmaB1£14,440041:j snoopyfan28£376/[STRIKE]£8,000[/STRIKE]4.70%042:j PammyH£6,500043:j rosiest£1,939/[STRIKE]£12,911.70[/STRIKE]15.02%044:j shrekkiegirl£1,886/[STRIKE]£9,230[/STRIKE]20.43%045:j SEASHELL£16,563046:j May-13£3,065/[STRIKE]£14,128[/STRIKE]21.69%047:j sam09£3,100/[STRIKE]12,724[/STRIKE]24.36%048:j CraftyTwinkle£2,530.98/[STRIKE]£10,369[/STRIKE]24.41%049:j recurrent-ostrich£1,651.81/[STRIKE]£10,000[/STRIKE]16.52%050:j seriousDFW£1,050/[STRIKE]£10,722[/STRIKE]9.79%051:j Nickyanne123£1,795.40/[STRIKE]£14,247[/STRIKE]12.60%052:j ibnimmo£44,700053:j JayneTay£280/[STRIKE]£5,000[/STRIKE]5.60%054:j Katiec950£3,162.43/[STRIKE]£10,678[/STRIKE]29.62%055:j InsertWittyName£4,460.66/[STRIKE]15,626.32[/STRIKE]28.55%056:j dd1981£802.11/[STRIKE]£9,793.81[/STRIKE]8.19%057:j PedroMatias£3,551.92/[STRIKE]£16,136.77[/STRIKE]22.01%058:j hazelc56£1,038.39059:j Choc-addict£785.86/[STRIKE]£29,979.60[/STRIKE]2.62%060:j idristhedragon£100/[STRIKE]1,900[/STRIKE]5.26%061:j plum44£17,845062:j Xandersmum£500/[STRIKE]£8,950[/STRIKE]5.59%063:j Malmol09£1,178.74/[STRIKE]£17,630.02[/STRIKE]6.69%064:j theposhbint£534.30/[STRIKE]£13,210.36[/STRIKE]4.04%065:j Kerfuffle£1,696.81/[STRIKE]£12,471.68[/STRIKE]13.61%066:j StrawberryR£997/[STRIKE]£6,160.16[/STRIKE]16.18%067:j rusty1987£208.41/[STRIKE]£6,527.50[/STRIKE]3.19%068:j pyschopathbabble£3,381.57/[STRIKE]£6,492.82[/STRIKE]52.08%069:j lemonpopsicle£2,588/[STRIKE]£7,719[/STRIKE]33.53%070:j RosaBernicia£510/[STRIKE]£11,195[/STRIKE]4.56%071:j Angel84£6,621072:j fruityslh£2,192.80/[STRIKE]£15,106[/STRIKE]14.52%

PedroMatias

mf0u1098 wrote: »

The Trusty Team: 001:j mf0u1098£5,000/[STRIKE]£16,386.45[/STRIKE]30.51%002:j charleyroo£8,000003:j CW2£4,874/[STRIKE]£12,459[/STRIKE]39.12%004:j loubie_lou£1,876.94/[STRIKE]£13,876.93[/STRIKE]13.53%005:j kerri_dfw£1,855.32/[STRIKE]£5,030[/STRIKE]36.89%006:j Suzitiger£133/[STRIKE]£5,353[/STRIKE]2.48%007:j mumfirst£9,958.67008:j Shopping_addict£6,431009:j eldestofthree£12,000010:j rjh35£3,511.76/[STRIKE]£15,461.76[/STRIKE]22.71%011:j antonia1£1,035/[STRIKE]£3,895[/STRIKE]26.57%012:j his missus£1,525/[STRIKE]£6,583[/STRIKE]23.17%013:j fritterprincess£1,900/[STRIKE]£8,500[/STRIKE]22.35%014:j debtfreeeju£1,559/[STRIKE]£9,650[/STRIKE]16.16%015:j emiesq£10,000016:j jakes-mum£2,635.81/[STRIKE]£8,806.89[/STRIKE]29.93%017:j beachie£1,117.01/[STRIKE]£4,000[/STRIKE]27.93%018:j RoobyNooby£1,800019:j mazy_m£6,900020:j Deniseg4£17,550021:j Flossy87£949.82/[STRIKE]£8,334[/STRIKE]11.40%022:j Clarienne£679.79/[STRIKE]£8,379.50[/STRIKE]8.11%023:j Natlie£1,361/[STRIKE]£9,800[/STRIKE]13.89%024:j forgottendreams£901/[STRIKE]£6,100[/STRIKE]14.77%025:j Bobley£6,000026:j MrsAckroyd£10,000027:j GreenSaints£1,806.19/[STRIKE]£22,922.39[/STRIKE]7.88%028:j banwa£2,658/[STRIKE]£15,000[/STRIKE]17.72%029:j lulalolly£1,619/[STRIKE]£8,276[/STRIKE]19.56%030:j salkunh£848.22/[STRIKE]£38,028.13[/STRIKE]2.23%031:j savingforarainyday£222.58/[STRIKE]£7,145[/STRIKE]3.12%032:j catapa£3,600033:j jimmytwoshoes£3,373.96034:j moneymakermum£9,521035:j sydneybean£216/[STRIKE]£5,592[/STRIKE]3.86%036:j Shellgsxr£1,721.22/[STRIKE]6,157.85[/STRIKE]27.95%037:j alamaya£46,042.38038:j Miss Information£430/[STRIKE]£2,529.33[/STRIKE]17.00%039:j jamescarsonlee£497.81/[STRIKE]£10,442.39[/STRIKE]4.77%040:j GemmaB1£14,440041:j snoopyfan28£376/[STRIKE]£8,000[/STRIKE]4.70%042:j PammyH£6,500043:j rosiest£1,939/[STRIKE]£12,911.70[/STRIKE]15.02%044:j shrekkiegirl£1,886/[STRIKE]£9,230[/STRIKE]20.43%045:j SEASHELL£16,563046:j May-13£3,065/[STRIKE]£14,128[/STRIKE]21.69%047:j sam09£3,100/[STRIKE]12,724[/STRIKE]24.36%048:j CraftyTwinkle£2,530.98/[STRIKE]£10,369[/STRIKE]24.41%049:j recurrent-ostrich£1,651.81/[STRIKE]£10,000[/STRIKE]16.52%050:j seriousDFW£1,050/[STRIKE]£10,722[/STRIKE]9.79%051:j Nickyanne123£1,795.40/[STRIKE]£14,247[/STRIKE]12.60%052:j ibnimmo£44,700053:j JayneTay£280/[STRIKE]£5,000[/STRIKE]5.60%054:j Katiec950£3,162.43/[STRIKE]£10,678[/STRIKE]29.62%055:j InsertWittyName£4,460.66/[STRIKE]15,626.32[/STRIKE]28.55%056:j dd1981£802.11/[STRIKE]£9,793.81[/STRIKE]8.19%057:j PedroMatias£3,551.92/[STRIKE]£16,136.77[/STRIKE]22.01%058:j hazelc56£1,038.39059:j Choc-addict£785.86/[STRIKE]£29,979.60[/STRIKE]2.62%060:j idristhedragon£100/[STRIKE]1,900[/STRIKE]5.26%061:j plum44£17,845062:j Xandersmum£500/[STRIKE]£8,950[/STRIKE]5.59%063:j Malmol09£1,178.74/[STRIKE]£17,630.02[/STRIKE]6.69%064:j theposhbint£534.30/[STRIKE]£13,210.36[/STRIKE]4.04%065:j Kerfuffle£1,696.81/[STRIKE]£12,471.68[/STRIKE]13.61%066:j StrawberryR£997/[STRIKE]£6,160.16[/STRIKE]16.18%067:j rusty1987£208.41/[STRIKE]£6,527.50[/STRIKE]3.19%068:j pyschopathbabble£3,381.57/[STRIKE]£6,492.82[/STRIKE]52.08%069:j lemonpopsicle£2,588/[STRIKE]£7,719[/STRIKE]33.53%070:j RosaBernicia£510/[STRIKE]£11,195[/STRIKE]4.56%071:j Angel84£6,621072:j fruityslh£2,192.80/[STRIKE]£15,106[/STRIKE]14.52%

Errr...HAHA!

mf0u1098

It's saying there are too many characters so I'm going to try that Open Office doodah and see if that works... *fingers crossed peeps*

camuk81

Opps, That didn't quiet work out!

Jemma cheers for the cheer on! Despite falling off the wagon and spending more then I should have (i.e. £60 at the weekend), Have worked out I might be debt free by end of November's payday!

Got a date on the house sale but will I see any money in the bank not counting it!