find minimum value in diffrent sheet with refrence

November 3, 2012 at 01:34:48
Specs: Windows 7
Dear all,

how to find minimum value in sheet 1 a1 colom sheet 2 a1 colom & sheet 3 a1 colom with sheet 1 b1 colom ref. ,sheet 2 b1 colom ref. & sheet 3 b1 colom.

result is find minium value all a1 colom sheets with ref. b1 colom of all sheet

Thanks
Kartik


See More: find minimum value in diffrent sheet with refrence

Report •


#1
November 4, 2012 at 07:38:44
I don't know what you mean by "a1 colom, b1 colom ref", etc.

A1 and B1 are cells, not Columns.

I also don't know what you mean by "find minium value all a1 colom sheets with ref. b1 colom of all sheet". Mainly I don't understand what you mean by "with ref. b1 colom ".

If you want to find the minimum value in Column A of all sheets, you can use:

=MIN(Sheet1:Sheet3!A:A)

Where Sheet1 and Sheet3 are the names of the first and last sheets in your workbook.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question