|
|
excel by
What does the function or symbol ^ mean?
|
|
1 |
144 |
|
|
Updating data with an ODBC link to ACCESS by
Does anyone know the best approach for this?
I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional
spreadsheets which have ODBC links to various...
|
July 6th, 2006 02:09 PM
by
|
1 |
82 |
|
|
|
July 6th, 2006 02:06 PM
by
|
1 |
94 |
|
|
Running Macros by
I have the following Macro (which I need to run on approximately 200
different workbooks) -- what is the BEST way to achieve this? Should I use
a Function...
|
July 6th, 2006 03:42 PM
by
|
0 |
84 |
|
|
|
July 12th, 2006 10:08 PM
by
|
0 |
141 |
|
|
|
August 7th, 2006 08:49 PM
by Boze
|
4 |
90 |
|
|
|
August 8th, 2006 02:36 AM
by
|
0 |
89 |
|
|
|
|
2 |
112 |
|
|
|
September 22nd, 2006 04:47 PM
by
|
2 |
98 |
|
|
|
May 15th, 2006 01:19 AM
by
|
3 |
145 |
|
|
Number of items in a colum by
Hei,
I would like to found out how many same items are in one Excel column. If
the column has the values 1 3 4 2 5 6 7 9 3 6 7 8 3 the funktion should pic
up...
|
|
1 |
86 |
|
|
offset/match by
I am trying to create an offset/match formula that pulls
data from a separate worksheet, but it is not working. is
there any restrictions on this?? thx,
|
|
3 |
155 |
|
|
|
November 18th, 2003 05:00 PM
by Jim
|
1 |
206 |
|
|
|
|
2 |
545 |
|
|
Need Help WIth a Function by
I am Trying to create a Weekly Time schedule for my
business. I have to deduct a half hour from each shift if
more than five hours are worked. i want the...
|
|
3 |
159 |
|
|
calculate Score by function by
what should I have to do if i want to give score 5 at 1000
and with every increase or decrease of 25 in 1000 .25
should be added in 5 or subtracted...
|
|
1 |
116 |
|
|
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20
database which is multiplied by a specific volume. When I=20
have no pricing in the database for a product...
|
|
2 |
97 |
|
|
Duplicate enties by
I have a spreadsheet with about 20,000 rows and 10 columns of data. Is there
a way of finding if there are duplicate entries using a unique field. Is
there...
|
September 19th, 2004 11:51 PM
by Max
|
1 |
121 |
|
|
|
March 21st, 2006 04:54 PM
by
|
5 |
104 |
|
|
Extract email addresses by
Hi
I have been looking for an answer to this for weeks - and I admit defeat!
I have a column of data with email addresses in there, somewhere. Each email
is...
|
|
9 |
88 |