Results 1 to 13 of 13

Rearranging vertical data to horizontal

Threaded View

  1. #5
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Office 365
    Posts
    225

    Re: Rearranging vertical data to horizontal

    I am not sure what it is but something is missing
    Look at row 439

    That's what I have on AA4
    =IFERROR(INDEX(I$4:I$1081,SMALL(IFERROR((ROW($4:$1081)-3)/(($H$4:$H$1081="Blistering")*($F$4:$F$1081=$F4)),FALSE),1)),"")
    Blistering.jpg
    Last edited by mq1973; 08-28-2017 at 07:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 16
    Last Post: 06-01-2017, 06:01 PM
  2. Horizontal Data to Vertical
    By mmagnin in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-18-2014, 12:45 AM
  3. [SOLVED] Horizontal data in vertical
    By ashfaquebwd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2013, 03:50 AM
  4. convert data horizontal to vertical
    By vorabha in forum Excel General
    Replies: 8
    Last Post: 02-10-2013, 03:53 PM
  5. Vertical to Horizontal data help!
    By hbrown78 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2012, 09:57 PM
  6. [SOLVED] Data horizontal to vertical
    By sureshpunna in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-27-2012, 03:36 AM
  7. [SOLVED] Vertical to Horizontal data
    By trosasco in forum Excel General
    Replies: 5
    Last Post: 06-15-2012, 08:48 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