Results 1 to 7 of 7

How to reduce a large group of data

Threaded View

  1. 12-12-2018, 12:09 PM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to reduce a large group of data

    Forget that. It was easy to replicate...

    =OFFSET(A$1,(ROWS($1:1)-1)*5,,)

    copied across and down. You may need ; instead of ,
    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. Generate random group of words in a cell from a large group word list in column
    By faizzsheikh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2018, 10:16 AM
  2. [SOLVED] Can't reduce code as my procedure is too large.
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-24-2017, 06:43 AM
  3. Trying to sort and group two different columns - large amounts of data...
    By greg428 in forum Excel General
    Replies: 2
    Last Post: 03-31-2017, 01:07 PM
  4. Repeated Summation of group of numbers in large number of data
    By dimuthumme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2014, 05:43 PM
  5. [SOLVED] VLOOKUP and LARGE (MAX?) - Finding the largest value in each group of data....
    By titushanke in forum Excel General
    Replies: 9
    Last Post: 04-28-2012, 06:12 AM
  6. Adding a number to a large group of data
    By razza in forum Excel General
    Replies: 3
    Last Post: 07-22-2008, 05:01 AM
  7. Adding a number to a large group of data
    By razza in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 12:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1