Replies

* click in the small square (select all) in the upper right corner of the sheet, where the row and column headers meet.
* right click on the B in the header of column B and select unhide.

Shooters (first / third person) are the second most graphic intensive games there are. (Flight Simulators being probably the first). In order to play these games (and the shooters are my favorite) you need all you can throw at them to play the game as the developer intended for them to be played.

I believe most, if not all, of the games you listed are available for XBox & Play Station. IMHO consoles can not come close to the experiance of playing a game on a killer gaming machine, BUT consoles are fun to play none the less.

edit: none was spelt wrong…

I believe the Medal of Honor series are on XBox.

I agree with Mark. Unless you are ready to spend some serious money for a Voodoo, Falcon Northwest, HyperSonic, Alienware, or other gaming machine, you are better off getting a console.

High end video cards alone will run over $400-500. For a mid range system to way high end rig you are looking at any where between $2500 to >$4000 for a machine.

Andrew,

Never a problem. This is a great place. Someone will come up with an answer or two for most any question. Usually it is a race to get your reply in before someone else beats you to it. When I have a question or need advice for a problem I am working on, this is the first place I look to.

Brent

AJM,

How bout something like this…

Brent

John,

Some of my users have a need to expand a list of values a certain number of times based upon a time interval. This form is called from a custom menu in Excel. I copied the form and .bas module into a workbook so you could run this.

Brent

edit: the form doesn’t want to run from the web. save to your computer and run – works much better.

Dennis,

Attached is a one sheet workbook giving various counting examples. These samples originated from John Walkenbach.

Attached is a one sheet workbook that gives a few examples on averages, with and without zeros. After having the data in a contiguous range as Steve mentioned.

Always just a hair late with my response.

According to a post by Myrna Larson in the Microsoft Office OnlineOffice Discussion GroupsExcel:
“You need to either (1) convert it with a program like Conversions Plus, $70, or (2) open it with Works and save in an Excel format, or (3) find a friend who can do one of these things for you.”

SarahCarter,

I used an array formula to return the results you want. {=SUM(($A$2:$A$9=”A”)*($B$2:$B$9=”C&C”)*$C$2:$C$9)}
I have attached your workbook with these included.

Brent

I love this place. I can’t count the number of times someone has come thru for me, given me an idea, or posted some code I can tweak.

How bout this:

=IF(AND(A1=”A”,B1=”B”,C1=”C”),1,0)

Hans & Peter, thanks for the replies. We are running a corporate version of Norton and her machine is set up as a managed user. I did look thru all her settings to see if there was any type of office plug in, nothing found.

Linda,

If you have broadband connectivity to the internet, it wouldnt hurt to purchase a Cable/DSL router for added protection. Plug your computer and your modem into the router and your machine is hidden from the world.

edit- after thought:

Any router purchased should have NAT functionality. Linksys is a quality brand.