+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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