how to define fiscal year when it is not the calender year (Jan-Dec). Example I need the fiscal year to be Oct-Sept. When I preapre a pivot table, I need...

I hope someone can help me. How can I sum the products of columns A and B, but only if the value in column C meets a certain criteria (like = 51)?

how do I create an architectural number format? as in 7'-2", 16'-0", 1'-0 1/2" and be able to add them up. right now they all show up as text.

Folks, I am trying to figure how to best get the data I need given multiple changes in a year. For example, cost for a product may go through several updates...

I am trying to figure out how to solve the following problem. I am organizing a meeting at several sites where each site has many people. Using the MIN...

Is there a way to alphabetically sort worksheets? I have 19 worksheets in one document and would like them to be in alphabetical order.

I am stumped as I do not know what is the best way to accomplish this action. What I mean is with a formula or with VBA coding. So if this is in the wrong...

I was playing with combo boxes yesterday and now there is a list box imbedded in my spreadsheet that I cannot get rid of. Can anyone help me get rid of this...

I have a spreadsheet listing payments received on a specific day of the month. My workbook contains an individual sheet for each day of the month. I would...

I have a cell that has a lot of data in it (all text). When I click on the cell, I can read all of the text in the function box (at the top of the screen),...

I have a question. I have a couple of columns using nested if statements with workdays and networkdays function. Everything works fine on my computer, but...

I've created the following Calculated Field formula in my PivotTable to capture the number of events that were late. DaysLate is the difference between the...

I am trying to use a conditional format to highlight cells that are pulled from multiple tabs using the = function. Tab 1 (Dots 1-20), Tab 2 (Squares...

When ever I am copying any cell in EXCEL or Word ducument it shows "DATABASE HAS REACHED A MAXIMUM SIZE" How to solve this problem

need to count the number of records between two specific dates. Dates are in column i2:i3000. Need to know how many record falls into period 1 1/4/08 to...

i am working on a spreadsheet with over 60 sheets. i am trying to apply one formula to all the sheets but it won't. this is the formula...

I need some professional help as I have created a pretty complex formula but it needs one more step to be complete and meet the requirements of my summary WS....

Hi I have a spreadsheet with a series of values (140.0, 140.2 etc) and I want to locate and isolate all cells ending in '.0' When I search for cells with...

Hi there, I am trying to determine the most frequently occurring (mode) text entry but my understanding is that the mode function is only used for numeric...

This formula in B1 is: =SUBSTITUTE(A1,".","") returns a number. (It removes a series of "dots" from the cell contents in A1.) Is it possible to have another...