|
|
|
Macro for deleting rows and serialising the remaing rows
Wed, 12 Nov 2008 18:00:29 +0530
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 o ...
|
how to sum all values of a variable that's repeated multiple times
Wed, 12 Nov 2008 04:23:02 -0800
I have a column where there are several variable, repeated many times.
On the right column the values of the variable ate given.
I want to add up all the values of each unique variable and get a table that
has all unique variables in one column and their corresponding summed up
values on the next cell. ...
|
Order the names by ranking
Wed, 12 Nov 2008 11:40:08 +0000
I have a list of collaborators with an associated classification. With
the function rank, I obtain the ranking of each one. And now I intend
that whenever it modifies the classification, that the names of the
collaborators are presented by order of ranking, automatically.
Somebody can help me?
Here's a ...
|
IF, AND, OR Function
Wed, 12 Nov 2008 02:30:05 -0800
Hello,
I have successfully created the IF / AND function on the following formula:
=IF(AND(A1="Feb 08",B1="Persons Name"),"Clear","Not Clear")
however, when I want to ad another condition to the "AND" part (as below),
the formula stops.
=IF(AND(A1="Jan 08",A1="Feb 08",B1="Persons Name"),"Clear","Not Cl ...
|
SUMIF and SUM.NUMBER
Wed, 12 Nov 2008 01:58:06 -0800
Hi
I have two sum function that work as they should, but try to set another
agrument and then it fails..
First one :
=ANTALL.HVIS(E:E,N2), in english i thin it is NUMBER.IF(E:E,N2)
I am trying ti get it to say NUMBER.IF(E:E,N2 AND K:K<100)
IF the E:E finds the value of N2, and the number in K:K is less than ...
|
IF... do nothing
Wed, 12 Nov 2008 01:46:06 -0800
How do you get an if statement to do nothing?
I have 2 spreadsheets that get updated monthly. one is overwritten, and I
then want the new data to automatically insert into the column for the
corresponding month in the other sheet.
=IF([Asset Allocation.xls]Asset Allocation'!$C$5=$Z$2,[Asset
Allocation.x ...
|
sumif and numberif
Wed, 12 Nov 2008 01:40:01 -0800
--
Just a regular user ...
|
|
|
Sumproduct automatically count number of rows
Wed, 12 Nov 2008 01:37:23 -0800 (PST)
Hi
I have following sumproduct:
=SUMPRODUCT(($A$2:$A$9487="101")*($B$2:$B$9487="0")*($E$2:$E$9487=
{4;5;6})*$C$2:$C$9487)
My problem is that my sheet always starts at row #2 but the numbers of
rows change from time to time - so I need excel to count the numbers
of rows and automatically place it where 94 ...
|
Change format of a date field
Wed, 12 Nov 2008 01:02:01 -0800
I have been given a csv file - on opening in excel the dates are in the
format 25051917, 5051949, 23121979 etc.
I have been struggling to get them into the standard date format - in this
case 25/05/1917, 05/05/1949, 23/12/1979 etc. Any help appreciated. ...
|
Conditional Formatting a drop down list
Wed, 12 Nov 2008 00:35:01 -0800
Is it possible to conditionally format based on the selection from a drop
down list. The drop down list has a choice of 18 different status, the user
will select each on depending on what stage of developent a particular case
or client is at. I want to group the status together so if they relate to an
earl ...
|
|
|
