Simple excel filtering question and count question.

J

Jwan622

New Member
Joined
Jul 17, 2013
Messages
40
[TABLE="width: 1636"]
<colgroup><col><col span="6"><col><col><col span="12"></colgroup><tbody>[TR]
[TD]id[/TD]
[TD]Buyer[/TD]
[TD]Buyer Email[/TD]
[TD]Seller[/TD]
[TD]Seller Email[/TD]
[TD]Subject Type[/TD]
[TD]City[/TD]
[TD]Transaction Date[/TD]
[TD]Booking Date[/TD]
[TD]Subtotal[/TD]
[TD]Subtotal in USD[/TD]
[TD]Credit Card Fee[/TD]
[TD]Credit Card Fee in USD[/TD]
[TD]Total[/TD]
[TD]Total in USD[/TD]
[TD]Payout[/TD]
[TD]Payout in USD[/TD]
[TD]Number of Guests[/TD]
[TD]user_id[/TD]
[TD]Cuisine[/TD]
[TD]Style of Service[/TD]
[/TR]
[TR]
[TD]5362b30fba4e705a0b000006[/TD]
[TD]Samantha Ressler[/TD]
[TD]samantha.l.ressler@gmail.com[/TD]
[TD]Daniel Benhaim[/TD]
[TD]overtonemirror@gmail.com[/TD]
[TD]Chef[/TD]
[TD]la[/TD]
[TD]2014-05-01 20:48:15 UTC[/TD]
[TD="align: right"]5/2/2014[/TD]
[TD="align: right"]$960.00[/TD]
[TD="align: right"]$960.00[/TD]
[TD="align: right"]$10.80[/TD]
[TD="align: right"]$10.80[/TD]
[TD="align: right"]$370.80[/TD]
[TD="align: right"]$370.80[/TD]
[TD="align: right"]$864.00[/TD]
[TD="align: right"]$864.00[/TD]
[TD="align: right"]12[/TD]
[TD]53604043fac27ba73b000003[/TD]
[TD]American, Japanese[/TD]
[TD]plated_meal[/TD]
[/TR]
[TR]
[TD]5362b2b77177c305e7000002[/TD]
[TD]Stephanie Artner[/TD]
[TD]stephanie.artner@gmail.com[/TD]
[TD]Ozlem Oguzcan[/TD]
[TD]o_oguzcan@hotmail.com[/TD]
[TD]Chef[/TD]
[TD]nyc[/TD]
[TD]2014-05-01 20:46:47 UTC[/TD]
[TD="align: right"]5/14/2014[/TD]
[TD="align: right"]$400.00[/TD]
[TD="align: right"]$400.00[/TD]
[TD="align: right"]$10.50[/TD]
[TD="align: right"]$10.50[/TD]
[TD="align: right"]$360.50[/TD]
[TD="align: right"]$360.50[/TD]
[TD="align: right"]$360.00[/TD]
[TD="align: right"]$360.00[/TD]
[TD="align: right"]10[/TD]
[TD]5344519d9a88d60e03000013[/TD]
[TD]Mediterranean, Turkish[/TD]
[TD]family_style[/TD]
[/TR]
[TR]
[TD]5362aba8bb0e613363000001[/TD]
[TD="align: right"]0[/TD]
[TD]alison.temple@fox.com[/TD]
[TD]Deborah Gorman[/TD]
[TD]deborahgorman@gmail.com[/TD]
[TD]Chef[/TD]
[TD]la[/TD]
[TD]2014-05-01 20:16:40 UTC[/TD]
[TD="align: right"]5/18/2014[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$19.50[/TD]
[TD="align: right"]$19.50[/TD]
[TD="align: right"]$669.50[/TD]
[TD="align: right"]$669.50[/TD]
[TD="align: right"]$585.00[/TD]
[TD="align: right"]$585.00[/TD]
[TD="align: right"]10[/TD]
[TD]535ecdd32b17faf068000001[/TD]
[TD]Greek, Mediterranean[/TD]
[TD]buffet[/TD]
[/TR]
[TR]
[TD]53629a6d8005843f6f000001[/TD]
[TD]Deb Sheff[/TD]
[TD]dslm@comcast.net[/TD]
[TD]Brad Miller[/TD]
[TD]braisedchicken58@yahoo.com[/TD]
[TD]Chef[/TD]
[TD]boston[/TD]
[TD]2014-05-01 19:03:09 UTC[/TD]
[TD="align: right"]6/25/2014[/TD]
[TD="align: right"]$160.00[/TD]
[TD="align: right"]$160.00[/TD]
[TD="align: right"]$4.80[/TD]
[TD="align: right"]$4.80[/TD]
[TD="align: right"]$164.80[/TD]
[TD="align: right"]$164.80[/TD]
[TD="align: right"]$144.00[/TD]
[TD="align: right"]$144.00[/TD]
[TD="align: right"]2[/TD]
[TD]5346fde17ff807af6c000001[/TD]
[TD]American, French[/TD]
[TD]plated_meal[/TD]
[/TR]
[TR]
[TD]5362995140f96b5c92000006[/TD]
[TD]Martha Arciszewski[/TD]
[TD]martha.arciszewski@gmail.com[/TD]
[TD]Ygael Tresser[/TD]
[TD="colspan: 2"]ygael001@yahoo.com[/TD]
[TD]nyc[/TD]
[TD]2014-05-01 18:58:25 UTC[/TD]
[TD="align: right"]5/6/2014[/TD]
[TD="align: right"]$300.00[/TD]
[TD="align: right"]$300.00[/TD]
[TD="align: right"]$9.00[/TD]
[TD="align: right"]$9.00[/TD]
[TD="align: right"]$309.00[/TD]
[TD="align: right"]$309.00[/TD]
[TD="align: right"]$270.00[/TD]
[TD="align: right"]$270.00[/TD]
[TD][/TD]
[TD="colspan: 3"]5362617ea4d90ec0ce000034[/TD]
[/TR]
[TR]
[TD]5362904fd67ee163bc000005[/TD]
[TD]Mitchell Seider[/TD]
[TD]mitchell.seider@lw.com[/TD]
[TD]Boris Dubnov[/TD]
[TD]borisdubnov@me.com[/TD]
[TD]Chef[/TD]
[TD]nyc[/TD]
[TD]2014-05-01 18:19:59 UTC[/TD]
[TD="align: right"]5/3/2014[/TD]
[TD="align: right"]$864.00[/TD]
[TD="align: right"]$864.00[/TD]
[TD="align: right"]$25.92[/TD]
[TD="align: right"]$25.92[/TD]
[TD="align: right"]$889.92[/TD]
[TD="align: right"]$889.92[/TD]
[TD="align: right"]$777.60[/TD]
[TD="align: right"]$777.60[/TD]
[TD="align: right"]12[/TD]
[TD]535ea256b697d15970000014[/TD]
[TD]American[/TD]
[TD]plated_meal[/TD]
[/TR]
[TR]
[TD]53628226b020f15fdb000014[/TD]
[TD]Allison Heilborn[/TD]
[TD]allison.heilborn@gmail.com[/TD]
[TD]Christopher Lynch[/TD]
[TD]goodfoodinc2@gmail.com[/TD]
[TD]Chef[/TD]
[TD]nyc[/TD]
[TD]2014-05-01 17:19:34 UTC[/TD]
[TD="align: right"]5/17/2014[/TD]
[TD="align: right"]$1,000.00[/TD]
[TD="align: right"]$1,000.00[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]$1,030.00[/TD]
[TD="align: right"]$1,030.00[/TD]
[TD="align: right"]$900.00[/TD]
[TD="align: right"]$900.00[/TD]
[TD="align: right"]12[/TD]
[TD]5340b8443f8a90365f00000e[/TD]
[TD]American, Italian[/TD]
[TD]family_style[/TD]
[/TR]
[TR]
[TD]53627b644abe351b4b00002a[/TD]
[TD]Susan Steinthal[/TD]
[TD]susan.steinthal@citi.com[/TD]
[TD]Lance Kindberg[/TD]
[TD]cheflans888@gmail.com[/TD]
[TD]Chef[/TD]
[TD]nyc[/TD]
[TD]2014-05-01 16:50:44 UTC[/TD]
[TD="align: right"]5/10/2014[/TD]
[TD="align: right"]$700.00[/TD]
[TD="align: right"]$700.00[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$21.00[/TD]
[TD="align: right"]$721.00[/TD]
[TD="align: right"]$721.00[/TD]
[TD="align: right"]$630.00[/TD]
[TD="align: right"]$630.00[/TD]
[TD="align: right"]14[/TD]
[TD]535ab974d9192acf42000001[/TD]
[TD]American[/TD]
[TD]buffet











[/TD]
[/TR]
</tbody>[/TABLE]

So here's my question. I want to filter out rows with any other city in the city column that is not LA. However, my understanding of the filter button --> deselect all --> LA is that it simply hides the rows, not delete them. The rows on the left side will then have large gaps, suggesting that the other cities (boston, NYc, etc.) are still in the data sheet, they are just hidden. Will this be a problem if I want to count the number of remaining rows that are LA-related rows?

I basically want to filter out the number of rows that do not have LA, and then count the remaining rows. How do I do this?

I tried using the count function, but it seems to only work with numbers?

-Jeff
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
As long as your data-set is in the form of an Excel Table, your counting should be OK. The summing/coouting/whatever function only works on what is visible.

You make your data range int a table by being in it an "Insert Table"
 
Upvote 0
Pick a cell where you want the number to appear and insert this formula:
Code: 
=CountIf(G:G, "la")
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,246
Messages
6,170,996
Members
452,373
Latest member
TimReeks

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top