843 reputation
515
bio website simonecarletti.com
location Rome, Italy
age
visits member for 4 years, 5 months
seen Nov 15 at 21:21

profile for Simone Carletti on Stack Exchange

Hi! My name is Simone Carletti. I'm a passionate programmer and scuba diving instructor.

I work at DNSimple. I'm the author of RoboWhois and RoboDomain.

I have been involved with FOSS (free/open source software) for more than a decade, contributing code and creating libraries.

I'm available for short mentoring sessions.


Nov
15
awarded  Scholar
Nov
15
accepted Find the closest value (equal or greater) in a range in Google Spreadsheets
Nov
15
comment Find the closest value (equal or greater) in a range in Google Spreadsheets
QUERY worked like a charm. Thank you!
Nov
11
asked Mark multiple messages as read in Inbox by Gmail
Nov
6
awarded  Student
Nov
6
comment Find the closest value (equal or greater) in a range in Google Spreadsheets
As I said, the value for B cannot be pre-determined from A, take it as a requirement.
Nov
6
awarded  Commentator
Nov
6
comment Find the closest value (equal or greater) in a range in Google Spreadsheets
No. It's just an example, the factor must be taken from the row, not calculated with an expression. In fact, the rule you provided would not work for feet.
Nov
6
comment Find the closest value (equal or greater) in a range in Google Spreadsheets
No, it does not. Apart that the fields where completely wrong, I was able to reuse INDEX to simplify the formula into =IF(ISNUMBER(A4),INDEX(SAC!E:F,(MATCH(A4, SAC!E:E, -1)), 2),), but it still doesn't fix the problem of the order. If I sort with 0 and I don't use the field sorted in reverse range, it does not select the right value.
Nov
6
revised Find the closest value (equal or greater) in a range in Google Spreadsheets
deleted 1 character in body
Nov
6
comment Find the closest value (equal or greater) in a range in Google Spreadsheets
6 and 10 are just examples, the formula should work for any value in the depth range, not just for 6/10.
Nov
6
asked Find the closest value (equal or greater) in a range in Google Spreadsheets
Oct
23
awarded  Revival
Oct
23
awarded  Yearling
Mar
18
awarded  Custodian
Mar
18
reviewed Approve How do I migrate my Google Calendar & Contacts to Outlook.com?
Jan
12
answered Are there any advanced options for searching my Delicious links?
Dec
13
answered How do I migrate my Google Calendar & Contacts to Outlook.com?
Nov
25
awarded  Caucus
Jul
8
awarded  Yearling