Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2017, 12:28 AM
edinn10 edinn10 is offline How to filter in excel? Windows 10 How to filter in excel? Office 2016
Novice
How to filter in excel?
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default How to filter in excel?

Hi,



I have an excel file with more than 800 contacts,
they are many duplicates also Uniques,

what I want is to filter by company,
First I want unique contacts, then again other Uniques,

So 1st group unique than again another group unique till the end,
the group below the group.

Hope you understand,

Screenshoot!

Reply With Quote
  #2  
Old 05-27-2017, 05:53 AM
NoSparks NoSparks is offline How to filter in excel? Windows 7 64bit How to filter in excel? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Sorry, don't understand.

For sample data, and something to work with, here is the file you linked to in your previous question.
Perhaps if you manually fill in the first 10 or 20 rows on the third sheet with the results you expect it will help to figure out what you're requesting.
Attached Files
File Type: xlsx Edinn10_desired_results.xlsx (55.2 KB, 13 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter in excel? Excel 2016 Filter Help Maxer49 Excel 2 04-14-2017 06:24 AM
how to filter column by last working day in excel AC PORTA VIA Excel Programming 17 02-20-2017 06:07 PM
Google "=Filter()" function excel equivalent. Sadodare Excel 0 08-01-2016 11:15 AM
How to filter in excel? =filter() feature of google sheets not in EXCEL peter.threepins Excel 1 07-13-2016 08:44 AM
How to filter in excel? Filter Mail Merge based on a list of filter criteria AusSteelMan Mail Merge 2 05-09-2016 03:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 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