Ask Your Question
0

search and get row number

asked 2019-02-08 07:50:26 +0200

kik94 gravatar image

hello i have 2 sheets in libre office calc. On the first i have cell A filled with namesmultiple times celll B filled with date and cell C filled with number 1 or 0, on the second sheet i have in cells B1-D1-E1-H1 filled with names but only 1 time and in cell A1-A2-A3-...-A# filled with date. Now what i am trying to do is to search on sheet 1 and find which row contains the name ALEX and date 01/01/2019. For example (in the images bellow) on the 2nd sheet for celll B2 i want to get back the number 15 wich refers to the row from sheet 1 that contains the name and date.

The best for me would be if there was a way so that in sheet 2 in cell B2 would get filled with the content of cell C from Sheet 1.

anyway this could happen ? thanks in advance

SHEET 1

SHEET 2

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-08 10:42:13 +0200

m.a.riosv gravatar image

=SUMPRODUCT(ROW(A:A);A:A="ALEX";B:B=DATE(2019;01;01))

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-08 07:50:26 +0200

Seen: 58 times

Last updated: Feb 08