2021 Archives by date, by thread · List index

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

```Then use >0.0000001 or whatever value works instead of >0

On 29 Jan 2021 at 14:06, James wrote:

Subject:                Re: [libreoffice-users] calc: index column A with
column B
To:                     Rob Jasper <Rob@famjasper.nl>
Copies to:              users@global.libreoffice.org
From:                   James <bjlockie@lockie.ca>
Date sent:              Fri, 29 Jan 2021 14:06:08 -0500

```
```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> 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/
```
```

+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

--
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/