General discussion



By zimonar ·
Can you tell me more please about Row differences and Column differences in Edit, Go To Special dialog box? That answer still not enough clear and it is the same answer in ?How to use the Advanced Excel Select?.
Thank you!
Mona R.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Bizzo In reply to Excel

If you have following data:
1 2 3
2 2 3
1 1 1

Highlight the 3x3 grid starting from A1, and select row differences. It will highlight the cell in each row that is different from the one in column A. ie. the following cells will be highlighted B1, C1, C2.
If you hightlight the grid from cell C1, and select row differences again, the result is different because the first cell in each row is different, in this case cells A1, B1, A2, B2 will be highlighted.

And similarly for column differences.

Collapse -

by zimonar In reply to

Now I understand,
Thank you Mr. Bizzo.

Collapse -

by zimonar In reply to Excel

This question was closed by the author

Related Discussions

Related Forums