Hello everyone, I not sure if there is such a thing but here goes. I'd like a page break each time the first 4 characters of a value changes in Column A. To...

Is there any way in a formula to have an OR statement inclueded? In other words I am using a SumIF statement and one of the arguments is if a cell contains...

I have a workseet that has all the requests from customer we quote. I would like to sort & print in one opertation only engineered projects. Currently I have...

I am trying to sum numbers in a column based off of another column. I only want to sum the numbers in a column if the other column meets the criteria. An...

In my excel worksheet i have a drop down menu that displays codes, but i also have the meaning of that code in another column. I want to be able to select...

We are working with a worksheet that has the first two rows protected. Is it possible to sort the columns under the first two rows with the protection on? ...

I had some help putting together this formula, but it has been giving me some grief for some reason after it seemed to work ok to start...

So if I have cities filling column E (to E1236) and their respective countries in column H (to H1236) How do I write the function so that in a new record the...

When I tried to drag the formula of the cell to another cell, the amount supposed to be calculated on another celll did not worked. The Original amount from...

Hi, I'm new to this and I have probably a easy question. I'm trying to count the following. If Column B has a P in it and Column H = 100% or more I would...

I want to generate an Excle report that is linked to data within Quickbooks. Does anyone have any ideas how to do this? Thx -- A MACKENZIE, CMA, MBA

how do i make a column for time read as a 24 hour entry.Example (time)column in this column i want to type time but in the 24 hour format and have it stay...

This worksheet tracks equipment run time. Is there a formula that could automatically enter a 'Y' or 'N' in column (B) based upon time it is turned off and...

I have thousands or rows of data for spefic items with many many week and I typically go through and sum up for latest 52 weeks, YTD, etc. I can then sort...

Hi: I need to round a formula from a decimal to a percent here is the foemula,=VLOOKUP(D10,Customers,9)&"/"&VLOOKUP(D10,Customers,10,FALSE)&"...

I am wondering if it is possible to lookup multiple values using the vlookup function and return one corresponding value? More specifically, I want to...

Hello, I want to enter, say 2 char in a cell and then want to jump to the next cell on the right without having to press enter key. Possible...

I am merging two custom values "0000" together with a dash, and the result loses the leading zeros. Ex. 0001 and 0101 end up as 1-101 and I want it to be...

Now then, I'll try to be as detailed as possible as I find this all a little complicated - so apologies if I'm not clear! I have a spreadsheet that has 18...

Hi group Win XP SP2 Ms Office 2003 Sorry if in wrong group, but I am unable to find solution to my MS Excel problem as follows: For an unknown reason I am...