Hi pandapo,

There may be a smarter way, but the following is one method: 

1) In Script window, type the following two commands (press ENTER at each command):
  range BB=2;
  sum(BB);
Here, "2" in the first line indicates the column number.

2)Choose "Worksheet: Worksheet Query" menu, select and move(=>) the 
all target columns to right panel (the 2nd column got the alias "B"), 
and enter the following condition:
  B=sum.max
and run it.

Hope this works for you.

--Hideo Fujii
OriginLab

Hi,

If you don't know the column number, you can use the column name 
instead of the column number in the "range" declaration such that:

  range BB=col(B);
  sum(BB); 

--Hideo Fujii
OriginLab

quote:

---

Originally posted by pandapo

I cannot find this worksheet query :(

---

Hi pandapo, 

Well... because you said you have two columns, so that is what I 
intended. If you want to apply the same thing to bunch of columns 
repeatedly, you need to have some sort of automitization. 

For example, the following script applies "wextract" command (see 
"Help:X-Functions" help for details) to every column after the second 
column to the rest. You can copy-and-paste to the Script window, 
highlight all lines, then press ENTER key to run: 

%A=%H; //book name
%L=layer.name$; //sheet name
nc=wks.ncols; //colums
for(ii=2;ii<=nc;ii++) {
  range B=[%A]%L!col($(ii));
  sum(B);
  wextract iy:=[%A]%L!(1:end) settings.stAlias.Cols:=$(ii) settings.stAlias.AliasNames:=BB$(ii) settings.stCondition.Condition:="BB$(ii)=sum.max" settings.stMethod.Method:=1 settings.Cols:="0|$(ii-1)";
  wcol(2)[C]$=From Col$(ii);
};

Hope this works!