I have a pretty tough Excel puzzle that I hope you guys can help m
decode. I created a Web query that downloads Yahoo Fianance's Analys
Estimates for any given stock.
I need it to extract most of the data from the "Revenue Est" table

Hi all. Kind of a basic user of excel here, hoping someone more advanced
than I (not saying much) on this forum can help me with a formula to us
in a worksheet to calculates the appropriate transfer taxes when you
plug in the purchase price in, say cell B1. Following is the tax rate

Here is my problem, I have one database with three fields, Name, Exam, Date
Taken.   I want a pivot or other report which shows the names in rows and the
exam type in columns.  The data section of the report needs to just present
the date the exam was taken.  The pivot table is ...

Is there a way to get Excel to ignore the max and min of a data range
when calculating the average?  If so, is there any way to get it to
ignore the two highest and lowest values?   The second question is less
important but I would really appreciate it if somebody has the answer

Does anyone know if it's possible to have a font color operator?
What I'm trying to do is have it so if another cell is displaying
number above, let's just say 50 for example, it will say in green fon
"On Schedule" or if it's lower than 50 it will say in red font "Behin

I saw a similar question by golf.nut1 that was addressed by biff.  In that
case they weere taking 4 out of the last 5 scores.  However, I am not clear
on the previous solution.  In our league, not everyone plays every week so we
also have some missing scores for some golfers

i had a excel workbook with few thousand lines of address
           a
1           Bamboo Green|177 Tran Phu St., ||Da Nang City|Tel: (84-511)
822722, 830412

I have formulae in cells to reference another sheet, but if the referenced
cell is blank, then the new cell I made blank (using the IF function).  The
problem is, when I want to print, Excel wants to print all of the cells with
entries in them - even the ones with formulae in ...

Hi, is there a way to program with the date function this year?
For example if I wanted to say something like "Days Past in this Year"
or something (sorry for the weak example), and I wanted to link
everything back to January 1st of this year, I would say

Am interested in knowing if anyone has set up a simple address book, contact
list, in Excel as an alternative to the more complex address book in Outlook
and Access

Hi All. I'm new to here, but I've been using excel for years. I a
creating a worksheet to track my Girl Scout's awards. I have it al
done EXCECT for one formula. I can't get it right. I'm going to TRY t
explain this. The ( is the cell address) then number in front is th

I have deleted a number of entire rows that contained a chart. The chart has
been deleted but a line still appears that I cannot get rid of. If I delete a
chart by clicking on the chart and deleting it this line does not appear. Is
there a way to get ride of the line now?

The column I am trying to sum contains the formula  
=VLOOKUP(B620,'S:\Accounting\Donna\SAP Go Live\[Go Live Inventory Download
080806 Rec to 1550 081706 dje.xls]1550 not loaded final'!$B$3:$F$125,5,FALSE)
Is there a Sum Formula I can write that excludes the #N/A values which are

Here is an example of my data:
Org                                     criticality                          
score
Corporate Marketing               critical                            100

For the life of me I don't know how to change a formula in a cell i.e.
=A1 + D4 which will give a final value to show the actual values for A1
& D4 i.e. 2 + 4 = 6 and show this equation in the cell itself. Is this
possible?