Poser votre question

Profil de JG101 - activité

2020-01-28 00:39:11 +0100 médaille reçue  Question remarquable (source)
2020-01-26 10:45:20 +0100 médaille reçue  Question populaire (source)
2020-01-26 00:47:35 +0100 question modifiée Stock prices: Weblinks or Macro with LO ???

Stock prices: Weblinks or Macro with LO ??? I would like to track stock prices within LO, have not been able to figure t

2020-01-24 21:51:38 +0100 médaille reçue  Question populaire (source)
2020-01-24 17:45:22 +0100 marquée comme meilleure réponse cCalc Vertical to Horizontal : Transpose

I have read other posting converting Vertical to Horizontal by copy/ paste / Transpose

I do not see Transpose, where would I find this feature

I'm trying to convert vertical to horizontal

thank you in advance

2020-01-24 17:44:21 +0100 médaille reçue  Supporteur (source)
2019-12-08 18:31:53 +0100 médaille reçue  Question célèbre (source)
2019-11-09 03:07:48 +0100 médaille reçue  Question célèbre (source)
2019-08-14 09:41:38 +0100 médaille reçue  Question populaire (source)
2019-08-13 20:10:09 +0100 marquée comme meilleure réponse cCalc How do I match name and count all cells with corresponding name

Please see attachment

Trying to match names and then count numerical value for each name for cumulative total

example: column A, Row 2: name "A", How do I match A2 name "A", to column AN, then add up all the numbers in column AM that match A2 name "A" and display in B2, I have added all the correct data in DA:D9, so the user is able to verify formula : : : ; .. .. C:\fakepath\LO Matching trying to find accumulative count 08-13-2019.ods.

Thank you in advance

2019-08-13 20:10:04 +0100 a commenté une réponse cCalc How do I match name and count all cells with corresponding name

SPECTACULAR !!!! TY!!!!!

2019-08-13 18:09:24 +0100 a posé une question cCalc How do I match name and count all cells with corresponding name

cCalc How do I match name and count all cells with corresponding name Please see attachment Trying to match names and t

2019-05-26 01:24:52 +0100 médaille reçue  Question remarquable (source)
2019-05-26 01:24:52 +0100 médaille reçue  Question célèbre (source)
2019-04-15 20:45:28 +0100 médaille reçue  Question populaire (source)
2019-04-15 20:45:28 +0100 médaille reçue  Question remarquable (source)
2019-04-15 20:45:28 +0100 médaille reçue  Question célèbre (source)
2019-04-09 21:01:31 +0100 médaille reçue  Question remarquable (source)
2019-04-08 12:26:49 +0100 médaille reçue  Question populaire (source)
2019-04-08 05:26:26 +0100 marquée comme meilleure réponse Separating content column Left , Right error

Please see attached file.

LEFT    RIGHT

               B                 C           D

C8 , 1.05x1.20 , 1.05 1.20 , =RIGHT(B8,SEARCH("x",B8)-1)

C10 , .85x1.25 , .85 .25 , =RIGHT(B10,SEARCH("x",B10)-1)

How to fix formula so it always reads correctly If B10 reads “ 0.85x1.25” then D10 would read correctly , but this will not always be the case for B columns

C:\fakepath\SEPARATING CONTENT IN COLUMN TO TWO SEPARATE COLUMN 04-07-2019.ods

2019-04-08 05:26:23 +0100 a commenté une réponse Separating content column Left , Right error

all set, TY.

2019-04-08 05:22:27 +0100 a commenté une réponse Separating content column Left , Right error

núm.caract = LEN : https://br.excel-translator.de/num-caract/

2019-04-08 04:57:44 +0100 a commenté une réponse Separating content column Left , Right error

Portuguese language, use google translate LOL. what's núm.caract ??? =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR("x";B8))

2019-04-08 04:51:38 +0100 a commenté une réponse Separating content column Left , Right error

=ESQUERDA(B8;PESQUISAR("x";B8)-1) =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR("x";B8)) this comes back as #NAME? Please ref

2019-04-07 17:31:55 +0100 a posé une question Separating content column Left , Right error

separating content column Left , Right error Please see attached file. LEFT RIGHT B

2019-04-07 17:31:51 +0100 a posé une question separating content column Left , Right error

separating content column Left , Right error Please see attached file. LEFT RIGHT B

2019-04-04 04:02:55 +0100 médaille reçue  Question remarquable (source)
2019-04-04 04:02:55 +0100 médaille reçue  Question populaire (source)
2019-04-04 04:02:55 +0100 médaille reçue  Question célèbre (source)
2019-01-23 09:29:43 +0100 médaille reçue  Question célèbre (source)
2019-01-23 09:29:43 +0100 médaille reçue  Question remarquable (source)
2019-01-23 09:29:43 +0100 médaille reçue  Question populaire (source)
2019-01-03 01:37:58 +0100 question modifiée Sum empty cell returns #value (update)

Sum empty cell returns #value (update) Not sure if this has been ask before I'm trying to have SUM of 3 components =S

2019-01-03 01:37:42 +0100 question modifiée Sum empty cell returns #value (update)

Sum empty cell returns #value (update) Not sure if this has been ask before I'm trying to have SUM of 3 components =S

2019-01-03 01:34:24 +0100 question modifiée Sum empty cell returns #value (update)

Sum empty cell returns #value Not sure if this has been ask before I'm trying to have SUM of 3 components =SUM(H211-F2

2019-01-03 01:07:26 +0100 question modifiée Sum empty cell returns #value (update)

Sum empty cell returns #value Not sure if this has been ask before I'm trying to have SUM of 3 components =SUM(H211-F2

2019-01-03 01:07:26 +0100 médaille reçue  Éditeur associé (source)
2019-01-03 00:22:41 +0100 a posé une question Sum empty cell returns #value (update)

Sum empty cell returns #value Not sure if this has been ask before I'm trying to have SUM of 3 components =SUM(H211-F2

2018-11-21 10:37:56 +0100 médaille reçue  Question célèbre (source)
2018-09-28 14:25:04 +0100 question modifiée Rank : how to prevent duplicates.

Rank : how to prevent duplicates =RANK(T5,$T$5:$T$43,0) How do I fix so I do not have duplicates. thank you for any he

2018-09-28 14:24:52 +0100 médaille reçue  Question remarquable (source)
2018-09-26 11:35:44 +0100 médaille reçue  Question remarquable (source)
2018-09-26 04:08:32 +0100 médaille reçue  Question célèbre (source)
2018-09-26 04:08:32 +0100 médaille reçue  Question remarquable (source)
2018-09-23 17:01:03 +0100 question modifiée Match Cells conditional format background.

Match Cells conditional format background Please need help with Match Cells conditional format, please see attached file

2018-09-22 14:40:29 +0100 médaille reçue  Question populaire (source)
2018-09-21 16:22:34 +0100 a posé une question Rank : how to prevent duplicates.

Rank : how to prevent duplicates =RANK(T5,$T$5:$T$43,0) How do I fix so I do not have duplicates. thank you for any he

2018-09-21 16:10:25 +0100 a commenté une réponse Match Cells conditional format background.

Thank you for the reply, I'm looking to change the background color when column G numbers match column M This script sh