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