Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2023, 06:30 AM
JustinWorkerBee JustinWorkerBee is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2021
Novice
Trying to sort different values from different categories under other categories
 
Join Date: Apr 2023
Posts: 2
JustinWorkerBee is on a distinguished road
Default Trying to sort different values from different categories under other categories

Good morning,

First post.



I have an excel sheet with different companies on the X axis and different job positions on the Y axis. Additionally, various job positions have different levels based on experience. If the company is hiring that job position, I input their pay into the sheet.

Attachment for example, but this project is dozens of companies and 100+ job positions. Is there a way to display the position, then level, then have any non-zero companies underneath sorted by greatest to least? Attachment with desired output for reference.
Attached Images
File Type: png Salary Sheet Snippet.PNG (8.6 KB, 18 views)
File Type: png Salary Sheet Desired Output.PNG (15.2 KB, 17 views)
Reply With Quote
  #2  
Old 04-24-2023, 07:55 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
please post a sample sheet. Pictures are useless to work with. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 04-24-2023, 08:11 AM
JustinWorkerBee JustinWorkerBee is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2021
Novice
Trying to sort different values from different categories under other categories
 
Join Date: Apr 2023
Posts: 2
JustinWorkerBee is on a distinguished road
Default

Hello,

It is now attached, I'm working with the top and trying to create the bottom through anyway faster than manually.
Attached Files
File Type: xlsx Salary Sheet Example.xlsx (11.7 KB, 3 views)
Reply With Quote
  #4  
Old 04-24-2023, 10:46 PM
ArviLaanemets ArviLaanemets is offline Trying to sort different values from different categories under other categories Windows 8 Trying to sort different values from different categories under other categories Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Your design is not meant for getting info from your tables easily. Consider a design I applied as example of better one.
Attached Files
File Type: xlsx Salary Sheet Example.xlsx (23.5 KB, 1 views)
Reply With Quote
  #5  
Old 04-24-2023, 10:49 PM
ArviLaanemets ArviLaanemets is offline Trying to sort different values from different categories under other categories Windows 8 Trying to sort different values from different categories under other categories Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Your design is not meant for getting info from your tables easily. Consider a design I applied as example of better one.

In Salaries Table, you preferably hide the column RecNo - it being visible only confuses user.

About getting info sorted, for easier cases you can use sort and filter options on Salaries Table. For more sophistcated cases, you can design report sheets, where proper Salaries Table RecNo value for report table row are calculated to hidden column in report table, and like on Entry sheet, this RecNo value is used to read wanted data from Salaries Table.
Reply With Quote
  #6  
Old 04-24-2023, 11:49 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Which is the table with your source data?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #7  
Old 04-25-2023, 02:55 AM
p45cal's Avatar
p45cal p45cal is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Your source data is already like a pivot table so needs some re-organisation in the background before presenting it to the user.
In the attached are two offerings (both use Power Query).
I've made the source data into a proper Excel table. I've also added a line to that source data to make sure that multiple positions for the same Position/Level/Company but different Pay are properly handled.

1. A Pivot table at cell G19. This is a bit of a cheat because I've hidden column J of the sheet because I'm not really using the pivot table to summarise data but to display it in a different way, so the Index column ensures that records remain separate. A bit messy.

2. A Power Query table at cell M19. This is more straightforward and more robust. There's just one tweak I made to that result table, I added conditional formatting in the first two columns to hide repeating items so that it looks a bit like what you wanted.

Both solutions need to be refreshed should the source data be changed. Use the Refresh All button on the Queries and Connections section of the Data tab of the ribbon.
Attached Files
File Type: xlsx msofficeforums50784Salary Sheet Example.xlsx (25.8 KB, 2 views)
Reply With Quote
  #8  
Old 05-31-2023, 07:45 AM
p45cal's Avatar
p45cal p45cal is offline Trying to sort different values from different categories under other categories Windows 10 Trying to sort different values from different categories under other categories Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

So nice when people acknowledge the help people have tried to give them…
Reply With Quote
Reply

Tags
sort worksheet, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting: Sort Categories, and Then the Items in Each Category? tatihulot Word 1 05-12-2022 06:37 PM
Trying to sort different values from different categories under other categories Dynamic Categories stephen_ Excel 4 07-03-2013 01:38 AM
Categories disappear PattiL Outlook 0 08-05-2011 08:34 AM
Using categories Matelot Outlook 3 10-14-2010 07:32 PM
Categories disappeared? markg2 Outlook 1 08-02-2010 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft