|
|
Vlookup and SumIf Problem by
andyj
I'm trying to combine Vlookup and Sumif, but so far my attempts have
failed!!
I have a 2 sheet workbook, the first sheet contains a lookup table,
like...
|
October 2nd, 2003 08:24 AM
by andyj
|
4 |
320 |
|
|
|
October 2nd, 2003 01:51 PM
by Cole
|
2 |
329 |
|
|
Adding a button function? by
Cole
I think you first need to record macro and then assign the macro to the
button
if you need help on macro or VBA
try news group...
|
October 2nd, 2003 01:58 PM
by Cole
|
0 |
278 |
|
|
Please help with dashes by
Debbie
I want nothing to appear if the value is zero, but it
there is a value, I want the value PLUS a dash....
|
October 2nd, 2003 02:03 PM
by Debbie
|
5 |
165 |
|
|
Formating a cell "1-1" not "1-Jan" by
JJ
I'd like to input 1-1 or 1-2 or 0-2 etc. but Excel
converts my input to a date 1-Jan or sometimes to a large
number 37622. I've tried using a custom format...
|
|
5 |
121 |
|
|
|
|
0 |
450 |
|
|
|
|
1 |
115 |
|
|
*Using Excel Formulas in Macros* by
Nadeem
Hi
I am trying to use an Excel formula "lookup" in a macro.
This macro find the last row in work sheet and then
calcualte the range for the lookup_vector...
|
|
1 |
115 |
|
|
Duplicate names by
Scott
Is there a command buklit into Excel to find duplicate
names on a very large spreadsheet?
I know theres a command in FileMaker just wasnt sure if
Excel had a...
|
October 2nd, 2003 03:00 PM
by
|
2 |
207 |
|
|
|
|
1 |
342 |
|
|
Protect Sheet option not available by
Dee
I'm trying to protect my workbook because someone keeps
deleting formulas and i'm constantly fixing it. However
i've taken all the step to protect the cells...
|
|
1 |
498 |
|
|
Sum and Avg on the same subtotal line by
Mark
I am working on a worksheet where I have 4 columns of
numbers. The customer wants columns 1 & 4 averaged and
columns 2 & 3 summed. They want these all on one...
|
|
2 |
113 |
|
|
adding up sum of several products is off by
Kendra
I'm trying to set up a payroll spreadsheet.
I'm trying to sum up a series of products & even though I
have decimal set out 2 places, excel still sums...
|
October 2nd, 2003 03:24 PM
by Kendra
|
2 |
367 |
|
|
|
|
1 |
306 |
|
|
Getting the last value 'X' by
Catalin
I post this question few days back, but i was not so
explicite.
I have a sheet, let say "A" where i've posted a table of
around 3500 rows. Daily i'm adding...
|
|
1 |
111 |
|
|
Counting Names in a column by
jcarlon
Hello
I think what I'm trying to do is very simple but yet I'm
missing something, and just becoming frustrated.
Here's the situation. On my spreadsheet, I...
|
October 2nd, 2003 03:47 PM
by jcarlon
|
3 |
392 |
|
|
Compare Month to Current Date by
KReiss
I have a column which is a text column that I spelled out
all of the months in a year . What I'm trying to do
is.........If Today()=(the month colum) + 7.5,...
|
|
5 |
455 |
|
|
|
October 2nd, 2003 04:24 PM
by Dee
|
4 |
377 |
|
|
Geometry by
Chuck
I'm trying to write a formula for a Right Angle Triangle
that returns the Angle in degrees of "A" knowing the
Hypotenuse "c" and Height "a".
I tried...
|
|
1 |
105 |
|
|
Greater than, less than by
Biff
Hi hodkd,
Try this:
=IF(AND(F202000,H2075,H2086),D8,"")
Biff
-----Original Message-----
I want to use a table to reference a cell if two other
|
October 2nd, 2003 04:44 PM
by hodkd
|
2 |
120 |