Contrary to popular belief, working on documents online can be hassle-free. Sure, some file formats might appear too hard with which to work. But if you get the right solution, like DocHub, it's straightforward to tweak any document with minimum resources. DocHub is your go-to solution for tasks as simple as the option to Concatenate Conditional Field Format For Free a single file or something as daunting as dealing with a massive pile of complex paperwork.
When it comes to a solution for online file editing, there are many options on the market. However, not all of them are powerful enough to accommodate the needs of people requiring minimum editing functionality or small businesses that look for more extensive set of tools that allow them to collaborate within their document-based workflow. DocHub is a multi-purpose service that makes managing paperwork online more simplified and smoother. Try DocHub now!
all right in this video Im going to show you how to concatenate a list of items in a range based on some given criteria so in this example Ive got a list of people and I want to produce from that a list of the people where this column has yes in it so although all the people that were invited if I use a helper column so and I do a formula like if invited equals yes and give me the person and otherwise just return an empty string and if I copy that down and thats gonna give me the the list of people that are invited and then I can do something over here like text join and maybe a comma as a delimiter and then Im gonna want to ignore those two empty cells so add true in there and then just reference my list of people by hit enter thats gonna give me the list that I want with commas in between all the people but we can avoid this helper column if we use an array formula so if I do something like this if I edit this to be if this range yes [Music] Im just gonna delete this then give
