|
|
INDEX Function by
Jerzy
Hello to all,
I need to find an alternative to the "INDIRECT(A1)"
function. Indirect works well enough on my PC, but that
function is not supported in the...
|
|
1 |
336 |
|
|
Display formulae by
Sheryl
I have an assignment where I've had to create a
spreadsheet using certain formulae. The next requirement
is to copy that worksheet to a new one, and show all...
|
|
1 |
330 |
|
|
Advanced Filter in Shared Workgroup? by
Three20Three
Is there anyway to get an advanced filter to work in a
shared workbook? If not, is there an alternative to
advanced filtering that I could...
|
|
1 |
722 |
|
|
Countif Advise by
Aladin Akyurek
In A1 on Sheet2 enter:
=COUNTIF(Sheet1!A5:INDEX(Sheet1!A:A,MATCH(REPT("z",255),Sheet1!A:A)),"=Dave"
)
"Michael168" ...
|
|
2 |
320 |
|
|
Converting arabic (US) numbers to text by
Greg
I have seen a couple of previous posts on this topic but
they have either a) not worked, or b) not made any
sense. I want to be able to type a number, for...
|
|
1 |
231 |
|
|
How to count the gap by
Don Guillett
also posted elsewhere
"Michael168" wrote in message
...
Let say in...
|
|
1 |
94 |
|
|
|
October 5th, 2003 09:16 PM
by Steved
|
5 |
188 |
|
|
Countif...? by
Craig
I am trying to count (in cells C3,C4 and C5 on Sheet2) 21
cells on sheet1(H4,G12,H17,G24 etc.) I have entered a
formula in the cells to return the values...
|
|
1 |
103 |
|
|
|
|
2 |
360 |
|
|
"Group" and sorting data by
Joel Bergsman
One of my Excel spread sheets somehow (?) acquired the
word "group" in its name, and many menu choices
disappeared -- including the sort function.
How do I...
|
October 6th, 2003 07:09 AM
by acw
|
2 |
366 |
|
|
Autosum by
barker28
Hi
When I change an amount in a autosum range the total
will not update why is this happening.
thanks for any advice.
Jill
|
|
1 |
110 |
|
|
regression analysis specifically forecast by
Michael
I have tried to get the forecast function to work
properly. I have exhausted everything I could read from
microsoft website including the technical support...
|
|
2 |
92 |
|
|
visible entire formula by
Mark
Hi,
I wonder, if is possible follow automatic action on cells:
Multiplicate per index=1,5 each cell in range.
Result operation - in each cells visible...
|
October 6th, 2003 09:06 AM
by Mark
|
6 |
171 |
|
|
Time calculations in Excel 2002 by
Andre
I need to display the result of a time calculation as a
decimal e.g. 08:30 - 08:00 = 00:30 I want the 00:30 to
be displayed at 0.5 (half an hour). Is this...
|
|
1 |
130 |
|
|
worksheet sum function by
Dawna
Why does a column of numbers not total what it should?
When adding the column with my adding machine, I get the
total. When adding by the sum function, I'm...
|
|
2 |
131 |
|
|
figuring bowling handicaps by
Mlou
a friend is the secretary for the bowling league and
wants to use Excel to figure the handicaps for the
bowlers involved. Any suggestions on the formula...
|
|
1 |
173 |
|
|
Sharing worksheets with custom functions by
jimlyke
What is the easiest way to share spreadsheets with custom
functions? If I only send the sheet, they won't have the
custom functions. If I send the sheet and...
|
|
1 |
259 |
|
|
sorting and combining data by
I've got two different spread sheets with large amount of
data. These two charts however share one grout of data
(in this case street address) The first set...
|
|
1 |
220 |
|
|
type date and year has to come. by
shital
i have a field like:-
Name of Name of Date Year Qty Rate Amt.
Party Co.
what i want is when i type date i want year has to...
|
|
6 |
427 |
|
|
|
|
1 |
276 |