Prev: Sumproduct for Values over a certain Value eg 0.00
Next: find smallest positive number among datas
From: Ashish Mathur on 16 Mar 2010 20:49
Hi,

You may refer to my article here

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Ruslan" <Ruslan(a)discussions.microsoft.com> wrote in message
news:86788212-3FD2-4754-818C-A8C92592B2FF(a)microsoft.com...
> Dear All,
> I got a list of data like:
> A B C D
> 1 1 ABC 55 Wilson
> 2 AFD 60 Adams
> 3 1 DGC 76 Korinth
> 4 AFV 83 Smith
> 5 1 URD 45 Hertz
> ...
> and I would like the Excel automatically compose table on a new sheet that
> will show all rows with "1" in A column. Without Pivot Table. In other
> words,
> what formula should the cell in new sheet have to choose the first row
> with
> "1" then the next "1" and etc.
> Rgds,
> Ruslan

First  |  Prev  | 
Pages: 1 2
Prev: Sumproduct for Values over a certain Value eg 0.00
Next: find smallest positive number among datas