We will be migrating from Ask to Discourse on the first week of August, read the details here

Poser votre question

Profil de sbarlster - activité

2021-01-02 21:08:14 +0200 médaille reçue  Jolie réponse (source)
2021-01-02 18:49:19 +0200 a commenté une réponse creating a rule to add 2 cells together automatically

🙂 ooo lovely demo. Much better than my words.

2021-01-02 18:33:56 +0200 médaille reçue  Professeur (source)
2021-01-02 18:20:04 +0200 a modifié une réponse creating a rule to add 2 cells together automatically

If you want the added values in column C. Does this work... =A1+B1 You can then drag that value down all the rows so

2021-01-02 18:20:04 +0200 médaille reçue  Rédacteur (source)
2021-01-02 18:19:08 +0200 a répondu à une question creating a rule to add 2 cells together automatically

If you want the added values in column C. Does this work... =A1 + B1 You can then drag that value down all the rows so

2021-01-02 18:07:01 +0200 a commenté une réponse find the row index where a given value is between two cell values

Thanks Keme, and apologies for my slow reply. Reading the documentation again I see that MATCH is similar to VLOOKUP exc

2021-01-02 18:04:07 +0200 marquée comme meilleure réponse find the row index where a given value is between two cell values

I have a calc spreadsheet for a raffle. There is a row for each ticket purchaser. And along with their details we have 2 columns representing the start and end ticket number for that person.

Given a winning ticket number I would like to find the the winning row. The row where winningTicket >= startTicket AND winningTicket <= endTicket

I'm thinking that a combination of INDEX ROW and MATCH might work but I can't quite find it.

2021-01-02 18:04:07 +0200 médaille reçue  Scolaire (source)
2021-01-02 18:00:36 +0200 a commenté une réponse find the row index where a given value is between two cell values

Thanks very much and apologies for my slow reply. My spreadsheet was nearly as you suggested. Just had to make the start

2021-01-02 17:27:03 +0200 médaille reçue  Question populaire (source)
2020-12-18 09:48:05 +0200 a posé une question find the row index where a given value is between two cell values

find the row index where a given value is between two cell values I have a calc spreadsheet for a raffle. There is a row