Search results for query: *

Thanks. For whatever reason I couldn't get on the website originally. However, I finally got it and will try it out! Thanks!

That's a great idea. I hadn't thought to use a PT. I will try it out! Thanks!

Here's a better explanation of what I want to do. On a single worksheet, I subtotal large amounts of data using Data>Subtotals. I end up with 30 to 50 subtotals inserted between every few dozen rows of source data. The Data>Subtotals function allows me to collapse the spreadsheet to show ONLY...

Here's one I have struggled with. I work in massive spreadsheets that require Subtotals. Getting the lists to subtotal is easy. However, I often need just the subtotals in a spreadsheet and nothing else. More exactly, I need subtotal 1 in cell A1 and subtotal 2 in cell B1 and subtotal 3 in...

I often have to access spreadsheets that I do not author. Those spreadsheets induce Excel to add toolbars to the ones I already have open. This is a big annoyance and a waste of my desktop real estate. I am constantly turning them off manually. Mostly this happens with the Reviewing Toolbar...

Excellent! Thanks SO much! It worked like a charm! (I replaced the semicolon w/ a comma.) Thanks again!

How can I do something like this (correctly). . . =if((b2=1 and c2=2),"Yes","No") I am trying to use logic in the first argument of the IF statment. Thanks, AS47

Thank you SO much for your help. --AS47

I am using Excel. I have named several blocks of cells for easy use with the VLookUp function. However, I now want to remove several names (to remove some of the unuseful block names and have a concise useful list of named blocks). How do I 'un-name' a block once I have named it? Am I...

Wow! Thank you for your input!

Background: I am an accountant in a small business. We usually have 18 pages of activity on our bank statement each month. We get the bank statement information electronically (online) and we have our book information in electronic format (in Excel). Issue: After we put them both together into...