Search results for query: *

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.)

The macro uses the old WYSIWYG menu, which is used for formatting. :flb font-lines-botton :FF2 format-font arial mt14 :FBS font-bold-set :sc special-copy (copies formatting) :wrs worksheet-row-set height :FCBN format-color-background normal

If your file is a true utility and no data is being preserved with each access, then have the opened event change the file name upon opening the file. Here is a macro version. A script should be similar: \0 {FOR x;1;9999;1;testFname} {FILE-SAVE fName} x 112 fName file0112.wk4 testFname...

With R5 you'll need to use @DCOUNT. You'll have to insert a row at A1 with a label, say "VALUES". Then you can just do: @DCOUNT(A1..A21;0;A2>3.49)

You can convert the macro from DOS to Windows. This can get you started: {EDIT-GOTO A1} {WINDOWSOFF}{PANELOFF} {GET-LABEL "When the printer is ready press [ENTER] to proceed ",ANSWER} {INDICATE Printing file} {SET "Printer-Setup-Name";"PrinterName"} {SELECT B1} {END}{SELECT-DOWN} {SELECT-RIGHT...

You should be able to adapt my previous macro for use with get label by studying the online help for that command (in R5) which I'm copying in below: {GET-LABEL [prompt];result;[default];[title];[x];[y]} Lets the user enter anything that you want 1-2-3 to store in the worksheet as a label. ·...