I've got an almost 1800 line spreadsheet in Excel. I've got to manipulate data in it for a client. I'm needing to do the following in Excel 1. begin...

Win XP Pro Office XP I wish to create a third condition format by placing a zero in blank cells please? Terry

I'm trying to write a formula that will locate an asterisk (*) in a large range of data, and if it is found, put a statement like "Hey, I found an asterisk!"...

Is there any way to set Excel to automatically do that?

I'm looking for instructions on how to create a calculation that only includes cells that meet a specified condition in a subsequent calculation. For...

If I could please get some help, many I work with will also be thankful! Here's the situation: --spreadsheet A, workbook 1 (thousands of rows): ...

I've just discovered Lists in Excel, and find them very useful. With list I can add more rows and let functions, validations and formatting expand...

Hi there, I don't know how to calculate this and I'm not really sure what it is but my boss wants it. I'm told its sometimes called frequency of sale. I'm...

Hey, I've got two workbooks here - one is garbage, the other is being rebuilt based off of formula's from the old one in certan areas. The values between the...

I have a 4 column spreadsheet: A B C D Customer Type Class 00001 0 ...

Hello, I have a protected worksheet. In this worksheet, column C has cells that are locked and some that are not. I wish for users to be able to copy and...

Hi all, I want to select all my data (headers and values), then apply a conditional format: I have headers in row 1 and values in the underlying rows. When...

Hello All , here is some data i have in Excel in just one row 15023199 C 15023199 D 15023200 A 15023200 D 15023199 E 15023199 B

We have a situation where a date is entered into a cell. If that date is before a trigger date, billing will apply from the trigger date. If that date is...

Hi. I've created several macros for my spreadsheet, which, with the help of some of you, are running wonderfully! My problem is that my spreadsheet will be...

I have a new computer and I am trying to save spread sheets from the a drive to the spread sheets and they didn't work right. How do I get rid of the ones I...

I am currently keeping a database for our local poker league. I keep stats on wins, averages, etc on a monthly basis as well as a season basis (6 months = 1...

hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible?

We have 520 inputs...20 categories x 26 participants For the Standard Deviation do we use the average of the 20 categories or the 520 inputs? We used stdevp...

Hi folks, Is it a way to get its k-value from percentile and array. Thanks. PeterK