Anyone an Excel guru? - Necrotalk.com

Announcement

Collapse
No announcement yet.

Anyone an Excel guru?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Anyone an Excel guru?

    Last edited by Doc Hollidazed; 05-15-2008, 01:48 PM.

  • #2
    NM Lashden answered it.

    I will look it up for you in the MS Office book if you need.
    Last edited by Nadori; 06-20-2007, 09:29 PM.
    "You have a moral obligation to be happy." - Dennis Prager

    Comment


    • #3
      Well not exactly...but go to File->Page Setup and then goto the sheet tab. There's an area that says rows to repeat at top. It's below the header I believe but the only way to do what you want as far as I know.

      Comment


      • #4
        http://www.excelforum.com/index.php

        I LIVE there, ha ha! Good luck to ya!
        Semper Fi,
        ---Drazz
        ****************
        Mikaal Drazzminius
        Rodcet Nife by Birth / Quellious by Merger / Povar by Re-Merge

        Necrotalk Admin
        EQ Traders Super Moderator
        EQ Magelo Advisor/Moderator

        Comment


        • #5
          Yeah, I love that Forum. I found it one time when I needed assistance changing normal date formats to Julian Dates (which we use in Military Aviation, almost exclusively). Later on, I needed a one cell formula to count how many of my aircraft hadn't flown within the past 30 days... I ended up with this as my formula:

          Code:
          =SUM(IF(D7:D28<>"",IF(ISNUMBER(D7:D28+0), IF(DATE(LEFT(TEXT(D7:D28,"00000"),2)+100, 1,RIGHT(D7:D28,3))+29< AK4,1))))
          Now THAT is a formula, ha ha!

          Gratz on your macro!
          Semper Fi,
          ---Drazz
          ****************
          Mikaal Drazzminius
          Rodcet Nife by Birth / Quellious by Merger / Povar by Re-Merge

          Necrotalk Admin
          EQ Traders Super Moderator
          EQ Magelo Advisor/Moderator

          Comment

          Working...
          X