Ask Your Question
0

Ihave a Calc spreadsheet that has 2000 rows and 10 columns, I need to see if data in 1 row matches data in another row?

asked 2016-06-22 20:47:42 +0200

Kylel456 gravatar image

Data as follows Is row 1 data the same as any other row? column1 >>>>>>>>column10 Row1

# # # # # # # #

Row 1000

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-23 00:55:10 +0200

m.a.riosv gravatar image

See attached sample, creating an advanced filter using the titles and first row of data as filter.

FirstRowAdvancedFilter.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-06-22 20:47:42 +0200

Seen: 19 times

Last updated: Jun 23 '16