I have downloaded some historical quotes for MSFT in one spreadsheet. IN another sheet I want to write a formula to say find June 19, 2009 and look for the...

Having given two dates is there any way to plot line from these two dates. ( say dates in continuous cells) Regards, Krish

Hi! to Everyone There are many Software and Addin and Macro or Code to Delete or Eliminate the Duplicate Data But, I want to Delete The Duplicate BLANKS...

Hi, I'm sure I've seen someone do this but I can't remember how it was done... Basically I am trying to group a number of rows under a heading row (in a...

Hi! I have one workbook with two sheets. Sheet one is used to define where our consultants are booked every day through the fiscal year. The sheet includes...

Subject site column A column B column C Columnd E001 1 Hyperthyroidsm Astma check E001 ...

I have 4 worksheet each with over 80 rows of information. I want to lookup a code in one column, and if found I want the value from the immediately adjacent...

Hi, I got data as follows: Date Material ($) Labour ($) 1/1/09 100 - 22/1/09 - 150 2/2/09 200 ...

I am a quantitative analyst who is the leader of our department's Excel users group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,...

Wondering if anyone can tell me where exactly do I add the asterisk symbol to multiply within this function. So far I have: =HLOOKUP(C4,'Risk...

Khalil, I Exccel 2007, you can sort by colour. Just go to "Data" -- "Filter" -- "Sort by Colour". Khalil wrote: Dear Experts; I have a data...

Softwa Excel 2007 SP1 I'm using the FV function to compare future returns on investments. The results of the six scenarios in row 36 are as...

Dear Excel experts, I am stuck with a problem here which I am trying to solve manually, but knowing Excel, there MUST be a more efficient (time-saving and...

Hi, By default, the summarise value field in the pivot tabel is always COUNT. Does anyone know that this default, can it be change to SUM? Thank you in advance

I am learning CUBE functions. The only one I can't get to perform is CUBESET. Here's my scenario: I've constructed an offline OLAP Cube using Access...

I am trying to get this formula to average the values in row I for all individuals seen during the year 2008. The formula also acknowledges that it should...

i need to put overtime in a work sheet but here is what i need to do if you work Between 12:00 am to 8:00 am this is double time now how do i calculate...

I create a spread sheet in 12 row and 10 columns . i want run loop in rows set by the date. every day it should show next row data automatically

Hi to all; I have a pivot table that contain "task-start-date" field I want to add a costom field to my pivot table with this formula :...

tHow can I work out using conditional formating that this employee is double booked with the time scheduled falling in between a current workshop he is...