Results 1 to 9 of 9

populate row information based on cell condition or cell value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    populate row information based on cell condition or cell value

    Hello Friends,

    Policy in row 2 is 49 months old and should be relegated to a page for policies between 37 and 60 months

    Policy in row 3 is 19 months old and should be relegated to a page for policies between 0 and 30 months old

    Policy in row 4 is 32 months old and should be relegated to a page for policies between 31 and 36 months old

    Column 3 (H) represents policy age.

    I have sample formulae on a flash drive that would give me enough of a refresher on how to figure out this simple formula, but I have a new office and this computer will not recognize the flash drives. I wrote a ticket to IS, but we all know how long that will take. Please be kind an give me a refresher on this.

    Thank you.
    Attached Files Attached Files
    Last edited by opusarlo; 11-02-2015 at 10:15 AM. Reason: newer version posted

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract information from a string and populate in another cell
    By shoniaml in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-22-2013, 04:29 AM
  2. Populate cells with specific information based on one cell
    By MrMims in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2013, 02:25 PM
  3. Populate data based on cell information
    By famico78 in forum Excel General
    Replies: 6
    Last Post: 04-04-2013, 06:11 PM
  4. [SOLVED] What can I use to populate a cell using information in other cells?
    By rcabunac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2012, 09:21 AM
  5. Populate a cell based on another cells condition
    By verder27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2012, 12:36 AM
  6. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 PM
  7. how to populate information from one excel to another cell to a specified cell
    By david_benjamin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2011, 01:15 PM
  8. Replies: 2
    Last Post: 08-02-2010, 09:25 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