Ask Your Question

Ben Shimon's profile - activity

2021-04-10 07:30:06 +0200 commented question Delete duplicate data comparing data from another document

I was thinking... if one formula wouldn't work then likely no formula would work. I thought back to the "text" causing t

2021-04-09 15:16:53 +0200 commented question Delete duplicate data comparing data from another document

Is there something other than COUNTIF that I might be able to try using a different method? I saw an old message using T

2021-04-08 17:52:50 +0200 commented question Delete duplicate data comparing data from another document

I copied both columns of data into a new spreadsheet and it worked. So now to figure out what might be wrong with my spr

2021-04-08 17:52:50 +0200 received badge  Commentator
2021-04-08 09:24:50 +0200 commented question Delete duplicate data comparing data from another document

Tried copying the data into the same sheet... still didn't work.

2021-04-08 02:05:28 +0200 received badge  Popular Question (source)
2021-04-07 17:38:30 +0200 commented question Delete duplicate data comparing data from another document

Instead of a second sheet, could I just copy the entire column of the other spreadsheet into the first spreadsheet in a

2021-04-07 15:01:44 +0200 commented question Delete duplicate data comparing data from another document

I checked all the cells involved and they are formatted for number not text. I checked the View Formula and with the col

2021-04-07 14:14:23 +0200 commented question Delete duplicate data comparing data from another document

I just followed the video and did exactly that - when I clicked on the green check mark then it just showed the formula

2021-04-07 14:06:23 +0200 commented question Delete duplicate data comparing data from another document

I tried the new formula and same thing - it just shows the formula and in the next cell below instead of 0 at the end it

2021-04-07 14:02:07 +0200 commented question Delete duplicate data comparing data from another document

I am using LibreOffice 7.1.1.2 (x64) if that makes any difference

2021-04-07 12:18:16 +0200 commented question Delete duplicate data comparing data from another document

When I comment it is adding this: ="" which I don't see in the cell.

2021-04-07 12:16:50 +0200 commented question Delete duplicate data comparing data from another document

=COUNTIF(<call out=""> .C:C; A2)=0 is what I now see in B2. B3 etc says the same thing except the number at the en

2021-04-07 12:15:05 +0200 commented question Delete duplicate data comparing data from another document

=COUNTIF(<call out=""> .C:C; A2)=0 is what I now see in B2. B3 etc says the same thing except the number at the en

2021-04-07 12:14:12 +0200 commented question Delete duplicate data comparing data from another document

=COUNTIF(<call out=""> .C:C; A2)=0 is what I now see in B2. B3 etc says the same thing except the number at the en

2021-04-07 12:06:55 +0200 commented question Delete duplicate data comparing data from another document

=COUNTIF(<call out=""> .C:C; A2)=0 is what I now see in B2. B3 etc says the same thing except the number at the en

2021-04-07 11:20:45 +0200 commented question Delete duplicate data comparing data from another document

So instead of using two documents make the first document have two sheets? That would not be difficult.

2021-04-07 09:57:14 +0200 asked a question Delete duplicate data comparing data from another document

Delete duplicate data comparing data from another document The first spreadsheet contains a column of data in "A" that I