Results 1 to 3 of 3

Table Extract based on Font

Threaded View

Aquamore Table Extract based on Font 09-09-2014, 10:58 AM
Richard Buttrey Re: Table Extract based on... 09-09-2014, 11:20 AM
sktneer Re: Table Extract based on... 09-09-2014, 11:56 AM
  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    49

    Table Extract based on Font

    Hi, I have a table that lists region numbers in column A, month numbers as headers and it's filled with values that represent sales (or blanks if there were no sales in the region in a particular month)
    Some of the sales numbers are in bold font, I need to create a different table that would only include bold values along with the corresponding region number and month. The sample file is attached.
    Tab "Records" has the data, tab "Summary" is what I need to create.
    I would very much appreciated if somebody could help.
    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data based on month/year to a simple table.
    By maax555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2014, 09:55 AM
  2. [SOLVED] extract and maintain font color
    By mqcai4613 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2013, 11:43 PM
  3. Extract values from table based on 2 criterias
    By plamenbv in forum Excel General
    Replies: 0
    Last Post: 09-19-2013, 05:09 AM
  4. [SOLVED] Need a lookup to extract data table based on four criteria & override user input
    By Marvelous in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2013, 12:54 PM
  5. Replies: 59
    Last Post: 07-11-2010, 06:12 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