|
|
 |
| found 17 articles for 0.294 sec |
  |
| > > In A2: =IF(Sheet1!B2="x",ROW(),"")
That's the criteria col, returns arb row nums for source rows
satisfying the criteria
> > In B2:
> > =IF(ROWS($1:1)>COUNT(A:A),"",INDEX(Sheet1!A:A,SMALL(A:A,ROWS($1:1))))
Above is the extract and float-up results.
SMALL(A:A,ROWS($1:1)) returns the smallest arb row num from the
criteria col, and as it is copied down it'll return the 2nd smallest,
and |
|
 |
|
 |
Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: Max
Date: Jun 7, 2010 22:59
I am trying to find a way to generate GUIDs, which I've found, but I need to ensure they are truly unique. Here is the script that generates the GUIDs Sub GenerateGUID() Dim c As Long, r As Range c = 1 Set r = Range("a2") Do Until r.Cells(c, 1) = "" Dim strGUID As String Set TypeLib = CreateObject("Scriptlet.TypeLib") strGUID = Left(TypeLib.GUID, 38)
|
| Show full article (0.92Kb) |
|
 |
|
1 ·
2 ·
next |
|
|