2021 Archives by date, by thread · List index

# Re: [BULK] Re: [libreoffice-users] calc: index column A with column B

```James,
There are 2 basic ways to accomplish this:

Round the values at calculation time, so they’ll become real 0’s

Change the formula to MINIFS(B:B;B:B;">=1”)

Success,
Rob

```
```Op 29 jan. 2021, om 20:06 heeft James <bjlockie@lockie.ca> het volgende geschreven:

Another problem.

Some of the numbers display as 0 but are calculated so have fractions like
0.0000000812344372353
I want to find the last row that displays as non-zero.

On 2021-01-29 6:30 a.m., Rob Jasper wrote
```
```James,

Since a MINIF function does not exist you can use MINIFS.

Change MIN(B:B) to MINIFS(B:B;B:B;">0”)

Success,
Rob

```
```Op 29 jan. 2021, om 03:59 heeft James <bjlockie@lockie.ca> <mailto:bjlockie@lockie.ca> het
volgende geschreven:

```
```   I want to find the row in column A that corresponds to the row of a

value in column B.

eg.

row    A        B
1      10       220000
2      20       150000
3      30       3000
4      40       10

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns the

value in column A at row 4.
```
```I asked the previous and someone gave me the formula:

=INDIRECT("\$A"&MATCH(MIN(B:B);B:B;0))

It worked fine but now I have some rows with zeros (more than one row):
row A       B
1       10      220000
2       20      150000
3       30      3000
4       40      10
5   50      0
6   60      0

Is there a MINBUTGREATERTHANZERO function?
```
```

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/