Wednesday, 28 August 2013

Excel 2010 - how to Select or display rows if column C has specific values? No VB

Excel 2010 - how to Select or display rows if column C has specific
values? No VB

I have a huge spreadsheet and column C contains IDs such as 1, 99, 732387,
28. I have a separate list of IDs such as 23, 87, 902 and I only want to
display the rows whose column C value belongs to my list. What is the
simplest way to do that?
Example:
My spreadsheet:
A B 1 C D
E F 3 G H
I J 8 K L
M N 9 O P
My list: 3, 9.
I want to see
E F 3 G H
M N 9 O P
and hide other rows.

No comments:

Post a Comment