+ Reply to Thread
Results 1 to 3 of 3

Retribution number of text save to index formula

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,278

    Retribution number of text save to index formula

    help.png
    from image i am want save a1:a3 to index
    index(a1:a3)
    if a1 = "help and b1 = 2 then become become {"help","help"}
    if a2 = "from well" and b2 = 3 become {"from well","from well","from well"}
    if a3 = "good lucky" and b3 = 2 become {"good lucky","good lucky"}

    i want save to index =index(a1:a3.....blahbla) and when press F9 become
    {"help","help","from well","from well","from well","good lucky","good lucky"}
    how i can do using formula index
    "ThankyouFor Attention * And Your Help!!"

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Retribution number of text save to index formula

    After 1100 posts you should know that posting a file makes it easier to help...

  3. #3
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,278

    Re: Retribution number of text save to index formula

    Pepe Le Mokko
    this is file
    Attached Files Attached Files

+ 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. Replies: 10
    Last Post: 10-26-2021, 05:36 AM
  2. Index value by number/text in a range with time format
    By excelnabb in forum Excel Formulas & Functions
    Replies: 75
    Last Post: 07-19-2018, 07:55 AM
  3. Text (number) , then csv save changes it back to number
    By 7thMonth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2017, 03:19 PM
  4. Formula Help Needed - Sumifs or Index Match - Text and number formats concatenat
    By DavidW262626 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2017, 02:03 AM
  5. [SOLVED] Can I name the row index number from a lookup formula?
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2013, 04:31 PM
  6. Replies: 2
    Last Post: 11-21-2012, 12:02 PM
  7. Index Formula not pulling in the right number
    By umass02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2009, 08:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1