Results 1 to 4 of 4

formula or code to calculate age band

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    formula or code to calculate age band

    I have Data table with Name, dob, gender, relation and age as per attachment. I also Have Table of Age Band

    I want to Formula or code insert age band in Column F as per age in Column E.

    e.g. cell E2 is 60 hence it fall under age band of 56-60
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula or vba to assign a priceing band to UK postal code.
    By A440 in forum Excel General
    Replies: 15
    Last Post: 11-24-2015, 02:25 PM
  2. [SOLVED] Calculate UK school year band based on student d.o.b
    By M4rk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2015, 09:07 AM
  3. Age Band Formula
    By newbie13 in forum Excel General
    Replies: 4
    Last Post: 05-01-2008, 10:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1