+ Reply to Thread
Results 1 to 3 of 3

Find every 12th cell and insert in column

  1. #1
    Registered User
    Join Date
    12-06-2014
    Location
    Wales
    MS-Off Ver
    2013
    Posts
    2

    Find every 12th cell and insert in column

    Hello,
    I am modifying a csv file using data from another sheet, having split the comma separated values into columns. The data I'm using will be averaged, and these averages will appear every 12 cells down the column. Is there a way to retrieve the data in every 12th cell and insert it into a single column in the csv file, adjacently. The columns in the csv file will then be returned to comma separated format.
    Thanks in advance,
    Brian

    Edit: I've attached a sample file with 3 tabs. First tab is source data with 5-second readings, the other two are csv files with one-minute readings.
    Attached Files Attached Files
    Last edited by Kellogg; 10-01-2015 at 10:28 AM. Reason: Attachment

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Find every 12th cell and insert in column

    Hi,

    Welcome to the forum.

    Can you please post a sample csv file along with a sample excel? Go through the following URL for help on how to upload a file.

    http://www.excelforum.com/members/da...ch-a-file.html

    You may delete the confidential data from the files before upload, if any.

  3. #3
    Registered User
    Join Date
    12-06-2014
    Location
    Wales
    MS-Off Ver
    2013
    Posts
    2

    Re: Find every 12th cell and insert in column

    Hi, I have a pretty bad internet connection here, but I'll try to upload sample files. If I could get suggestions on retrieving every 12th cell and placing it in a column adjacently in the meantime it would be great though..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum every 12th cell works until 12th iteration ... why?
    By thepinkgeologist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2015, 05:45 AM
  2. Re: How to sum every 12th cell in my data
    By thepinkgeologist in forum Excel General
    Replies: 8
    Last Post: 09-25-2015, 11:17 AM
  3. Find cell with value from a column and insert formula in the cell to its left
    By konata in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 05:11 AM
  4. [SOLVED] Find Particular word then insert new entire column before cell.
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 01-31-2014, 02:25 AM
  5. [SOLVED] Making values in one column repeat every 12th row in a different column
    By mfortier3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2013, 06:45 PM
  6. Find 1st unique Value on Column and Insert certain Word on cell on left Column
    By Wldlife23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:02 AM
  7. [SOLVED] Find emty cell in column and insert value
    By Mikus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2005, 09:05 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