Search:

Type: Posts; User: Joesif; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Thread: Vba

    by Joesif
    Replies
    2
    Views
    310

    Re: Vba

    Thanks for the reply some great advice for me to start with
  2. Thread: Vba

    by Joesif
    Replies
    2
    Views
    310

    Vba

    Hi

    I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find...
  3. Thread: Office Insider

    by Joesif
    Replies
    5
    Views
    316

    Re: Office Insider

    Ok mate thanks for your help anyways
  4. Thread: Office Insider

    by Joesif
    Replies
    5
    Views
    316

    Re: Office Insider

    Thanks Fluff,

    I think I am going to have to speak to my IT as when i try to log in I get the message

    That Microsoft account doesn't exist. Enter a different account or get a new one.

    So I...
  5. Thread: Office Insider

    by Joesif
    Replies
    5
    Views
    316

    Office Insider

    Hi

    I have excel at work and we use the office 365. Is it possible for me to sign up to be an office insider does anybody know because I can't work out what I need to do and if it is even...
  6. Replies
    5
    Views
    290

    Re: FORM n00bie question

    Yes

    the model table is a list of all codes with a description so if this was excel on the order tab i would do a vlookup to find the description using the model book code entered. But i want this...
  7. Replies
    5
    Views
    290

    FORM n00bie question

    I'm a complete n00b to access and have a simply question.

    I have 2 tables one for entering orders. The other had a list of model codes with the description at the side.
    On a form i have created...
  8. Replies
    8
    Views
    217

    Re: pleas i need your help guys

    See link, I've screenshot the formula for you


    Hope it helps
    http://tipstersleague.webs.com/SUMIFS.png
  9. Thread: Macro

    by Joesif
    Replies
    6
    Views
    296

    Re: Macro

    Sub Mail_ActiveSheet()
    ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010
    Dim FileExtStr As String
    ...
  10. Thread: Macro

    by Joesif
    Replies
    6
    Views
    296

    Re: Macro

    Hi Bertie

    The code was working perfect and again thanks for all your help. However now the macro is sending a blank email with nothing attached! I've remade the macro from your code but it's still...
  11. Thread: Macro

    by Joesif
    Replies
    6
    Views
    296

    Re: Macro

    Thanks Bertie this is PERFECT! :)

    One more thing I am looking to do though, when the file sends I want the contents of cell A4 to be on the name of the file thats sent so sFilename =...
  12. Thread: Macro

    by Joesif
    Replies
    6
    Views
    296

    Macro

    Hi All

    I'm after a macro that Copies a single sheet from a workbook onto a new workbook on its own to reduce the size of the file. And start to send on outlook. But also I need the macro to check...
  13. Thread: Football Stats

    by Joesif
    Replies
    2
    Views
    377

    Re: Football Stats

    This looks perfect!

    Thanks Andrew
  14. Thread: Football Stats

    by Joesif
    Replies
    2
    Views
    377

    Football Stats

    Morning All

    I have a spreadsheet which looks at all different stats taken from a website. I get the data in Excel form from here...
  15. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    Thanks ever so much Ramanan,

    I used the Countifs option you gave me above to pick up the extra column.
    =COUNTIFS($C$2:$C$17,">"&C2,$A$2:$A$17,A2,$B$2:$B$17,B2)+1

    Joe
  16. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    http://tipstersleague.webs.com/data2.png

    Would you be able to adapt the same formula to use two columns as the criteria, so above 105 100 93 and 88 would all be ranked 1

    Thanks
    Joe
  17. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    Spot on, Thanks Ramanan
  18. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    Be ideal if excel had rankif or rankifs functions :)
  19. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    in column C for the rankings
  20. Replies
    10
    Views
    928

    Re: RANKING using Criteria

    http://tipstersleague.webs.com/data.png

    So basically I'd like to rank all rankings but only rank ratings with the same date, so 105 and 100 will both be rank 1

    Thanks
    Joe
  21. Replies
    10
    Views
    928

    RANKING using Criteria

    Hi All,


    I'm wanting to Rank a set of figures in one column but use criteria in another column to pick up the array which is used. I don't want any figures to be ignored so will have multiple...
  22. Thread: Lucky 63 bet

    by Joesif
    Replies
    14
    Views
    5,715

    Re: Lucky 63 bet

    http://tipstersleague.webs.com/Leicester LUCKY63.xlsx
  23. Thread: Lucky 63 bet

    by Joesif
    Replies
    14
    Views
    5,715

    Re: Lucky 63 bet

    I run a horse racing league on facebook, this is a lucky 63 comp i also ran
    http://tipstersleague.webs.com/Leicester LUCKY63.xlsx
  24. Thread: Lucky 63 bet

    by Joesif
    Replies
    14
    Views
    5,715

    Re: Lucky 63 bet

    Sent mate
  25. Thread: Lucky 63 bet

    by Joesif
    Replies
    14
    Views
    5,715

    Re: Lucky 63 bet

    I've made one now guys, made it so I can have an EW lucky 63 too
Results 1 to 25 of 62
Page 1 of 3 1 2 3