Skip to content
View in the app

A better way to browse. Learn more.

Thailand News and Discussion Forum | ASEANNOW

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Excel search

Featured Replies

I have a bank statement in Excel.

Is there any way to search for a name, then have the search results bring up all transactions with this name, in a list.


Instead of having to search through everything, have a complete list of every search result for that name.


Thank you

 

You should be able to do it with the filter.

 

Look behind the DATA tab for the Filter (funnel thingy), select it.

 

Then select the filter for the column with the names in (bottom right corner of the column header), enter the name in the Search box, then choose "Select all search results". You should then end up with just transactions with that name.

 

"I don't want to know why you can't. I want to know how you can!"

Have you tried the "Find and Select" function on the Home Tab?

  • Author

Great I'll check these out

 

thank you

 

Alt H S F in Excel to create filter dropdown in header row. No need to highlight multiple cells, simply that you're in a header cell then use the dropdown in the name column that you so refer to filter by the required name.  You'll need to unselect all names in the filter and re-select the one name that you require filtered. If you're really brave then press CTRL+down arrow key in the header filter cell and all your options appear before you. This is assuming you're using Windows.  

 

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.