Stel uw vraag

gregors15's profiel - activiteit

2020-06-19 14:42:15 +0100 beantwoorde een vraag How can I sort/order rows by number of words in each row

Hi try the following, =LEN(A3)-LEN(SUBSTITUTE(A3," ", )) this will give the number blanks in the cell, which you can the

2020-06-07 13:06:19 +0100 beantwoorde een vraag How can i get the sum of values for each category?

Hi, Try using SUMIF, see attached file.C:\fakepath\LOQ20200607.ods

2020-03-19 21:13:00 +0100 bewerkte een antwoord Writing duplicates to another column

Hi, have a look at the attached, column B is =COUNTIF($A$2:$A$29,A2) which you can then filter to show where the count

2020-03-18 19:41:37 +0100 bewerkte een antwoord Writing duplicates to another column

Hi, have a look at the attached, column B is =COUNTIF($A$2:$A$29,A2) which you can then filter to show where the count

2020-03-18 16:26:28 +0100 bewerkte een antwoord Writing duplicates to another column

Hi, have a look at the attached, column B is =COUNTIF($A$2:$A$29,A2) which you can then filter to show where the count

2020-03-07 11:39:45 +0100 bewerkte een antwoord Lookup data from different sheet

Hi, using your example above, try the following, =IFNA(INDEX($D$1:$D$5,MATCH(A1,$C$1:$C$5,0),0)," ") Let us know if it

2020-01-06 12:12:08 +0100 bewerkte een antwoord which function do I need?

Hi, Try =COUNTIF(A3:A30,"" & "@" & "") let us know if it helps.

2020-01-06 12:04:21 +0100 bewerkte een antwoord which function do I need?

Hi, Try =COUNTIF(A3:A31,"@") let us know if it helps.

2020-01-06 12:03:24 +0100 bewerkte een antwoord which function do I need?

Hi, as an example, try =COUNTIF(A3:A31,"@") Let us know if it helps.

2020-01-06 12:01:53 +0100 bewerkte een antwoord which function do I need?

Hi, as an example, try =COUNTIF(A3:A31,"@"), Let us know if it helps.

2020-01-06 11:59:57 +0100 bewerkte een antwoord which function do I need?

Hi, as an example, try =COUNTIF(A3:A31,"@"), Let us know if it helps.

2020-01-06 11:59:24 +0100 bewerkte een antwoord which function do I need?

Hi, as an example, try =COUNTIF(A4:A30,"@"), Let us know if it helps.

2019-12-11 13:11:50 +0100 bewerkte een antwoord Filter one column by using values of another column

Hi, if you are able to add a column to sheet1, have a look at the attached, I have matched sheet1 column(A)to sheet2 col

2019-10-28 00:45:25 +0100 beantwoorde een vraag Use of countif with multiple sheets

Hi, I have a very similar sheet as you, only mine is monthly currently I have 20 completed months and 1 open, I have cre

2019-10-21 02:17:32 +0100 beantwoorde een vraag How do I use INT (or similar) in search criteria of DB function?

Hi, are you able to add a column, if so, using data above as an example, set column D INT(C2), and extend the ranges. Ha

2019-10-18 12:54:46 +0100 reageerde op een vraag look up value from contents of list

Hi, are you able to upload a sample of you file?

2019-10-10 18:14:45 +0100 reageerde op een vraag how to match a cell when the search region is in a different document

Hi, can you create a new column in the file with the match (test_a) and do Numbervalue(A1) and use this column to do the

2019-10-09 11:09:51 +0100 reageerde op een vraag how to match a cell when the search region is in a different document

Hi, would you be able to upload a sample of the file your linking out to?

2019-10-03 17:52:32 +0100 beantwoorde een vraag [Calc] How to group rows and SUM?

Hi, have a look at the attached, I created some items gave them a group and produced the pivot table. To produce the piv

2019-10-03 16:08:24 +0100 reageerde op een vraag [Calc] How to group rows and SUM?

Hi, can you upload a sample file, around 20 records, sounds like a pivot table could possibly do what you want.

2019-10-03 16:01:53 +0100 beantwoorde een vraag Stopwatch/countdown timer function in LO?

Hi, I have used the desktop version, have a look at the attached file as see if it helps, B1 is now, TODAY() Cell B1 an

2019-10-02 17:21:13 +0100 reageerde op een antwoord Swap unique cell data with rows?

Hi, I only $ the Column($A10) not the row, so to enable copy any where.

2019-10-02 17:21:13 +0100 badge ontvangen  Commentator
2019-10-02 00:18:33 +0100 beantwoorde een vraag Swap unique cell data with rows?

Hi, have a look at the attached, using index/match and $ on the static cell refs, seems to populate the way you want, I

2019-09-28 22:37:50 +0100 beantwoorde een vraag how to create a countdown calendar

Hi. have a look at the attached.C:\fakepath\LOQ_20190928.ods let us know if it helps.

2019-09-23 23:43:54 +0100 beantwoorde een vraag Comparing two columns of phone numbers, counting qty of duplicates

Hi, Try =CONCATENATE(MID(B1,2,3),RIGHT(B1,9)) in column C, and do your comparison between columns A and C. Let us know i

2019-09-19 01:12:29 +0100 beantwoorde een vraag Can't import external data from web page into Calc

Hi, Have you been able previously to get data from this Web site? I have used Sheet/Link to External Data to other site

2019-09-18 17:08:29 +0100 beantwoorde een vraag Formula: layout of = A1[days of Guarenty] - Current day?

Hi, have a look at the uploaded file and let us know if it help.C:\fakepath\LOQ_20190918.ods

2019-08-22 21:19:45 +0100 beantwoorde een vraag LibreCalc Nested if question

Hi , Assuming your value is in A6, Try =IF(A6>24000,1400,IF(A6>20000,1300,IF(A6>16000,1100,IF(A6>12000,900,

2019-08-17 10:53:59 +0100 reageerde op een antwoord Rows coloring acording to product expiry date

If you have a look at the sheet I uploaded, column C shows difference in days between today and the expiry date, negativ

2019-08-17 01:05:18 +0100 bewerkte een antwoord Rows coloring acording to product expiry date

Hi, Have a look at the attached sheet, I have used conditional formatting to produce the colours you want, also uploadin

2019-08-17 00:57:47 +0100 beantwoorde een vraag Rows coloring acording to product expiry date

Hi, Have a look at the attached sheet, I have used conditional formatting to produce the colours you want, also uploadin

2019-08-16 17:57:57 +0100 beantwoorde een vraag Turkey shoot? Averaging multiple data across multiple sheets, while looking for name that are constantly moving

Hi, OK first attempt, I have created sheet14_Plmts which we can use as the summary sheet for Plmts(Column O) and populat

2019-08-16 17:13:21 +0100 reageerde op een vraag Turkey shoot? Averaging multiple data across multiple sheets, while looking for name that are constantly moving

Hi, Ok I will try and create a sheet using your data, with a couple of months in, one question without know how your dat

2019-08-16 11:59:24 +0100 reageerde op een vraag Turkey shoot? Averaging multiple data across multiple sheets, while looking for name that are constantly moving

Hi, Could you produce a summary .ods file, with the name as rows, and the months as the columns, which links out to your

2019-08-14 10:24:36 +0100 reageerde op een vraag Turkey shoot? Averaging multiple data across multiple sheets, while looking for name that are constantly moving

Hi, are you able to post a sample of your sheet?

2019-08-11 14:43:38 +0100 beantwoorde een vraag VLOOKUP between many sheets

Hi, have a look at the attached, Sheet1 column D using INDEX/MATCH gets the “City” from sheet 2, column C. Sheet1 colu

2019-08-10 17:25:48 +0100 badge ontvangen  Weten (bron)
2019-08-10 16:08:04 +0100 badge ontvangen  Goed Antwoord (bron)
2019-08-10 15:26:07 +0100 badge ontvangen  Mooi Antwoord (bron)
2019-08-10 12:12:53 +0100 beantwoorde een vraag VLOOKUP betwen sheets

Hi, have a look at the attached file, I have used the function MATCH to check for the name existing in sheet 2. Let us k

2019-08-09 18:53:51 +0100 reageerde op een vraag Links to external files LO 6.1.5.0 onwards

This is still happening for me, recently did clean windows 10 re-install on 2 different machines, clean install of LO 6.

2019-08-08 22:50:00 +0100 beantwoorde een vraag Can I Set an Equation to Automatically Change?

Hi, Try using =subtotal(9,C3:C1000) instead of =sum. Then each day "insert line below" and the total will automatically

2019-08-02 00:57:53 +0100 beantwoorde een vraag Searching columns for data to return max value of adjacent column? [SOLVED]

Hi, have a look at the uploaded file, I have used index/match to find the priority for each Type, and then just used MAX

2019-08-02 00:06:54 +0100 reageerde op een vraag clear a field in pivot table

Are you able to upload your file?

2019-07-08 14:29:49 +0100 badge ontvangen  enthousiast
2019-06-29 15:43:50 +0100 badge ontvangen  Leraar (bron)
2019-06-29 14:42:31 +0100 beantwoorde een vraag Export to QIF

Hi, Can you save your LO Calc file as a .CSV Then if you google "what type of file can imported into quicken" and look

2019-06-29 14:25:49 +0100 beantwoorde een vraag Is there a calc formula (or some other way) that searches a table for multiple conditions?

Hi, I have created a pivot table using your data, plus 2 additional columns, one for an employee number and one concaten

2019-04-09 11:08:34 +0100 reageerde op een vraag How to filter days of the week (no date) ascending by day (not alphabetically)

Can you upload your file?