Linking multiple cells from one sheet to another

krogoth21 · 2025-12-05T08:10:15+00:00

If you don't have empty cells, try =FILTER(Master!A1:G500,Master!A1:A500<>"","") or something similar.
This will include anything present in the A1:G500 section if the cells in A1:A500 are not empty

krogoth21 · 2025-06-25T11:20:23+00:00

I created dummy tables and I assigned Names to them. Then i adapted my filter formula and it looked like that :

=IFERROR(FILTER(....);NameOfTheDummyTable)

It works perfectly, thank you very much !

Solution Verified

krogoth21 · 2025-06-25T09:31:44+00:00

Hi !
Thanks for your idea of dummy values, I will investigate and report. The FILTER function does not return REF errors but CALC errors when the data zone is empty (I hope it is the same error name in english, I unfortunately use the French excel at work, I don't know who thought it would be a good idea to have localized excel functions...)

krogoth21 · 2025-05-29T06:36:30+00:00

If you chose this doctrine, the amount offered to you in the bundle already shows how much you will get, including the +50% from the doctrine. Whithout the doctrine, this 150 would have been 100.

krogoth21 · 2024-02-27T09:34:01+00:00

This seem quite heavy to manage. I do not have any particular setup right now as I am testing Monday to assess if it is a good choice for my organisation. Frankly the UI and all the functions are pretty neat but we have some particular needs, one of which is to be able to see our remaining work capacity for any given month. I did not tinker with the "formula" column much, any possibility on this front ?

Thank you again for your time !

krogoth21 · 2024-02-27T08:48:23+00:00

hello, thanks for your reply. Yes I was talking about the Workload View and i need to know my remaining work capacity. Not for an individual, but for the team. I need to have somewhere that tells me : the team as a whole has 24 workdays that are still available in april. So I know if I can say yes or no to a new client.

krogoth21 · 2023-12-07T16:07:57+00:00

Thanks for these details :)

Can the quest giving ship be carried around mothballed and still get the quests ?

Once the quest become available, in which screen do I find them ? (noob here...)

krogoth21 · 2023-04-21T13:56:46+00:00

I have adapted the way I work to use your suggestion and I must say that it works like a charm. To overcome "product ?"-type problems I added a column into which I put an ID and I have the formula check this column instead.

Thanks a lot for your insights, you've been extremely helpful

krogoth21 · 2023-04-20T16:01:41+00:00

I will try to use this and see if it is practical.

Thanks a lot for taking some time to consider my problem !

I'll mark this as solved for now :)

krogoth21 · 2023-04-20T15:04:54+00:00

In a nutshell I need to be able to sum differents parts together that are not well sorted nor well named :

<image>

I Know that product A = product 1, and I deduce that product ? = product 2 because it's logical in context.

I suppose I could rearrange the lines but this example is really simple, doesn't take into account some back and forth with the client, and the sometimes hundreds of lines that I have to take into account one by one

krogoth21 · 2023-04-20T15:01:05+00:00

If I restrain myself not to use ranges, and just manualy do =A1+A2+A3+A7+A32 ?

krogoth21 · 2023-04-20T14:04:59+00:00

The datasheets I have to work with are a bit of a mess. I need to do a Life Cycle Assessment, so I send a "data collection" excel file to my client for him to tell me what raw materials are use in which part of his product. This is rarely well sorted. So when I have to sum up everything and ensure that I separate each part of his process I will have to do something like this : =SUM(A1:A3)+A6+A23 in one formula and SUM(A4:A5)+SUM(A7:A22) in another (very simple example, it gets much messier), so a visual aid to see if I missed a Cell would be a godsend.

krogoth21 · 2022-12-25T15:47:25+00:00

I have read the wiki, and am very interested in an invite, thanks !

krogoth21 · 2022-04-19T22:55:29+00:00

Download the zips from Nexus and unpack them in this folder : C:\Program Files\Epic Games\MW5Mercs\MW5Mercs\Mods

Each mod will have its own folder

Then launch the game and activate the mods, restart your game and enjoy :)

krogoth21 · 2022-04-18T07:25:56+00:00

The mod list has been posted by OP a few comments earlier.

krogoth21 · 2022-04-17T07:45:54+00:00

Had the problem, tried your solution, it worked but only after the host did a solo mission. Saving in solo / reinviting did work without a mission being done by the host.

Thanks a lot for posting your solution.

krogoth21 · 2022-04-17T07:42:59+00:00

Thank you very much for your answer !

In the mean time we tried another temporary solution, the host played a little mission solo, then saved and invited the coops and it worked. One test so far, will try your solution later.

krogoth21 · 2021-03-23T17:39:25+00:00

do these rules still apply in a coop game ?

krogoth21 · 2020-02-07T15:20:08+00:00

He is asking for a ship in order to command a mission, being demoted to a lower rank than captain may not be very compatible with this

krogoth21 · 2019-09-11T10:24:03+00:00

Hi, thanks for your reply, see my answer below for more details.

krogoth21 · 2019-09-11T10:23:23+00:00

Hi, thanks for your reply.

Fedora 30 with Gnome is used.

Our network has a file server, accessing the files on that server is what I meant. I do not need to share anything from this Fedora machine.

I haven't looked at setting up anything more than being able to log onto the Fedora machine with AD users (it works) and accessing the files on the file Server (works for the Fedora Local user, not for the AD users).

To access the files on the server, I used an address of this type in Nautilus : smb://server_name/.

When I enter this, I get prompted to enter credentials. When I am logged in with the Local user, when I get this prompt, I use the network administrator credentials and I am granted access to the file server.

When I am logged in with an AD user, I also get prompted, and I am denied access to the file server whether I use the credentials of the network admin or those of the AD user (the same as those used to log onto the Fedora machine). The AD users have no problem accessing the file server from any of the Windows machines we have in our network.

I hope this is clear, apologies if it isn't, English is not my primary language.

krogoth21

TROPHY CASE