|
filename in cel
how can i get the filename of the excelsheet with a formula in a cel? It has
to change automaticly when the filename changes.
thanks math
...
|
2 |
11/15/2005 7:51:29 PM |
|
|
no blanks
Can someone please help me to make this formula
=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))
not to count blanks
i need to count nubers that are the same in the same row
Example:
D4 G4
300.00 300.00
Count like one
Thanks in Advance
...
|
2 |
11/14/2005 6:45:14 AM |
|
|
Help ? Here ?
I need some help with a macro or something in Excel.
I have a xls mail list. Col A Name, Col B, Last Name, Col C Email
Address.
We just sent out our Newsletter and over half the 2000 email addresses
are invalid. SOO. How can I take a list of the successfull email
addresses only (txt file with just the addresses in a long list) and
have them matched aganist the master list and delete all...
|
4 |
11/12/2005 9:56:04 AM |
|
|
Checkboxes automatically formating for new rows
I am making a spreadsheet template. In this template, some of the columns
require checkboxes. I need these checkboxes to autmatically appear in the
appropiate columns when a new row is added. For example, if there are 5 rows
filled in with data, then when the sixth row is started, the cells in columns
C-F need to have checkboxes appear in the cells C6,D6,E6,and F6. The same for
each succ...
|
1 |
11/8/2005 9:55:02 PM |
|
|
Excel
Can anyone tell me how to make the results of a cell change color and
blink on and off?
...
|
3 |
11/5/2005 11:11:27 PM |
|
|
Urgent help needed... Template Wizard with Data Tracking???
This function has disappeared after Excel 2000. Is there another way to do
the same thing in 2003?
Cheers
...
|
2 |
10/27/2005 5:34:24 PM |