• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 30
  • Last Modified:

selecting rows from Excel tab that have been identified using a formula

i have compared two excel worksheets using a formula with results displayed as below in a third worksheet.
resultsthe row numbers on the left tell me which rows in the source tabs that contain differences.
I would now like to extract  these rows from the source tabs and examine this data .
Any ideas as to how i can do this appreciated.
  • 2
1 Solution
Ejgil HedegaardCommented:
In the column to the right of the data on the source tabs, make a formula to count the number of "no" in the row on the compare tab.
Something like =COUNTIF('Sheet3'!A2:Z2,"no") for row 2.
Then filter on all that is not 0.
blossomparkAuthor Commented:
Thank you, will try this and get back to you
blossomparkAuthor Commented:
Perfect!!! Made my day :-) Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now