Search:

Type: Posts; User: 2rrs; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Query from earlier version of excel does not work with Excel

    g'afternoon; it has been awhile since i've posted; but i am stuck as i am not familar with macros and queries.

    I downloade a file from the web which pulls stock data from Yahoo.

    when I open the...
  2. Replies
    6
    Views
    699

    also check here!! ...

    also check here!!

    http://www.mrexcel.com/board2/viewtopic.php?t=72395
  3. Using Barry's setup for Bob, Bill and Tom; this...

    Using Barry's setup for Bob, Bill and Tom; this should give you the totals for the last 6 entries in Row 3, 5 and 7.

    Bob =SUM(OFFSET(B3,0,COUNTA(3:3)-6,1,6))
    Bill ...
  4. Re: Copy formula in E25 down to last row in column

    How abt a formula something like this:
    =IF(A2="","","your condition") fill down as far as you like
  5. Thread: Importing problem

    by 2rrs
    Replies
    5
    Views
    479

    Hmmm, I just tried the replace feature with...

    Hmmm,

    I just tried the replace feature with this: 3-0573-0188-03-6



    and it returned this: 305730188036
  6. Thread: Importing problem

    by 2rrs
    Replies
    5
    Views
    479

    Have you tried the replace feature? go to edit...

    Have you tried the replace feature?

    go to edit replace:
    replace what -

    replace with: "leave this blank"
  7. Replies
    4
    Views
    418

    select ten rows; then right click and choose...

    select ten rows; then right click and choose insert
  8. You might try adding a helper col with: ...

    You might try adding a helper col with:

    =MONTH(D3)*100+DAY(D3) (use to sort by month day date)
  9. Replies
    2
    Views
    517

    Also check the "Mortgage Professor" site for...

    Also check the "Mortgage Professor" site for several spreadsheets.

    http://www.mtgprofessor.com/
  10. Thread: Military Members

    by 2rrs
    Replies
    38
    Views
    1,881

    Try this link: www.excel-vba.com Look for...

    Try this link: www.excel-vba.com

    Look for Dynamic reporting

    There is a sample spreadsheet setup that will do what you are looking for.

    There is no VBA (macro) in this workbook, He just uses...
  11. Replies
    3
    Views
    568

    check the Mortgage Professor" site for several...

    check the Mortgage Professor" site for several spreadsheets
  12. Replies
    3
    Views
    391

    Have a look here:...

    Have a look here:
    http://www.cpearson.com/excel/colors.htm
  13. Replies
    3
    Views
    391

    Have a look here:...

    Have a look here:
    http://www.cpearson.com/excel/colors.htm
  14. Thread: calculating dates

    by 2rrs
    Replies
    4
    Views
    341

    =IF(date-TODAY()

    =IF(date-TODAY()<=30,"Due","")

    this will give 30 days notice
  15. Thread: deleting spaces

    by 2rrs
    Replies
    4
    Views
    383

    sim to Nimrods suggestion: type "alt+255" or...

    sim to Nimrods suggestion:

    type "alt+255" or "alt+160" in the "Find What" text box
  16. Perhaps some variation of this: Change Mary J....

    Perhaps some variation of this:

    Change Mary J. Smith
    to Smith, Mary J.

    =SUBSTITUTE(MID(A6,FIND(".",A6)+2,100),".","")&", "&LEFT(A6,FIND(".",A6))
  17. Replies
    3
    Views
    489

    You could try something like this: ="Contact #...

    You could try something like this:

    ="Contact # "&COUNTIF($A$2:A35000,A2) and fill down.

    this will return Contact # 1, Contact # 2, Contact #..... for each email address.
  18. Thread: display year?

    by 2rrs
    Replies
    3
    Views
    282

    Re: display year?

    Custom format "yyyy"
  19. Thread: Calulating a date

    by 2rrs
    Replies
    19
    Views
    740

    Have a look here:...

    Have a look here:
    http://www.mrexcel.com/board2/viewtopic.php?t=92622
  20. Re: Only wanting certain text to be allowed as input

    Try giving your list a "named range"
  21. Re: How do you write multiple conditions in an IF statement

    see if this helps;
    http://personal-computer-tutor.com/if2.htm
  22. Replies
    3
    Views
    410

    Re: Adding a formula to a header is it possible?

    One way;
    Name the sheet "Roster for November"
    Then use custom header and select "Tab"
  23. Replies
    5
    Views
    366

    One way: enter in a cell of your choice: ...

    One way:
    enter in a cell of your choice:

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
  24. Replies
    3
    Views
    422

    You may find this of some use. They have a...

    You may find this of some use.
    They have a biweekly spreadsheet available

    http://www.mtgprofessor.com/spreadsheets.htm
  25. Replies
    10
    Views
    1,478

    ASAP Utilities also has this capability and many...

    ASAP Utilities also has this capability and many other features,

    Found here:
    http://www.asap-utilities.com/
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4