Results 1 to 6 of 6

Insert value in one column based on info in another column

Threaded View

  1. 03-12-2018, 07:09 AM #1
    sedanstr
    sedanstr is offline
    Registered User
    Join Date
    12-13-2017
    Location
    Sweden
    MS-Off Ver
    Office 365 v2207
    Posts
    8

    Insert value in one column based on info in another column

    Hi

    I need help with a formula.

    I have two colums with data (C and D). I want data to be written in E based on the data in D:
    Find first 5 A. Write A1.
    Find next 8 A. Write A2
    Find next 8 A. Write A3
    Find next 5 A. Write A4
    Find next 8 A. Write A5

    Se attached file what I mean.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract selected column data based on column header info
    By ajay6985 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2017, 02:07 AM
  2. [SOLVED] Calculating info in a column based on a "greater than" date & info in another column
    By fpm2002 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-06-2017, 12:58 AM
  3. Populate Column A based on Info in Column D
    By gbatz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2014, 04:42 AM
  4. [SOLVED] Auto populate main worksheet info to appropriate secondary tabs based on info in column D
    By jingles9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  5. add info to new column based on current column
    By elmobram22 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-14-2013, 03:22 AM
  6. Insert/Update particular column based on background colour of another column
    By onenessboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 03:28 AM
  7. Join Cells in One Column Based on Info in 2nd Column
    By fedorzarkhin in forum Excel General
    Replies: 8
    Last Post: 04-08-2012, 04:18 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1