trying to do a formula based on true/false output but I cant get round this
Team A(B1) v(D1)Team B
IF SUM(B1>D1) say 1 - 0  {if true = 1 if false = 0}
IF SUM(B1<D1) say 0 - 1  {if true = 1 if false = 0}

I think it's wrong to continue a discussion in a new thread. If you
could check/search back please?
The topic is titled;
"Can this VBA for work on text files be modified for a different job

I want to be able to enter a part number in say "b2" and then the  adjacent cell "c2" would fill in a description automatically and then in "d2" the list price could fill in automatically. Any help is appreciated thanks.

I have got a very large spreadsheet where the information is presente
as:
111111/  1
Notice the two spaces after the forward slash. There's about 10'00

I have set up various spreadsheets which pull in data directly from a
database, SUN Accounts) via an add in called Vision(manufactured by Lasata).
This generally worked fine until I upgraded my pc to Windows XP and Office
XP. Since then for some reason certain excel files won't open ...

When I filter to show all values less than a negative number, screwball
results happen.  I can't believe this problem exists to this day.
Is there a workaround?

Need an excel macro code, that when executed will open a spesific folder
(full of *.doc files) accept a search string and a replacement from the
keyboard, search all of the documents for that string and if find it in
anywere on any of them files, replaces all, saves the changed * ...

Could someone tell me what might be the reasones for that the control tool
box doesn't work.
I had a button in my file for a macros, but it desappered (I don't know
how). I still have the macros in that file but I can't add button to run it.

I'm trying to add a dropdown list dynamically and for Excel 2000 and above
the following sub works fine:
Public Sub AddDropdown(ByRef ToCell As Range, ByRef RefCell As Range)
 Dim oValidation As Validation

Hi all...
I have a fairly complex spreadsheet that also incorporates lots of legal
text. The app allows reps to enter info about prospects, and it computes
pricing, generates legal documents, and other info. Clearly, EXCEL handles

Here's what I'm trying to do:
I want a macro that will hide certain lines based upon a code in column A.
There will actually be 3 macros which will hide different sets of lines,
with overlap. I thought of using values:

I would like to have combo box functionality for the data validation feature
in Excel 2000.  This doesn't seem to be available in the native validation
setup dialog box.  Am I missing something?  I would like to display the
validated items list in the leftmost column and have ...

How does one calculate the Nth square root of X. Is there
a function? Anyone has formula to acomplish this? Thanks
for your help.
Regards

Hi, i`m newbi in Xcell.
I want to calculate simple overtime
If 5 Hours a day $20+ 2.50*B2
If between 5 to 7.30Hours then $25+3.00*B2

My Excel worksheet is sorting numbers wrong. It's doing
this:
94
92