• Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
Menu
  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
  • Latest News
    Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads
  • Latest News
    Excel To VCF Converter 1.1 – Excel To Vcard – 68,000 Downloads
  • Latest News
    Extract Web Page with Tables – Parse HTML Table – Data Mining Tool
  • Latest News
    Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook
  • Latest News
    Web Scraping – Extract Data from Website – To Excel VBA
  • Latest News
    VCF To Excel Converter – Open VCF File – Free 28,000+ Downloads
  • Latest News
    Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
  • Latest News
    Excel VBA – Import Data from Another Workbook – Macro to Query Excel
  • Latest News
    How to Telnet from Excel & Autorun Commands
  • Latest News
    Excel VBA – FTP Transfer – Files Download Upload
  • Latest News
    Microsoft Office – Communicator API – Verify Availability Status
  • Latest News
    Excel IP Address Lookup – Bulk GeoIP Lookup
  • Latest News
    Extract URL Links from Sitemap.xml file using Excel
  • Latest News
    Trace Lost Phone – Even Without Internet – Using SMS
  • Latest News
    Universal VCF to Excel and Excel to Vcard Converter
  • Latest News
    Download Facebook Videos – How To Get YouTube Video Downloader?
  • Latest News
    Block Game Requests On Facebook & Candy Crush Invites
  • Latest News
    How to Get stock prices in Excel? – Best Live Stock Ticker
  • Latest News
    How to Get Historical Stock Quotes In Excel – Google Finance
  • Latest News
    JSON Parser – Convert JSON To CSV – Excel VBA Macro
  • Latest News
    How To Screen Record – in IOS, iPhone, Android, Windows, Mac ?
  • Latest News
    How To Remove Duplicate Values in Excel, Google Sheets?
  • Latest News
    Best Bitcoin Trading Platforms – Cryptocurrency Market
  • Latest News
    Lock System at Scheduled Time with Excel
  • Latest News
    How to control Facebook Addiction? & Whatsapp Addcition
  • Latest News
    2018 – Hack Whatsapp Friends – Status Photos
  • Latest News
    Making SORT More Simple and Faster in Excel with Advanced Options
  • Latest News
    WordPress – Recent Posts Widget with Thumbnail – Without Plugins
  • Latest News
    Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
  • Latest News
    Display Related Posts with Thumbnails in WordPress without Plugins
  • Latest News
    Post to Facebook Timeline through Email
  • Latest News
    100 CryptoCurrency Price – Ticker in Excel – Using VBA
  • Latest News
    Engineering Unit Converter Download – Excel Table – Feet To Meters
  • Latest News
    Android ICS File Viewer – Calendar file View in Exce;
  • Latest News
    Download – Backup Facebook Twitter Gplus Linkedin – Data To PC
  • Latest News
    How to remove #n/a in Excel? – Fixing Vlookup #n/a
  • Latest News
    #NoForwardsDay – New WhatsApp Texting Pattern that Would Make You Go Crazy
  • Latest News
    Sudoku Excel Download – Puzzle Solver – Free Game Help
  • Latest News
    Top 4 Whatsapp Tips and Tricks You Didn’t know Existed
  • Latest News
    Mortgage Calculator – Loan EMI Scheduler
  • Latest News
    Learn How To Code JavaScript in VBA
  • Latest News
    How To Open VCF File – Online VCF Viewers – 4 Easy Ways
  • Latest News
    How To Block Unwanted Text Messages in Iphone?
  • Latest News
    How To Scrap A Website Keywords? – Keyword Scraping Excel
  • Latest News
    Login to Facebook, Twitter, Google+ in IE from Excel
  • Latest News
    Excel Instant Messenger – Microsoft Office Communicator API Library
  • Latest News
    Skyrocket Website Traffic With Reddit
  • Latest News
    Excel Games Free Download – 2048 Tile Game
  • Latest News
    How to Speed Up Google Chrome
  • Latest News
    VBA Code – Create Index of Worksheets – with Links to each Sheet

Fibonacci Sequence Number Generator – Excel Easy Trick

  • What is the Fibonacci Number Sequence?

    Fibonacci series is a sequence of numbers. Any number in the list is a sum of last 2 numbers ahead of it (i.e., Last 2 preceding numbers).

    This series can be generated in Excel using 2 methods.

    1. Using Excel VBA code
    2. Using Auto-fill & Sum Formula

    In both methods, for a Fibonacci sequence, the first two numbers have to be explicitly mentioned. Sample series: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55 … n.

    Fibonacci Sequence Tool

    There is special formula to find the Nth number in a Fibonacci series. But, in this article, we are just going to look at how to generate the series with Excel Macro.

    1. Open a new Excel workbook.
    2. Enter ‘0’ in A1, ‘1’ in A2. ’10’ in C3.
    3. Press Alt+F11 to view VB editor.
    4. Copy paste below code.
    5. Press F5 to execute the code.

    Fibonacci Sequence Number Generator
    Visual Basic
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    Sub Generate_Fibonacci_Series()
        Dim n1 As Double, n2 As Double, nTot As Double
        Dim iRow As Double, Fibonacci As Double
        
        n1 = ThisWorkbook.Sheets(1).Cells(1, 1) 'Enter First Number in Series
        n2 = ThisWorkbook.Sheets(1).Cells(2, 1) 'Enter Second Number in Series
        nTot = ThisWorkbook.Sheets(1).Cells(1, 3) 'Enter Total Numbers in Series
        iRow = 2
        
        'Generate Fibonacci Series
        While (nTot - 2) > 0
            Fibonacci = n1 + n2
            ThisWorkbook.Sheets(1).Cells(iRow + 1, 1) = Fibonacci
            
            'Get Next numbers to generate Fibonacci Series
            n1 = ThisWorkbook.Sheets(1).Cells(iRow, 1)
            n2 = ThisWorkbook.Sheets(1).Cells(iRow + 1, 1)
            iRow = iRow + 1
            nTot = nTot - 1
        Wend
        
        MsgBox "Fibonacci Numbers Generated - Code From Officetricks.com"
    End Sub


    Once executed, this will generate Fibonacci series in sheet1.

    Also Read: Excel VBA Convert - Amount (Numbers) To Words - Both US & India Formats

    Fibonacci Series in Excel

    This method used just the Sum formula & Auto-fill option. Using this we can generate any number of Fibonacci list in few minutes.

    1. Type ‘0’ in Cell A1.
    2. Type ‘1’ in Cell A2.
    3. Enter ‘=A1 + A2’ in Cell A3.
    4. Select cell A3.
    5. Drag the formula to N number of cells to get Fibonacci series.

    We can change the first & second number to automatically get other Fibonacci numbers changed in order.

    Author: Kumarapush

    Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.

    View all posts by Kumarapush | Website


    Previous Post: Microsoft Excel – Show Developer Tab – Enable VBA Macro Option
    Next Post: Consolidate Data – In Excel Files – Create Summary Report


Post Categories
Popular Posts
Export Outlook Emails To Excel...
Excel To VCF Converter 1.1 –...
Extract Web Page with Tables –...
Send Mass Email from Excel VBA...
VCF To Excel Converter –...
Web Scraping – Extract Data...
Print Screen Automation –...
Excel VBA – Import Data from...
How to Telnet from Excel &...
Excel VBA – FTP Transfer...
Microsoft Office – Communicator...
Excel IP Address Lookup –...
Recent Posts
Enable Insert button in Excel greyed disabled show
Excel Insert Button is Disabled...
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates
Excel VBA - Find String in Range...
Excel VBA Convert Amount in Numbers to Words US Dollar Million Indian Rupee Lakhs Crores finance
Excel VBA Convert - Amount (Numbers)...
Excel VBA Code Get Names of All open workbook path Loop through
Excel VBA - Loop Through All Open...
Name Numerology Lucky Number Calculator Baby names Business name
Name Numerology Calculator - Lucky...
Similar Pages
  • Excel VBA Code Get Names of All open workbook path Loop through
    Excel VBA – Loop Through All...
  • Name Numerology Lucky Number Calculator Baby names Business name
    Name Numerology Calculator –...
  • How To type Subscript in Excel Superscript strikethrough underline font
    How To Type Subscript in Excel –...
  • Excel VBA Merge Cells Unmerge Range Selection objects
    Excel VBA – Merge Cells –...
  • Excel VBA Convert Column Letter Alphabet to Number
    Excel VBA – Convert Column...
  • Excel VBA Convert Column Number to Letter Formula
    Excel VBA – Convert Column...
Popular Tags
  • Email Marketing Block Apps in FaceBook Task Manager print screen VCF HTML Table Import Data Candy Crush Outlook Record Macro android app development SEO Convert URL to IP HTML/ Javascript QR Code Generation VCARD Timer in Excel Countif Google+ bitcoin vba color index vba color codes Data Mining Android social media Twitter bulk email Google Adsense Tips Excel VBA Calendar in Excel Excel Macro WhatsApp Facebook mass email outlook vba Wordpress
FREE Tech Updates

Home

  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling

Trending Topics

    • Learn How to Access WhatsApp in Web
    • Compare Data In Two Excel Sheets
    • Find IP Address Location – GeoIP Lookup
    • Lock a Folder In Windows Using This Simple Excel Macro Trick
    • Download Free Tool to Convert VCF Contacts to Excel

Join Us

Copyright © 2018 OfficeTricks.com