|
|
|
August 26th, 2008 10:24 PM
by Spiky
|
3 |
88 |
|
|
|
|
3 |
71 |
|
|
Fill in a formula within a worksheet by
Tracy
I have the following formula which I need to fill across the worksheet but
the cell reference is from another sheet and the information within the other...
( 1 2)
|
August 26th, 2008 10:13 PM
by Pete_UK
|
12 |
235 |
|
|
|
August 26th, 2008 10:04 PM
by Spiky
|
9 |
114 |
|
|
Count range of data by
Count if dates fall in certain range
I am trying to use the with a date and a range of cells with a count range.
=IF(f7:f117/31/08,COUNT(b7:b11),"") I am getting a value error. What I am...
|
August 26th, 2008 09:32 PM
by Spiky
|
2 |
67 |
|
|
Using less than "" in formula by
Bernie R
I'm trying to use a formula in one worksheet that draws data from two other
worksheet. I have no problem using the "" in formulas, but when I use the
""...
|
|
3 |
101 |
|
|
returning a text value using a formula by
KVSmith59
There is probably an easy solution to this, but I can’t find it. Any help
would be appreciated. I have 3 columns. Each column has a heading with
numbers...
|
|
1 |
81 |
|
|
Using less than "" in formula by
Bob Umlas, Excel MVP
=if(ust!i9="m9",
if(rawdata!r2datevalue("05 may 08"),ust!$b12," ")
"Bernie R" wrote:
I'm trying to use a formula in one worksheet that draws data from...
|
|
0 |
95 |
|
|
Import External Data by Date by
Rubie
I have a query setup in an Excel spreadsheet that imports external data from
SQL. All of the data is imported but, I only want the data for the current
date...
|
August 26th, 2008 08:42 PM
by Rubie
|
2 |
124 |
|
|
Return top ten amounts by
Jane Doe[_3_]
What is the simplest way to return the ten highest amounts listed in a column?
I have a column that list total cost, and I would like to list the ten
highest...
|
August 26th, 2008 08:34 PM
by Spiky
|
2 |
79 |
|
|
Column reference in Vlookup formula by
Kevin K[_2_]
There are time when I need to add column to the section of the spreadsheet
that I'm referencing in my vlookup formula. When I add a column, the vlookup...
|
|
1 |
87 |
|
|
Indirect by
waldorf
i am referencing a worksheet using the indirect function.
excel is automatically adding the active worksheet name to the formula which
returns #REF. how can i...
|
|
5 |
85 |
|
|
No Subject by
No Name
om: Pete_UK
Newsgroups: microsoft.public.excel.worksheet.functions
Subject: i want to create an IF formula to bring back one of four...
|
August 26th, 2008 08:03 PM
by No Name
|
0 |
101 |
|
|
Not sure what is going to be best by
dustinbrearton via OfficeKB.com
I have a spreadsheet where each row represents a shipment. Each shipment has
shipment details in columns A:AP. I want cell AQ to contain the earliest
date...
|
|
1 |
75 |
|
|
|
|
2 |
91 |
|
|
|
August 26th, 2008 07:41 PM
by Diana
|
2 |
106 |
|
|
Wouldn't know what to call it! by
1Fish2Fish
I have a "table" that I created. It's just a basic grid with items on the y
axis and items on the x axis (ex. types of fruit on the top, number of fruit
in...
|
|
5 |
80 |
|
|
Selecting data by date differences by
saylur
I have a large amount of data which includes account numbers and
'transactions.' Each account has more than one transaction, and each
transaction has an...
|
|
3 |
82 |
|
|
|
|
4 |
88 |
|
|
Save Prompts by
PMOPS
My spreadsheet has multiple tabs. When I save I want to either add a save
prompt which reminds me to go back to the summary tab before saving or when I
save...
|
|
1 |
130 |