+ Reply to Thread
Results 1 to 3 of 3

Extract cell's contents to form raw data

  1. #1
    Registered User
    Join Date
    07-27-2018
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    13

    Extract cell's contents to form raw data

    Hello dear forum members,

    I'm trying to create a report for my monthly bills. I want to copy the invoice for water supply and extract automatically the numbers in a second tab where I can see historical data. The challenge:
    1) when I paste the invoice in the first tab, the data may not be in the same cells as for previous months
    2) some fields contain numbers and text and in the second tab only numbers are necessary

    Could you please help me with these challenges?
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Extract cell's contents to form raw data

    Please try at
    A2
    =IFERROR(MID(INDEX(Input!$A:$A,AGGREGATE(15,6,ROW(Input!$A$1:$A$1000)/ISNUMBER(FIND(A$1,Input!$A$1:$A$1000)),ROWS(A$2:A2))),15,10),"")

    I use different formula for each column, please see attached.
    this only work if data is in the same column, for next month data just paste to column A
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-27-2018
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    13

    Re: Extract cell's contents to form raw data

    Hello Bo_Ry,

    thank you very much!

+ 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. [SOLVED] Simple Extract cell contents per input conditions
    By Sekars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2017, 02:04 AM
  2. [SOLVED] How to extract certain contents in a cell
    By banker123 in forum Excel General
    Replies: 3
    Last Post: 04-16-2014, 10:04 AM
  3. [SOLVED] Extract some contents from cell
    By plasma33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 05:26 AM
  4. Extract cell contents separated by either a space, an & or by ,
    By novodisc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2011, 12:08 AM
  5. Extract contents of cell if greater than zero to a comment
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2009, 05:54 PM
  6. Extract cell contents to multiple rows
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2009, 12:42 PM
  7. Lookup and extract contents from a cell
    By makku in forum Excel General
    Replies: 2
    Last Post: 02-04-2009, 05:18 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