Ask Your Question

JG101's profile - activity

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

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

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)