|
delete row with #N/A
Hi All,
How can I delete entire row that contain error #N/A in a certain cell?
any help would be appreciate
Bijan...
|
4 |
11/13/2008 8:29:57 AM |
|
|
Sum by position
Hi
I hava an excel sheet with 61 columns of number a,b,c,d ......
starting at row 3 and finishing at row 30
What I want to do with a formula is this.
Is it possible to have a reference cell let say A1. in this celle a
put a number let say 3
For each row I need to put a formula.
The formula should do that: start at the beginning of the column and
make the sum for next 3 columns...
|
11 |
11/13/2008 7:03:17 AM |
|
|
Ordering data
I have the following data:
4150 4321 4525 <blank cell> 5050 <blank cell> 5575 <blank cell> 5650
The second cell - in this case the value 4321 - is linked to a live market
feed. I need to sort this data so that the live feed cells always falls into
the correct 'band', ie. the blank cell between 4150 and 4525, between 5575
and 5650, etc.
So for example if the m...
|
9 |
11/13/2008 4:20:01 AM |
|
|
Format changing
I have some issues with an Excel file that I will try to explain.
The file contains worksheets; 12 monthly progress reports, 1 data sheet, 1
information sheet, 12 comment sheets (to show progress against objectives set
in the report). It is stored in the 2003 format.
The reports have some text that is linked to the information sheet and the
comment sheets and charts that update from th...
|
1 |
11/13/2008 1:15:00 AM |
|
|
Probleme affiche userform
Bonjour
J'au un soucis pour afficher a l'ouverture d'un fichier excel un
userform. ce userform comporte des case a coche (checkbox), dans la zone
controlsource des propriete j'ai saisi la case de ma feuille excel ou je
veu recupérer le resultat (vrai ou faux) , tout cela fonctionne
parfaitement , sauf quan je met l'ouverture du userform a l'ouverture du
fichier excel , erreur ne ...
|
2 |
11/13/2008 12:45:43 AM |
|
|
countif
Why does this not work:
Sheet A = named "monthly"
In column E number of mont is listed with 01 to 12. There can be various
amounts of rows filled with the different numbers of months
In column L the value can be 0 or less (f.x. -01)
In sheetb B = named "monthly summary" I want celle L4 to count rows when
criteria 11 is OK in monthly column E AND the criteria 0 or less is OK in
mo...
|
5 |
11/12/2008 11:19:39 PM |
|
|
Programmatically Determine if Excel 2007 SP1 is Installed
I have an Excel add-in that needs to determine whether SP1 of Excel 2007 is
installed. Is there a registry entry or something else that can be queried
at runtime to determine the version?
I noticed in the Excel UI both 2007 and 2007 SP1 show the version number as
12.0.6324.5001.
- Drew Lettington...
|
1 |
11/12/2008 10:25:01 PM |
|
|
Opening excel 2003 /2007 Ignore other applications checked / unche
Need the ablity to drag the same file in
into the IE browser window, load the same files thru the start run command
line. "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" c:\test.xlsx and
then be able to double click on the same file thru windows explore?
1) If the Ignore other applications setting in Excel is checked you will get
the following message on double clicking on a file...
|
1 |
11/12/2008 10:04:01 PM |
|
|
Edit Button image
Excel 2007 - all patches loaded
Many of the commands that you add to the Quick Access Toolbar do not have
any icons. When you add them to the Quick Access Toolbar you get a green
circle icon. Is there any way (without buyting a thrid party package or
writing VBA code) to modify the icons.
Thanks, Will
...
|
3 |
11/12/2008 9:26:01 PM |
|
|
Excel Newb: Splitting First name and Last name
I have a long list of names in column A that look like this:
Ana Trujillo
Antonio Moreno
Thomas Hardy
Christina Berglund
How can I split out the names by first name and last name with first
name going in B and Last name going in C? Thank you very much....
|
2 |
11/12/2008 8:08:15 PM |
|
|
Enhanced Graphing Software.
General question not regarding excel.
A few years ago I learned about a product that was excel-like but with
graphing features that far surpassed excel. I believe it started with an "X"
or "EX". Does anyone have any idea what it is called or where I can find out
more information on products like these. I found "MiniTabs" which is for 6
Sigma Projects. Just curious....
|
7 |
11/12/2008 6:19:32 PM |
|
|
Define a name in VBA
Hi All,
I need a VBA code to select a non-active sheet(TEST) and then detect
non-blank area to define a name(GI) to it.
Thanks in advance
Bijan...
|
8 |
11/12/2008 3:57:00 PM |
|
|
Manipulating totals and columns in Pivot Tables
Hi,
I'm constructing a pivot table that has investors as columns,
investments as rows, and the general data is values. Trouble is there
is a column which I want to only display half of each value. I know
that I can make a formula that divides a column "column A/2", and then
hide the unwanted columns. But I would also like the hidden columns
to not be included in the grand totals. How d...
|
7 |
11/12/2008 2:51:49 PM |
|
|
Macro for deleting rows and serialising the remaing rows
Macro for deleting rows and serialising the remaing rows
====================================================
I have a spread sheet
It's a ToDo List
The structure is like this
Column A Sl No
Column B Task
Column C Person
Column D Completed
To start with I keep entering the tasks in one stretch and take a print out.
The first Column (A) will be a serialized.
...
|
2 |
11/12/2008 1:32:53 PM |
|
|
Sorting with sub catagories
I have a simple spreadsheet that lists some hospital departments and then
under some of the departments i have sub-departments. I'm looking for a way
to sort alphabetically by department but keep the sub-departments in their
correct position. Hopefully this makes sence...
Thanks everyone,
John Gray
...
|
3 |
11/12/2008 1:18:38 PM |
|
|
Holidays
In cell A1 I enter a year.
In cell:
A2 I would like something that will return the date for Memorial Day (Last
Monday of May)
A3 I would like something that will return the date for Labor Day (1st
Monday of September)
A4 I would like something that will return the date for Thanksgiving Day
(4th Thursday of November)
...
|
10 |
11/12/2008 10:29:22 AM |
|
|
Separate Bold Text from a string
How can i separate bold text from a string
for example
East Doncaster Victoria, Australia
If East doncaster is bold i want to separate it in another column.
thanks...
|
2 |
11/12/2008 8:39:39 AM |
|
|
counting negative and positive percentages in a column
I am trying to figure out how to do a sumif or countif for a range of
values negative and positive values of a cell in a column.
example
10%
15%
33%
-10%
-5%
-45%
I would like to have one formula to count the cells with a positive %
from 0.01% to 20%
another formula to count the cells with a negative % from -0.01% to
-20%
thank you...
|
3 |
11/12/2008 5:18:01 AM |
|
|
Copying Multiple Conditional Formats from One Workbook to another
Hi,
I'm hoping there's an easier way to do this rather than manually
retype 3 conditional formats per column x multiple columns :-
Workbook A is identical to Workbook B in terms of column headings
etc.
Workbook B has no conditional formating, and needs to have the exactly
the same conditional format by formaula as workbook A.
Whats the quick way ?
--
Rich
http://www.richdavies....
|
5 |
11/12/2008 2:28:57 AM |
|
|
Separate hours worked from hours on break, lunch, etc.?
Hello!
I was looking for a program to schedule employees that showed when
they work, are on break, lunch, etc so I can see conflicts and make
sure the required number of people are in each work area. Downloaded
many, but they either cost too much for us, or were not as
customizable as we needed.
So I am trying the Excel route.
Here's the setup:
New worksheet.
Merge A1:A4 and put an...
|
2 |
11/12/2008 1:32:41 AM |
|
|
PUZZLED - Daily Percentage Change and Cumulative
Dear All,
I was never any good with maths and this just puzzles me!
I have date starting from 100 down column B with the date in column A.
The last number is 117.50.
I make this an increase of 17.5%....however each day it may have moved
down 1% or up 2%. When I summate all the daily percentage changes I
was expecting to see 17.5% however I can see around 20%.
The formulas are all...
|
8 |
11/12/2008 12:01:09 AM |
|
|
Finding Values in a Column Matching to a different workbook
I am having trouble with a report...
Example:
A workbook of all the clients for the month and a workbook of zip codes in
High Risk areas. I need a quick solution to test if the monthly clients have
a zip code in the list of High risk zip codes. There are over 500 clients to
look up and currently I've been using the Control-F function to see if the
zips are in the list and it is ve...
|
13 |
11/11/2008 11:08:36 PM |
|
|
Help with VBasic in Excel 2003
I'm using Excel 2003. I am working in a master worksheet named "SHPG
RCVG RPT" which is on my desktop. After I enter all of the
information and create my hyperlinks, I need to protect the worksheet
and then save it to a different folder. The new name of the worksheet
is determined by the purchase order # which is in cell D3. I need a
macro which will: Protect the worksheet --> Name th...
|
2 |
11/11/2008 7:01:38 PM |
|
|
How to lock Excel 2007 quick access toolbar to be always visible?
Microsoft has totally f*#¤ed up the good old Office GUI on version 2007. I
try to find a way how to do some regular tasks with this buggy and unfriendly
and unproductive Excel 2007 interface, but every now and then new obstacles
are rising.
The ribbon system is very limited and hardly functional for several tasks. I
put some essential control buttons onto quick access toolbar, that is ...
|
3 |
11/11/2008 4:47:45 PM |
|
|
Autofill worksheets?
Can I fill in a template on one sheet, and have it auto populate cells in
other worksheets that are in the same workbook? Maybe using an excel form?
Thanks,
Dan...
|
2 |
11/11/2008 4:42:12 PM |