Forum Discussion
How can I correlate multiple collumns/rows, which share the same value, in two different sheets?
The title doesn't explain it all so let me expand a bit.
I have a database with multiple sheets. All sheets have the same patients, but different information about them, listed as 1 and 0.
In the first screenshot I have formatted all patients on the C column which have the value 1, meaning they have a high white blood cell count, with the color red.
https://imgur.com/a/PrWFypi
In the second screenshot you'll see the same patient with the value 1 listed at the column which lists the cause, in this case, column E.
https://imgur.com/a/DAqC0g0
I'd like to know if there is a formula which can find me all the patients with the value 1 on the C column on the first sheet and their coresponding value for the same patient on the second sheet and tell me their number AND the cause (title of the column)
for example :
High white blood cells total : 83
Cause x(inguinal hernia) has : 23
Cause y has : 2
Cause z has : 14 etc
1 Reply
Hello,
on the assumption that there is a one-to-one relationship, i.e. cause X can only result in one symptom, the one in column C, you can create four formulas
High white blood cells total : 83
=Sum('Biologic Preoperator'!C:C)
Cause x(inguinal hernia) has : 23
=Sum('Cauza ocluziei'!E:E)
Cause y has : 2
=Sum('Cauza ocluziei'!F:F) -- Adjust to the correct column
Cause z has : 14 etc
=Sum('Cauza ocluziei'!G:G) -- Adjust to the correct column
