|
|
|
|
1 |
171 |
|
|
SUM or COUNT and adding a row by
Alex
Hi,
If I have COUNT(A1:A100) with a total in the row #101 and when a user insert
a row between the 98 and 99 rows the function will be COUNT(A1:A101) and...
|
|
2 |
58 |
|
|
|
|
1 |
188 |
|
|
Button sizing handles do not appear by
alex
I want to assign a new macro to an old button. The button does not have
sizing handles, thus no menu appears - cannot assign a macro. Also, cannot
resize the...
|
|
3 |
119 |
|
|
vlookup & wildcards by
Alex
The following are columns in worksheetA:
TrkCase Order
iou9876y7
p0987ewuu
The following are column in worksheetB:
CaseNo Order
|
June 9th, 2005 09:41 PM
by Alex
|
3 |
129 |
|
|
using wildcards in vlookup by
Alex
I need help with the a vlookup formula that needs to use wildcards.
Sheet 1 has the following columns:
MSO# ORDER
NQCT8 111
NQCT8 222
NQFH4 ...
|
June 14th, 2005 04:27 PM
by Alex
|
5 |
156 |
|
|
The { formula } type of formula by
Alex
About a year ago I got a formula from this site and was told that when I hit
enter I needed to do something else to make it work. It worked great at the
time...
|
June 17th, 2005 09:06 PM
by Alex
|
7 |
122 |
|
|
Difficult look up formula by
Alex
I have the following example of cell values in the MSO column on Sheet1
MSO
088234592
088234592
088234592
088234592
NPQW1
NQCT8
NQCT8
|
June 24th, 2005 09:28 PM
by Alex
|
4 |
119 |
|
|
|
|
3 |
211 |
|
|
referring to other cells with formulas by
ALex
I have one cell with the following formula in Column Input!H2:H1000:
{=INDEX(AF8:AI8,MATCH(TRUE,AF8:AI8=0,0))}
it produces the following number: 8175702492...
|
April 11th, 2005 05:14 PM
by JulieD
|
1 |
98 |
|
|
up to 7 functions? by
ALex
What type of formula would respond to the following conditions 12 (excel
seems to only permit up to 7...is it possible to get around that?):
IF Any Cell...
( 1 2)
|
|
10 |
844 |
|
|
count cells with unique numbers by
Alex
If I have a column with some repeated numbers:
58
168
168
25
....
How could I count the cells from the column to get 3 (not 4) as a result -
to be able to...
|
|
1 |
239 |
|
|
|
|
1 |
66 |
|
|
|
|
2 |
96 |
|
|
functions by
ALex
How would one include the following conditions in a folmula
IF Column A= A1 and Column B =B1 then C1=1
IF Column A= A2 and Column B =B1 then C1=2
IF Column...
|
|
3 |
98 |
|
|
Functions by
ALex
How would one include the following conditions in a folmula
IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B1 then C1=1
IF INPUT worksheet...
|
|
1 |
78 |
|
|
|
|
1 |
81 |
|
|
|
|
3 |
243 |
|
|
IF Functions by
ALex
What type of folmula would respond to the following conditions:
IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555
IF Any Cell in Column...
|
April 6th, 2005 01:14 PM
by Domenic
|
1 |
66 |
|
|
ZOOM by
alex
Hello experts,
Is there a way to set Excel to open any/all workbooks/sheets at N%.
Everytime I'm given an xls doc, I end up shrinking it down to 75 or
80% to...
|
February 22nd, 2008 07:05 PM
by alex
|
2 |
70 |