Hello there,
I am trying to do what I think is a simple task, but I'm struggling considerably.
I have a file with five worksheets in it. The first four sheets each contain three columns of numbers.
I need to find the maximum number in the second column of all the sheets and have it outputted in the fifth sheet.
In other words, if the biggest number in column B of any of the four sheets is 20, I need 20 to appear in a cell in the fifth sheet.
Can anyone tell me how to do this? This is a simple example so if someone could show me how to do this I would be able to tailor it to my (much larger) sheets of stuff.
Any help, as always, will be very gratefully received.
Thanks in advance,
Chris.
I am trying to do what I think is a simple task, but I'm struggling considerably.
I have a file with five worksheets in it. The first four sheets each contain three columns of numbers.
I need to find the maximum number in the second column of all the sheets and have it outputted in the fifth sheet.
In other words, if the biggest number in column B of any of the four sheets is 20, I need 20 to appear in a cell in the fifth sheet.
Can anyone tell me how to do this? This is a simple example so if someone could show me how to do this I would be able to tailor it to my (much larger) sheets of stuff.
Any help, as always, will be very gratefully received.
Thanks in advance,
Chris.