Results 1 to 7 of 7

Classify data values

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2010
    Location
    Torino, Italy
    MS-Off Ver
    Excel 2003
    Posts
    4

    Classify data values

    Hi,
    I'm new on this forum and not a Excel expert... so I'd like your help to solve the following problem...

    I have a list of years, e.g.:

    1420, 1460, 1500, 1500, 1500, 1580, 1600, 1600, 1670, ...

    and I have a list of year ranges, e.g:

    1400/1500 (1), 1500/1600 (2), 1600/1700 (3), ...

    I'd like automatically to assign each year to his range of belonging using some formula. For the example above the result should be:

    (1), (1), (1), (1), (1), (2), (2), (2), (3)

    Maybe with the attached file is easier to understand the example...

    Thanks in advance...
    Attached Files Attached Files
    Last edited by s82938; 07-12-2010 at 02:34 PM.

Thread Information

Users Browsing this Thread

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

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