Recent content by crazybird

If there are no duplicates in your number list, then you can try: @SMALL($A$1..$A$9,1)+@SMALL($A$1..$A$9,2)+@SMALL($A$1..$A$9,3)+@SMALL($A$1..$A$9,4)+@SMALL($A$1..$A$9,5) If you organize your list of numbers in a column with a text header, then you can use a much simpler formula...

This is one type of task that Excel can do much better (using an array formula). Method 1 If I needed to do this task, I would be a /Data Query Unique. In R5, after doing this, the formula @info("dbrecordcount") would hold the value of the number of items extracted, which would be the value...

Sorry! The suggestion above does NOT work. If get another (hopefully better) idea, I'll revert.

I think this might work, but I haven't exhaustively tested it: @RANK(@MIN(A2..A6),A2..A6)-@RANK(@MAX(A2..A6),A2..A6) where your number occupy the range A2..A6.

@if works this way: @if([condition];[do this];[else do that]) [condition] must be either true (not equal to zero) or false (zero). example using AND: @if(A1=B1#and#C1=D1;A4;0)

OK. How about this?: @IF(@isempty(F5)#OR#@isempty(H5)#OR#@isempty(I5),"",F5+H5-I5)

@IF((F5="")#OR#(H5="")#OR#(I5=""),"",F5+H5-I5) Here is the version that is equivalent. You have some displaced perenthesis in your version. Does this help?

The solution is: @ROUNDM(A1,0.25)

Try putting @NA on the missing data points.

Every formula must begin with one of these: + - @ function ( or any number You don't commence with the = sign. The expression @SUM(Al:C3) should be @SUM(A1..C3)

I recommend appending the new data to your account database using {DATABASE-APPEND}. You can also just use {APPENDBELOW} or {APPENDRIGHT}.

I would use {RANGE-VALUE destination;[origin]} which is equivalent to the classic /RV but behaves a little better using R9.x .

I don't know the direct solution to your problem, but I'd love to know what a macro that runs for days does and how it does it. I'd like to think that such a process could be simplified. (I'd be willing to try.)

@cellpointer("sheetname") or @cellpointer("sheet")

I still use R5 which has this ":" menu, although I never use it. (R5 has 3 menu systems!) You'd have to resort to an old manual for DOS versions 2.3 or greater to get the info. (Books on R5 ignore the WYSIWYG menu.)