Feb 06 2019 01:13 AM
Hi,
Can anyone help me create a formula that looks for all numbers in a column that also has a certain number in its row (19-2) ?
Feb 06 2019 04:27 AM
Feb 07 2019 05:28 AM
Thank you @Nauthstar for your answer, but I did not manage to place the formula. Could you try to place the formula in the attached file?
Thank you very much for your time!
Feb 07 2019 07:06 AM
Hi, Try the attached. You can add new rows and the table will expand automatically.
N
Feb 07 2019 12:41 PM
Thank you for your answer @Nauthstar , we're getting close!
I do not need the rows to turn yellow, but i do need the numbers (Beløp) that are marked 19-1 (Fakturamnd) and so on, to show up in the column on the right that is also marked 19-1 / 19-2 / 19-3...
When i copied your formula into my file, it says "true", if "true could be replaced with the corresponding number that would be great.
Thank you for your help so far!
Feb 07 2019 12:45 PM
Hi again @Nauthstar , i figured it out! Thank you wery much for your help! It was great!!
Feb 08 2019 04:30 AM