+ Reply to Thread
Results 1 to 2 of 2

Sperate coloured data

  1. #1
    Registered User
    Join Date
    06-29-2021
    Location
    AUS
    MS-Off Ver
    Microsoft Excel
    Posts
    1

    Post Sperate coloured data

    Hi, I want to show all of the red Scanned data in a separate column and all of the red JDE data in another column.
    Last edited by sammual; 06-29-2021 at 04:54 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Sperate coloured data

    1. Without a sample sheet, that means almost nothing.

    2. Colour is not something that Excel can generally handle well with a formula. it usually needs VBA.

    3. Read the yellow banner (top) about sample sheet and post a SMALL sample with manually calculated expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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] Look and return and sperate part numbers with
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2021, 01:19 PM
  2. Separate Timetables into sperate sheets
    By madmoo84 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-27-2021, 07:41 AM
  3. [SOLVED] Formula to sperate First Name and Last name
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2020, 04:27 PM
  4. Sperate an IP from a String of cell
    By BraveR in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-28-2014, 07:51 AM
  5. How can I count coloured cells (coloured using Conditional Formatting)
    By franfry in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2013, 02:40 PM
  6. VBA Code to insert dynamic data from sperate workbook to chart
    By Policeme21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2012, 04:33 PM
  7. sperate from the space, in text, in the same cell
    By Fam via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2006, 12:25 PM

Tags for this Thread

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