Search:

Type: Posts; User: TeejayR

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    1,341

    Re: Excel Assistance

    Yep - that's much simpler to get the total usage.

    By the way my countif formula should be =COUNTIF(D2:AB3,"y") if you wanted to get the svore
  2. Replies
    4
    Views
    1,341

    Re: Excel Assistance

    Have you thought about splitting up the "shooter" into 2 rows then if the 1st shot is a hit (or "Y") then the count is 1 in all other instances the count is 2 by using this formula =IF(D2="y",1,2) D2...
  3. Replies
    12
    Views
    3,989

    Re: Excel 2010 & Dual monitor display

    I think another way to do this is to drag the excel instance across both monitors and the use the Arrange All vertical option to split the windows between the 2 monitors.

    I'm sure I've done this...
  4. Replies
    13
    Views
    2,155

    Re: Wired Ethernet question

    This may be what you want

    http://www.pbtech.co.nz/index.php?z=p&p=NETNCMP204

    Not bad value when you consider it's a 2 pack and the power pass through gives more flexibility
  5. Thread: Excel question

    by TeejayR
    Replies
    4
    Views
    1,199

    Re: Excel question

    Hi - just tried it by entering the time as 4:35

    I then multiplied it by 24 (because excel treats the 4:35 as a percentage of a day) then by $10 and got the answer $45.83 as you had in your...
  6. Replies
    5
    Views
    1,041

    Re: A page within a page - Excel question

    Hi Rob

    I set up one spreadsheet as a right hand side by side view called notes and saved that

    I then opened another spreadsheet and set that up on the left hand side and saved that. Now when I...
  7. Replies
    14
    Views
    7,802

    Re: Excel 2003 - entering/converting date formats

    Sorry - forgot to mention that this macro will treat every cell as being a date input.

    So unless you want to turn the macro off for standard input (by putting a single quote in front of the...
  8. Replies
    14
    Views
    7,802

    Re: Excel 2003 - entering/converting date formats

    But wait there's more....

    I gave this a shot and it works - the red section actually derives the column you are in so there's no need to specify it

    The only thing it does which is funny (but...
  9. Replies
    14
    Views
    7,802

    Re: Excel 2003 - entering/converting date formats

    Hi Jen

    I've had a look at the macro and think I've got it to work for multiple columns

    I adjusted the code - see the bolded text

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    ...
  10. Replies
    14
    Views
    7,802

    Re: Excel 2003 - entering/converting date formats

    HI Jen

    This may be a bit long winded for what you're trying to achieve but it's a way of doing it using an extra column

    Make sure your data entry column is formatted as text and enter your...
  11. Replies
    4
    Views
    1,116

    Re: One for the excel users / gurus

    This macro may help you if no other solution comes to light

    Sub FillComments()
    On Error Resume Next
    For Each cell In Selection.Cells
    cell.AddComment
    cell.Comment.Text...
  12. Replies
    3
    Views
    10,800

    Re: Excel auto number printing

    If you're ok with using macros you can use this it will cycle through and print 51 (1000 to 1050) times based on the 1st Page Number you enter

    Sub Print50Pages()
    Dim PageNumber As Integer
    ...
  13. Replies
    1
    Views
    1,547

    Re: Excel Goal Seek

    Generally what Goal Seek is designed to do is change a factor so you can derive a specified answer e.g. if you had a Car you bought for $5,000 and you wanted to make 10% on it the answer would be...
  14. Replies
    6
    Views
    2,428

    Re: Currency Exchange Rates

    Xe.com is the best I've seen

    You can even download an app from the Android marketplace to keep track of the currencies you follow
  15. Replies
    16
    Views
    5,459

    Re: NETCOMM NB6PLUS4Wn

    Cheers - thought it was to good to be true

    Oh well it's back to price spy then

    Trev
  16. Replies
    16
    Views
    5,459

    Re: NETCOMM NB6PLUS4Wn

    These guys any good to deal with - the price seems really good
  17. Replies
    5
    Views
    1,389

    Re: Excel 2003 help

    If you know how to use the F5 Special function this should work

    Select all your cells on the spread sheet

    Hit the F5 key ten select the Special button

    Select the Constants option on the left...
  18. Thread: Excel help

    by TeejayR
    Replies
    8
    Views
    2,499

    Re: Excel help

    The idea behind this was to display only the rows you wanted to delete via the filter.

    Yo then select all these rows then hit F5 on the keyboard which brings up the GoTo menu in Excel,

    You then...
  19. Thread: Excel help

    by TeejayR
    Replies
    8
    Views
    2,499

    Re: Excel help

    WarNox - I was going to suggest that but my impression was that he wanted to retain a list of 4000 (5000-1000) and a list of 1000

    DeSade - I forgot to say you'll need to copy the formula from row...
  20. Thread: Excel help

    by TeejayR
    Replies
    8
    Views
    2,499

    Re: Excel help

    You could use the vlookup formula in the 5000 sheet to find the names in the 1000 sheet and where they exist you could just delete them.

    Assuming the names are in column A in both sheets starting...
  21. Replies
    13
    Views
    21,978

    Re: Connecting My Sky Hdi on 2 TV's?

    We had the same problem when we installed the HDI version of MySky

    Now they have to provide a separate RF splitter which connects to the MySky box via Line In sockets.

    Can't remember if there...
  22. Replies
    7
    Views
    1,831

    Re: Combine HDD partitions

    Try this for changing your My Documents folder location.

    As for combining partitions unless Windows 7 has the option you'll probably have to delete the E partition then expand the D partition. You...
  23. Re: Is this a good deal from DSE? WD Elements 1TB Desktop Hard Drive

    Billy T - I had the same issue just put XH1210 in the search box at the top
  24. Replies
    6
    Views
    4,334

    Re: Need help with Excel 2007 IFTHEN function?

    If I've read this right you are wanting to copy the date of it is the 21st of a month.

    This formula works - it copies the date if the first characters are 21 - it is set up to work with the cell...
  25. Thread: trusted macros

    by TeejayR
    Replies
    5
    Views
    1,643

    Re: trusted macros

    I've always found that when it set this up to use macro's (option 4) you have to tick "Trust access to the VBA project object module" as well if you are to use macros provided by other sources.

    I...
Results 1 to 25 of 126
Page 1 of 6 1 2 3 4