Attention: Please take a moment to consider our terms and conditions before posting.
Options

The paste game

24

Comments

  • Options
    BR7_addickBR7_addick
    INTER-CO
  • Options
    cafc4lifecafc4life
    do i have gonnorhea?
  • Options
    ForeverAddicktedForeverAddickted
    cafc4life said:

    do i have gonnorhea?

    This is a Charlton forum mate... No Arsenal fans here so far as am I'm aware
  • Options
    Sonicstud85Sonicstud85
    Bolton v QPR
    Brentford v Derby
    Fulham v Charlton
  • Options
    man_at_millettsman_at_milletts
    a to the g and the f to the ...what comes next?
  • Options
    PL54PL54

    Someone in a black and white scarf gets abused by a pisst Charlton fan
  • Options
    OaksterOakster
    tortillas
  • Options
    Brendan_O_ConnellBrendan_O_Connell
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    If you're copying and pasting those formulas you are cheating!! You should be writing them in as you go along! :wink:
  • Options
    sam3110sam3110
    http://www.f1fanatic.co.uk/2016/02/19/compare-ferraris-new-sf16-h-with-their-2015-car/
  • Sponsored links:


  • Options
    Karim_myBagheriKarim_myBagheri
    PL54 said:


    Someone in a black and white scarf gets abused by a pisst Charlton fan

    you cut and pasted your own post?
  • Options
    thai malaysia addickthai malaysia addick
    away
  • Options
    A-R-T-H-U-RA-R-T-H-U-R
    What's the legal age of consent because I am an International football player with a beautiful girlfriend and so incredibly stupid it defies belief, please Siri
  • Options
    IAIA
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
  • Options
    North Lower NeilNorth Lower Neil
    Streatfeild
  • Options
    stackitstevestackitsteve
    IA said:

    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
    Why would you have copied that?
  • Options
    North Lower NeilNorth Lower Neil
    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP
  • Options
    ForeverAddicktedForeverAddickted
    IA said:

    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
    Didnt need to do the VLOOKUPs for that particular cell... Paranoid over the error now as the formula worked fine lol!
  • Options
    eaststandmikeeaststandmike
    When are Sheff Utd going to come good?
  • Sponsored links:


  • Options
    ForeverAddicktedForeverAddickted
    ADAPTED from I Had To Survive
  • Options
    BR7_addickBR7_addick
    North Lower Neil said:

    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP

    I've also been looking at hotels in Tunbridge Wells this morning.
  • Options
    ForeverAddicktedForeverAddickted
    BR7_addick said:

    North Lower Neil said:

    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP

    I've also been looking at hotels in Tunbridge Wells this morning.
    Ooo are there two Lifers planning a secret lil rendezvous?
  • Options
    LouisMendLouisMend
    x-maps-mapitemhandles://YnBsaXN0MDDSAQIDBV8QFk1LTWFwSXRlbUxhdW5jaEhhbmRsZXNfECVNS01hcEl0ZW1MYXVuY2hBZGRpdGlvbnNMYXVuY2hPcHRpb25zoQRPEOUIARLgARoSCTkKEAUz40pAEQkWhzO/qgXAIoQBCg5Vbml0ZWQgS2luZ2RvbRICR0IaB0VuZ2xhbmQqCkxhbmNhc2hpcmUyB1ByZXN0b246B1BSMiAzRUJCB0Z1bHdvb2RSDUdhcnN0YW5nIFJvYWRaAzExMWIRMTExIEdhcnN0YW5nIFJvYWRyDUdyZWF0IEJyaXRhaW6KAQdGdWx3b29kKhExMTEgR2Fyc3RhbmcgUm9hZDIRMTExIEdhcnN0YW5nIFJvYWQyB1ByZXN0b24yB1BSMiAzRUIyB0VuZ2xhbmQ4OUAA0QYHXxAkTUtMYXVuY2hPcHRpb25zUmVmZXJyYWxJZGVudGlmaWVyS2V5XxATY29tLmFwcGxlLm1vYmlsZWNhbAAIAA0AJgBOAFABOAE7AWIAAAAAAAACAQAAAAAAAAAIAAAAAAAAAAAAAAAAAAABeA==
  • Options
    Atletico AddickAtletico Addick
    Sport Shield Group Consortium
  • Options
    Its_Hamer_TimeIts_Hamer_Time
    One is swollen, and the other has gone blue
  • Options
    PL54PL54
    Karim_myBagheri said:

    PL54 said:


    Someone in a black and white scarf gets abused by a pisst Charlton fan

    you cut and pasted your own post?
    If you remember, which you clearly do, it topped and tailed my woefully wrong match prediction. Too busy for double typing.
  • Options
    RedPandaRedPanda
    Nottata e mattinata agitate per il Milan e per Mario Balotelli, prima della grande sfida di stasera con il Napoli. In ritiro come sempre nella storica sede dell'Hotel Vesuvio, la squadra rossonera ha ricevuto la visita di un numeroso gruppo di tifosi azzurri - sui trecento, età media molto bassa - che hanno cominciato a bivaccare, facendo rumore con cori contro la squadra, e trombette. E i cori contro il Milan presto si sono diretti contro l'attaccante, che dalla sua stanza si sarebbe affacciato, rispondendo con un gestaccio. Una replica che non è stata apprezzata dai presenti e che ha fatto aumentare il volume della protesta. La polizia, che era già in zona, ha monitorato da vicino l'accaduto contribuendo a placare gli animi della folla assiepata sull'isola pedonale che circonda l'albergo, in cui sta soggiornando anche De Laurentiis.

    (300 Napoli fans spent last night outside AC Milan's hotel making noise. Mario Balotelli swore at them and made it worse)
  • Options
    Addickted2TheRedsAddickted2TheReds

    Available in resort (for free)

    Bed linen
    Towels
    Dish towels
    Final cleaning (excl. kitchen)
    Cleaning pack
    TV
    Wifi (limited data volume)

    Payable in resort

    Tourist tax: approx. € 1,00 per person/night
    Deposit: €200 apartment

    Available in resort (optional)

    Use of fitness/spa area in the Résidence Les Temples du Soleil (see description)
    Baby facilities
    Underground parking (based on availability): €70/week

  • Options
    LuckyRedsLuckyReds
    edited February 2016
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    Jesus, what's that monstrosity, Excel I guess? (if(<predicate>, <true>, <false>)?) Stunning how an office application is more archaic than some programming languages!

    (pssst.. if I6 is equal to K20, it'll output BO13 and there's no way AI4 will ever output)
Sign In or Register to comment.

Roland Out Forever!