질문하기

JG101's profile - activity

2021-02-14 12:46:28 +0100 받은 배지  학생 (source)
2021-02-14 12:00:31 +0100 받은 배지  인기있는 질문 (source)
2021-02-13 02:58:29 +0100 질문하였습니다 How do I separate this information into each cell from copy/paste

How do I separate this information into each cell from copy/paste Is there a trick to separate this information into the

2020-12-20 15:38:31 +0100 으뜸 답변으로 표시됨 Chart conditional format : color scale

Trying to have a Bar chart to mimic a Format conditional color scale and / or apply a conditional format color scale to a chart?

2020-12-18 21:04:30 +0100 받은 배지  주목할 만한 질문 (source)
2020-12-07 06:07:26 +0100 받은 배지  인기있는 질문 (source)
2020-12-06 20:22:47 +0100 질문하였습니다 Chart conditional format : color scale

Chart conditional format : color scale Trying to have a Bar chart to mimic a Format conditional color scale and / or app

2020-10-06 10:07:49 +0100 받은 배지  유명한 질문 (source)
2020-09-20 21:41:42 +0100 으뜸 답변으로 표시됨 Random number selection/series; text format

I would like LO to generate a set of numbers from different column of numbers and come up with 5 digits (generate 1 digit number from each column, but not have a duplicate number from any of the columns) for each run.

Is this possible? would someone be able to forward an example

I manually highlighted Text for each number that was represented in different columns – is there a way to automatically do this ?

please see document Generate Random number - format text color duplicating numbers in each column 01-10-2017.ods

2020-09-13 00:08:08 +0100 받은 배지  주목할 만한 질문 (source)
2020-09-13 00:08:08 +0100 받은 배지  인기있는 질문 (source)
2020-09-12 16:30:38 +0100 받은 배지  유명한 질문 (source)
2020-09-11 09:56:16 +0100 으뜸 답변으로 표시됨 Conditional Format (copy / paste possible?)

Is there a way to copy an entire conditional format so I do not have to re-enter every time. I have 32 conditions I would like to create under one conditional format: is this possible?

example: i have 20 names and I would like to color code each name a different color. I have to add a condition for each name with color background which mean 20 different conditions within the Original Conditional Format.

I do not want to do this for every document, how can i copy Conditional format and use for any purpose.

I'm trying to achieve a color visual to quickly identify names in different columns.

thank you in advance for any help provided

2020-09-11 09:55:21 +0100 으뜸 답변으로 표시됨 Color format Cell by duplicate character / name / value in each column / cell

How would I be able to color code each column that represent a certain name or value

example column A: mike Column B: John Column C: Dan Column D: mike Column E: Dan Column E: John

I would like all cells with the name " mike " color code RED

is there a way to do this with conditional formatting.

is there a different way?

thank you in advance for any help provided.

2020-05-06 05:13:27 +0100 으뜸 답변으로 표시됨 LO Writer (multiple pages)

LO Writer: : Would be nice if LO Writer is able to create additional pages (such as LO Spreadsheet, +sheet) where the user is able to keep main page and create multiple pages for quick reference notes.

If this is possible or a work-around. Please let me know

Thank you in advance

2020-05-06 05:12:50 +0100 받은 배지  주목할 만한 질문 (source)
2020-04-28 11:06:30 +0100 받은 배지  인기있는 질문 (source)
2020-04-28 01:18:07 +0100 질문하였습니다 LO Writer (multiple pages)

LO Writer (multiple pages) LO Writer: : Would be nice if LO Writer is able to create additional pages (such as LO Spread

2020-03-05 12:16:01 +0100 받은 배지  주목할 만한 질문 (source)
2020-02-29 14:04:35 +0100 받은 배지  유명한 질문 (source)
2020-01-28 00:39:11 +0100 받은 배지  주목할 만한 질문 (source)
2020-01-26 10:45:20 +0100 받은 배지  인기있는 질문 (source)
2020-01-26 00:47:35 +0100 질문을 편집했습니다 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 받은 배지  인기있는 질문 (source)
2020-01-24 17:45:22 +0100 으뜸 답변으로 표시됨 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 받은 배지  조력자 (source)
2019-12-08 18:31:53 +0100 받은 배지  유명한 질문 (source)
2019-11-09 03:07:48 +0100 받은 배지  유명한 질문 (source)
2019-08-14 09:41:38 +0100 받은 배지  인기있는 질문 (source)
2019-08-13 20:10:09 +0100 으뜸 답변으로 표시됨 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 코멘트달린 답변 cCalc How do I match name and count all cells with corresponding name

SPECTACULAR !!!! TY!!!!!

2019-08-13 18:09:24 +0100 질문하였습니다 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 받은 배지  주목할 만한 질문 (source)
2019-05-26 01:24:52 +0100 받은 배지  유명한 질문 (source)
2019-04-15 20:45:28 +0100 받은 배지  주목할 만한 질문 (source)
2019-04-15 20:45:28 +0100 받은 배지  인기있는 질문 (source)
2019-04-15 20:45:28 +0100 받은 배지  유명한 질문 (source)
2019-04-09 21:01:31 +0100 받은 배지  주목할 만한 질문 (source)
2019-04-08 12:26:49 +0100 받은 배지  인기있는 질문 (source)
2019-04-08 05:26:26 +0100 으뜸 답변으로 표시됨 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 코멘트달린 답변 Separating content column Left , Right error

all set, TY.

2019-04-08 05:22:27 +0100 코멘트달린 답변 Separating content column Left , Right error

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

2019-04-08 04:57:44 +0100 코멘트달린 답변 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 코멘트달린 답변 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 질문하였습니다 Separating content column Left , Right error

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