2019-08-14 09:41:38 +0200 received badge ● Popular Question (source) 2019-08-13 20:10:09 +0200 marked best answer 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 +0200 commented answer cCalc How do I match name and count all cells with corresponding name SPECTACULAR !!!! TY!!!!! 2019-08-13 18:09:24 +0200 asked a 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 +0200 received badge ● Notable Question (source) 2019-05-26 01:24:52 +0200 received badge ● Famous Question (source) 2019-04-15 20:45:28 +0200 received badge ● Famous Question (source) 2019-04-15 20:45:28 +0200 received badge ● Notable Question (source) 2019-04-15 20:45:28 +0200 received badge ● Popular Question (source) 2019-04-09 21:01:31 +0200 received badge ● Notable Question (source) 2019-04-08 12:26:49 +0200 received badge ● Popular Question (source) 2019-04-08 05:26:26 +0200 marked best answer 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 +0200 commented answer Separating content column Left , Right error all set, TY. 2019-04-08 05:22:27 +0200 commented answer Separating content column Left , Right error núm.caract = LEN : https://br.excel-translator.de/num-caract/ 2019-04-08 04:57:44 +0200 commented answer 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 +0200 commented answer 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 +0200 asked a 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 +0200 asked a 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 +0200 received badge ● Famous Question (source) 2019-04-04 04:02:55 +0200 received badge ● Notable Question (source) 2019-04-04 04:02:55 +0200 received badge ● Popular Question (source) 2019-01-23 09:29:43 +0200 received badge ● Notable Question (source) 2019-01-23 09:29:43 +0200 received badge ● Popular Question (source) 2019-01-23 09:29:43 +0200 received badge ● Famous Question (source) 2019-01-03 01:37:58 +0200 edited question 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 +0200 edited question 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 +0200 edited 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 2019-01-03 01:07:26 +0200 edited 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 2019-01-03 01:07:26 +0200 received badge ● Associate Editor (source) 2019-01-03 00:22:41 +0200 asked a 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 +0200 received badge ● Famous Question (source) 2018-09-28 14:25:04 +0200 edited 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-28 14:24:52 +0200 received badge ● Notable Question (source) 2018-09-26 11:35:44 +0200 received badge ● Notable Question (source) 2018-09-26 04:08:32 +0200 received badge ● Notable Question (source) 2018-09-26 04:08:32 +0200 received badge ● Famous Question (source) 2018-09-23 17:01:03 +0200 edited question 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 +0200 received badge ● Popular Question (source) 2018-09-21 16:22:34 +0200 asked a 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 +0200 commented answer 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 2018-09-17 22:25:57 +0200 received badge ● Popular Question (source) 2018-09-16 19:28:19 +0200 asked a question Match Cells conditional format background. Match Cells conditional format background Please need help with Match Cells conditional format, please see attached file 2018-08-20 20:32:45 +0200 received badge ● Famous Question (source) 2018-04-08 15:37:38 +0200 received badge ● Notable Question (source) 2018-04-08 15:37:38 +0200 received badge ● Popular Question (source) 2017-12-06 11:05:41 +0200 received badge ● Famous Question (source) 2017-11-13 18:10:07 +0200 received badge ● Notable Question (source) 2017-11-13 18:10:07 +0200 received badge ● Famous Question (source)