LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dimmer
 
Posts: n/a
Default Double filtering

Hi everyone

I have two columns with non-numerical data that is repeating over 100 rows
(soon we're going to get over 1,000 new observations):

1. Company Name: Fedex, DHL, UPS
2. Country: US, Germany, Belgium etc....

I would like to know for example how many packages sent with Fedex are going
to US, Germany etc.
Of course this can be done with filtering the first column by Company Name
(ex: FedEx), and then counting all the US (second filter), Germany etc........

.... but can I do it in any way with a formula (any double COUNTIF)?

Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keyboard command to replace double clicking the fill handle Pat Excel Discussion (Misc queries) 1 May 18th 05 05:50 PM
How to (re)set a range.value to pass -0- to a "double" variable Dennis Excel Discussion (Misc queries) 2 April 15th 05 11:13 AM
avanced filtering for latest date Joop Excel Discussion (Misc queries) 2 February 15th 05 07:31 AM
Why Excel file doesn't open by double click. Siraj Excel Discussion (Misc queries) 1 February 6th 05 01:58 PM
Using Filtering KellyB Excel Discussion (Misc queries) 2 December 6th 04 09:27 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"