Summary Sheet no fomulas, looking every where for days no leads yet
I have a file with 9 tabs it is used for daily maintenance info there are no formulas just columns with data text and numbers each tab is a different truck, how can I make a sheet with the info from each tab, basically a summary tab?
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