Filter a row according to a specified value outside of the table

		Microsoft Office Forums > Microsoft Excel > Excel
Filter a row according to a specified value outside of the table

FAQ

Thread Tools

Display Modes

09-05-2024, 11:24 PM

Pecoflyer

Windows 10 Filter a row according to a specified value outside of the table

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Like this ?

Code:

=FILTER(Name,No.=$C$2)

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Turn off auto filter in a table	Marcia	Excel Programming	2	10-16-2020 10:05 PM
Pivot Table Filter Issue	mikeinli	Excel	1	09-23-2020 01:26 PM
[VBA] Filter Pivot Table by dates	Levi92	Excel Programming	0	11-14-2018 07:43 PM
filter using a table list with VBA	trevorc	Excel Programming	5	11-12-2018 12:41 PM
Use a cell value as a table filter? (VBA)	s1rueegg	Excel Programming	0	12-20-2016 06:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 PM.