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

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.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History