Share via

Selecting specific lines automatically in Excel

Anonymous
2020-04-14T23:40:57+00:00

Good night, people!

I really need to learn (FAST) how to select specific lines automatically in Excel. That's because I need to analyze a sheet with thousands of patients. For example, I need to select all the lines that contain female patients, which present an "F" in the B column. I really cannot select them all manually. That would cost me a lot of time. Can someone please help me?

Bruno Oggioni, from Brazil <3

EDIT: problem solved! Thanks a lot for the ones who answered me. Actually it was way easier to solve than I expected haha :)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-15T00:26:20+00:00

    Hi I am an independent advisor and hoping to help you today.

    How about using a filter in excel?

    I am sharing a link below for a detailed description and instruction on using Filters in excel:

    https://support.office.com/en-us/article/filter...

    or you may also use Pivot Table for better analysis of your data:

    https://support.office.com/en-us/article/create...

    Hope this helps.

    Thank you.

    0 comments
  2. Anonymous
    2020-04-24T13:45:00+00:00

    Hey! About 20 minutes after I posted this question here, I thought of the same thing! I've been using filters to do so since then. Thanks a lot!

    0 comments
  3. Anonymous
    2020-04-24T13:46:11+00:00

    Hey! Thank you as well. Some minutes after posting this question, I thought of that too! Thanks a lot!!

    0 comments