Search results for query: *

Check out this link: http://www.pcreview.co.uk/forums/showthread.php?p=10529596#post10529596 at the bottom of the page.

I was able to use the List Toolbar on an XML file - just used it to sum (or average) each column, then outside the list I just entered a SUM formula for the ranges I wanted. Not as good as Data, Subtotals, I will admit, but still viable.

Hi, A lot depends on which version of Excel you have, however, even 2003 claims to save as xml but doesn't do it well. I found it much easier recently to save the file in .csv format, then get a transformer program to convert it. Obviously, you could build it in WordPad, line by line, but that...

mmmmm, take away their video cards and monitors, too? I think your ones up above will have to just be sure who they want to see the data - dump the problem back on them. (Okay, not really helpful, sorry...)

Just to clarify, your 3rd sheet should have the formula: =EXACT(Sheet1!A1,Sheet2!A1) to compare two sheets.

Well, the OmniPage software can be tried for tree, so I would suggest you download it and see how it works for you. And if it does, it's cheap at the low price! (I like their stuff, I admit, but have nothing to do with them...)

One rather round-about way of finding out what it is (Word is not much help with this) is to double-click on the pic, which should open it up in whatever photo editor you have (probably Microsoft Photo Editor). Then go to save and it will show it as being in some format, and that is what is it...

I assume you are working in Excel...rather than having a heading line, why not have Heading 1 and Heading 2 at the top of your first page and then, under File, Page Setup, Sheet have Row 2 (Heading 2's line - whatever it is) as "Rows to repeat at top:"...

Under Tools, Options, Files locations are you able to browse to your network drive? Perhaps you could change your default location to there and see what happens...

Sheesh, thanks - never tried validating from a list without using it as a drop-down listing...works great!

This may sound dumb, but if the database resides on your pc, why don't you just let him access your pc over the net as needed? And if it resides on another machine, like I have some on my server at work, several of us can access it and make changes without having to worry about syncing things -...

Hi all, I have a nice little seating chart setup running in Excel (thanks Andy!). There are up to 157 seats that could be sold each night, and one person may buy up to 8 seats. My main problem remaining is that the seats are named A1-A11, B1-B18, C1-C18...H1-H18 and I1-I20. Unfortunately, I can...

Just to let you know, I was able to take this new sumproduct knowledge and use it already, AND I used a variant of it to help someone at another site! [2thumbsup]

Yes, it does, thanks. Been informative.

I hope it isn't "lknasdf"! As long as we're on the subject, is there a way to use sumproduct to count all the cases where the two do not match? That is, to use the example above, to get a return of 2 (for rows 1 and 3)?

Sumproduct is great when you want to specify the exact items, as appears to be the case here, you are right, except your formula should be =sumproduct((A1:A10="A")*(B1:B10="A")) to count the times where A occurs in both columns. Thanks for the advice, though - sumproduct is a powerful formula item.

Good point, thanks. I don't work much with alphabetical characters - I missed that.

Ah, just to make things clearer, I had put my EXACT statements in column C

Well, this is sloppy, and I am sure someone else knows a better way, but you could have a column listing =EXACT(A1,B1), =EXACT(A2,B2), etc, and then have a cell with (for your given example) =COUNTIF(C1:C3,TRUE) This will return a count of 1.

COUNT(range) will count the non-empty cells, and COUNTIF(range,"") will return the number of empty cells, so =(COUNT(A1:H1)+COUNTIF(A1:H1,"")) should do the trick.