Ask Your Question
0

return a list of optionally delimited text values based on a criteria

asked 2019-02-11 22:10:59 +0200

chrisboat gravatar image

image description image description

edit retag flag offensive close merge delete

Comments

Same question posted on the OpenOffice forum

Note; your images are difficult to read, being small.

robleyd gravatar imagerobleyd ( 2019-02-11 23:17:41 +0200 )edit

Hi Robleyd, A couple of things. 1. I am unable to see the small images, they appear big to me. I would like to fix it so they are easier to read but I cannot see the issue. If you have an suggestions i would appreciate it. 2. More important I gave a simple example of what I wanted and the group provided a good simple solution with TEXTJOIN. But my real need if for something more like SUMIFS where I use 4 conditions to determine if I want to add to my summ. I need to meet 4 conditions in order to add more items to my string. I dont think I can do that but i might be wrong. Any thoughts? Chrisboat

chrisboat gravatar imagechrisboat ( 2019-02-12 14:31:17 +0200 )edit

It seems AskLibreOffice rescales large images; nothing us users can do about that except download the image separately and view it.

In future, consider uploading a LibO file with the information; or as your screenshots are mainly text, perhaps paste the text as you did on the AOO forum - which appears to be the source of your first screenshot above!

robleyd gravatar imagerobleyd ( 2019-02-13 00:03:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-11 23:33:38 +0200

Lupp gravatar image

updated 2019-02-12 14:50:25 +0200

Since you are using LibO Calc anyway seemingly, you have a standard function for the task. No VBA acrobatics needed nor the user function I offered in the other forum.

Please always cross-link if you post the same question in different forums.

===Edit1 2019-02-12 14:50 (UCT +1:00)===
BTW:
The TEXTIF function posted in the OQ would even work in recent LibO under the Option VBAsupport 1 setting. It would, however be seriously inefficient, and would not accept, of course, calculated arrays on the respective parameter positions.

edit flag offensive delete link more

Comments

Thank you for the feedback. I was unaware of the cross-link ability and am not able to find out how to do it.

More important I gave a simple example of what I wanted and the group provided a good simple solution with TEXTJOIN. But my real need is for something more like SUMIFS where I use 4 conditions to determine if I want to add to my summ. I need to meet 4 conditions in order to add more items to my string. I dont think I can do that with Textjoin but i might be wrong. Any thoughts?

Finally if I wanted to try TEXTIFS Where is the OPTION VBSupport 1 setting?

Chrisboat

chrisboat gravatar imagechrisboat ( 2019-02-12 16:21:26 +0200 )edit

solved the VBS Support 1 issue myself .. put the command in the basic program .. it worked

chrisboat gravatar imagechrisboat ( 2019-02-12 16:40:36 +0200 )edit

It worked...
Well, it worked in a specific situation with very short arrays, probably.
You will find out yourself that it's too inefficient as soon as your arrays will have lengths of some hundred rows, and that there may arise situations where one or both of the arrays need precalculation, and the "TEXTIF" fails completely.
Better use the TEXTJOIN() solution.
(MS Excel users are encouraged to rely on user code even if completely unnecessary. Don't go this way.)

Lupp gravatar imageLupp ( 2019-02-12 18:17:48 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-11 22:10:59 +0200

Seen: 30 times

Last updated: Feb 12