+ Reply to Thread
Results 1 to 2 of 2

Formula works halfway?

  1. #1
    Registered User
    Join Date
    10-24-2006
    Posts
    8

    Formula works halfway?

    = INDIRECT(ADDRESS(ROW(A1)*6-6+COLUMN(B1)-1,1)

    Thats the formula i used to transfer a column of over 10k cells into 6 columns that sorted the information. However I can across a problem. Around 1/10th of the list down the first column randomly skipped 3 row lines and is producing the wrong information now...how can this be corrected

    Side Note. I inserted two cells into the list of 10k cells to correct the transposition because one of the patients left out a state and email and it threw the list off.


    Thankks for the help

  2. #2
    Registered User
    Join Date
    10-24-2006
    Posts
    8

    nvm

    got everything to work thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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