I have a large spreadsheet that I need to protect some rows. These rows are not in sequence or determined interval. These rows contain formulas which I would...

I would like to have a formula that will subtract the sales tax from a sale. Ex. If I sale a product for $10, I have to charge 7.75% sales tax. the customer...

Here is a quick one for you gurus. BTW thanks for your help in advance I have three different (insurance options) values in a column that has 145 employees. I...

In using Excle 2007, I am asked to convert to a new file format. for the most part I have complied since is a requirement at work. In doing so I have...

I do a lot of subtotaling. I have different depts with diffeent charge codes but all share the same GL code. Ex Printing/Copy GL code 4400, for admin it will...

I have a PR spreadsheet with 12 worksheets labeled by month - i have names and salary amount for each month separate. Presently there are only 35 employees. In...

Most of us benefit by reading answers given to others (one way not to repeat the same question). So far I have not this one. Here it is - I see a lot of times...

I have 5 departments each with at least 35 employees. Some of the employees are listed in more than one dept based on % of their time. I have an annual salary...

My apology if this is a repeat question. The payroll software we used is capable of uploading to Excel for better presentation. After subtotaling, i further...

I have a feeling this was asked many times before. What I want is a simple formula to calculate hours worked. From the time cards an "IN" and "OUT" time is...

I know I can show different levels by selecting the the (1,2,3,,, etc) layers created by the subtotal process. I just do not know how to show the subtotals in...

*There may be a thread that exists but I do not understand them. I am trying to create a formula so every time I type the letter b the following data ...

I got into excel and went into Microsoft Visual Basic I pasted the code in VBAProject in Sheet 3(Code) But my spreadsheet did not change. What am I doing...

I was informed that Excel does not have a function to hide data/rows in a worksheet besides using the filter. I am trying to create a template that is "user...

I Have a mutiple Spreadsheets with several functions caring over to each one. I want to set a fucntion that only shows greater then 0 amounts on the last...

Is there a way that when you insert a row, a formula (or series of formulas)from the row above is automatically...

Does any one know how to display (for the purposes of deleting) empty text boxex on a spreadsheet??? Thanks

I’m trying to convert arrays into bar graphs, but I haven’t found a way to make the data range “wrap� from the end of one row and start at the next....

Hi, Here is my problem. I have a few filters in my sheet. I want to make calculations within ranges what is in the filter, not all data. The formulas should...

Dear friends, I`m currently using CSE formulas to extract and analyse data with the multiple criterias. e.g:...