+ Reply to Thread
Results 1 to 2 of 2

Problem on filter with merging cell

Hybrid View

  1. 06-18-2017, 11:13 PM #1
    blanko
    blanko is offline
    Registered User
    Join Date
    06-15-2017
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    5

    Problem on filter with merging cell

    Excel version: 2010

    Currently having problem on showing all my data. The screenshot below shows my objective of filtering 'Completed'. However, there are action that are being cut and only shows the 1st row. My objective is to show all the data when being filter accordingly.


    1:
    \1


    2:
    \1
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 12:15 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,351

    Re: Problem on filter with merging cell

    Hi blanko,

    I think the root of your problem is that you have Merged Cells. You need to put the word in Column A in EACH row. Merged Cells are awful for doing things like filtering data.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merging 3 tables with first column differences + automatic filter? :S
    By Edd78 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 03-14-2014, 08:53 AM
  2. Excel 2010 problem with sort and filter by cell color
    By EDaig in forum Excel General
    Replies: 0
    Last Post: 03-07-2013, 11:58 AM
  3. [SOLVED] Merging Problem - AUTO MERGE?? Help!!
    By privatesinn in forum Excel General
    Replies: 10
    Last Post: 07-09-2012, 04:27 PM
  4. Problem with Macro to filter pivot based on a cell value
    By Scarface in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2011, 07:18 AM
  5. Merging cells/merging cell content.
    By rhintintin in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 10:42 AM
  6. Merging Problem
    By rakeshranjan.scs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2010, 08:39 AM
  7. Complicated Merging Problem
    By Callie in forum Excel General
    Replies: 8
    Last Post: 01-30-2010, 12:19 AM
  8. merging problem
    By matscot in forum Excel General
    Replies: 1
    Last Post: 07-28-2009, 09:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1