I have a spreadsheet that looks like this: C D E F G H I row 29 ...

I have a consignment booth that i list inventoy. I need to only add those items sold in a given month. Item month sold $ sold % to...

Hi friends, I need to calculate the average of a column in a pivot for eg. Jan 09 and Feb 09 so on and so forth for the whole year. Now how can i calculate...

I only want the condtional formatting to apply to the part of the text that equals "PCC". For example, the value of the cell may be, "Jane Smith - PCC" and...

I have a workbook with 12 worksheets that use the subtotal function to sum up various sales into a total, operating expenses into a total, personnel...

While using a macro for some user defined functions, it happens that it returns an error, or in the worst case, excel (2007) stops running at all. Through...

I have some time series data (every hour) but I need my data to line up to a time series of every 15 minutes. Its from March to November its alot of data not...

Need to input alternate blank rows into imported spreadsheet. Currently has 24000 lines of data and would like to find a way of not having to manually input...

I'm using the INDIRECT function to bring in data from other spreadsheets. Using this allows me to just populate a cell and automatically point to a new...

I am trying to get a total of items in a list by category using vlookup. I have a list of 20 different transactions, there might be 8 of them that are one...

Consider a single row and ten columns. Some or all or none of the cells in the row will have non-numerical data. Can anyone provide a formula that will...

I have an open window on my desktop that I need to make a snapshot of and put in an excel worksheet. I did this by accident once and I can't duplicate it.

I am trying to bring data into Excel from a web based report. I can easily do this at home by right clicking on the web based data and then "export to...

Hi, Not sure that the subject line described what I want to do very well, I know that there is a long-winded way of doing what I want to do, but at the same...

Hello, I am trying to get a single referance cell for how many holidays I have on a day in a holiday sheet. I have 22 different employees all with their own...

If i in a sheet have a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on and in a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on Then in another sheet i write...

Hi Really need some help with this! I have a table where the qty are manually entered and the sections are selected from a pull down menu. Col D, F, H and J...

Suppose I have an excel workbook with two sheets X and Y. In X I have a set of data in columns A and B, 1 4 2 5 In Y I want to perform calculations on...

hello gurus Imagine two columns (part of a larger table) , the first with dates, and the second showing the difference (in days) between a date and the one...