+ Reply to Thread
Results 1 to 5 of 5

Filtering data causing formatting issues

  1. #1
    Registered User
    Join Date
    01-08-2021
    Location
    Bosnia and Herzegovina
    MS-Off Ver
    2019
    Posts
    1

    Unhappy Filtering data causing formatting issues

    I have a project for uni that I have to do but these 2 problems are standing in my way.
    • I have a picture of what the table should look like after it's been filtered
    admir-001831.png
    Here you can see that I need to have 2 tables side-by-side. Left table is sorting data based on value from it's furthest right column "Cijena lijeka u KM sa PDV-om" from highest to lowest. That's no problem I did that easily. But when I try to do the right one I always end up with same problem.
    • Right one should be filtering data so that it shows only values greater than 4 (based on it's furthest right column "Cijena lijeka u KM sa PDV-om"). Here is the problem I encounter when I apple the filter
    admir-001830.png
    Rows 4 and 5 were merged together in each column separately but when I apply the filter only row 4 is showing and even it's own height is smaller. Second problem is that now both of my tables are filtering data "greater than 4" when only my right one should be filtering and my left one should be left intact only sorting from highest to lowest.

    If anybody knows what is causing this, me or excel, I would greatly appreciate any suggestion.

    **Second this -problem- is more of a question. Is it possible to filter data from Sheet1 and automatically copy filtered data -table- on Sheet2?

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,962

    Re: Filtering data causing formatting issues

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,144

    Re: Filtering data causing formatting issues

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you today: https://www.excelguru.ca/forums/show...matting-issues.)

    Two more:

    https://www.mrexcel.com/board/thread...ssues.1157912/

    and

    https://www.myonlinetraininghub.com/...matting-issues
    Last edited by AliGW; 01-09-2021 at 10:49 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,962

    Re: Filtering data causing formatting issues

    Oops, didn't see it Sorry - Deleted by me
    Last edited by Pepe Le Mokko; 01-10-2021 at 03:46 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,144

    Re: Filtering data causing formatting issues

    Thanks, Pepe - that was the first post I linked to in post #3.

+ 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] Adding a conditionnal Copy/Paste function to archive data causing issues with working VBA
    By KomicJ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2020, 07:04 PM
  2. [SOLVED] Lots of conditional formatting causing issues?
    By richard11153 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2020, 11:57 AM
  3. [SOLVED] Facing issues with data filtering || please advise
    By CaptainSpark in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2017, 05:28 PM
  4. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  5. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  6. Copy-Filtering Data (Adv. Filter issues)
    By TechCredit in forum Excel General
    Replies: 5
    Last Post: 09-14-2014, 11:28 PM
  7. Formula Issues - Filtering data to new sheet.
    By payne90 in forum Excel General
    Replies: 1
    Last Post: 03-17-2014, 05:48 AM

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