|
locked cells
Is there a way to allow users to insert or delete rows when I have some
columns with formulas locked? If they insert a row, I want the formulas to go
into the row that they just inserted.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200609/1
...
|
1 |
28.09.2006 16:38:29 |
|
|
DATA SORT REQUIRES IDENTICALLLY MERGED CELLS???? HELP PLEASE
TRYING TO DO A DATA SORT AND IT WON'T STATING IT REQUIRES IDENTICALLLY MERGED
CELLS....
|
3 |
28.09.2006 16:37:40 |
|
|
Hide the rows
Hi
I have a data validation dropdown list. When I select an item, some
records are to be populated in the rows below with the use of HLOOKUP
function. The HLOOKUP functions brings the values from other sheet and
populate them over this sheet. It will have one to one thousand rows
depending upon the Item selected. So, if there is just one record for
an item then the other rows will show zer...
|
1 |
28.09.2006 16:00:03 |
|
|
Delete cell on 1 page: automatically delete on another page?
I am setting up a to-do list on Excel. The first page is my weekly to-do
list. The additional pages are the "source pages" from which I will pull the
activities for my weekly list. I would like to set things up so I don't
have to take a lot of steps to transfer and delete cells.
1) Can I set it up so that I can click on a cell on "source page" and that
item will automatically get copied...
|
1 |
28.09.2006 15:18:02 |
|
|
How do I link a folder to a cell in an Excel spreadsheet
i have tried to hyperlink from a cell in an Excel spreadsheet to a folder in
a different directory. It works until I save and close the spreadsheet.
When I reopen the speadsheet the link comes up as invalid. Help....
|
3 |
28.09.2006 15:11:02 |
|
|
SUMPRODUCT ---> semicolon (;) vs. plus sign (+)
In order *not* to confuse SUMPRODUCT, we use semicolon as argument separator when comma is used as digit grouping symbol.
e.g.
=SUMPRODUCT(--(A1:A10>=123,45);--(B1:B10="abc");C1:C10)
However, we use the plus sign (+) to indicate both OR and ADDITION.
e.g.
+ used for "addition"
=SUMPRODUCT(--(C2:C31="TLG"),--(H2:H31="TLG"),D2:D31+I2:I31)
+ used for "or"
=SUMPRODUCT(--((...
|
6 |
28.09.2006 15:03:52 |
|
|
count of different type records
hi,
are there any way to count that how many different type of records are in a
column? for example, in column A are 6 times a210, 8 times a240 and 3 times
g450. in this case i have three types of record, but i have a little bit
bigger database and i would like to know how many types of record are in it.
i wonder that there could be something like countif or else but i have no
idea at...
|
3 |
28.09.2006 14:45:02 |
|
|
Color code cells
I need to color cells in a worksheet to show me when suppliers are late on
responsing to my requests. Can a cell be color coded so that if a supplier
is 7 days late responding it will be yellow and if the supplier is 9 days
late on a response then the cell color can be red, is this possible and if so
how?
Miller...
|
4 |
28.09.2006 14:04:02 |
|
|
eliminate access to page break
I would like to protect a worksheet and have the "Page Break Preview" not
accessable so no one can mess with the page breaks when the sheet is
protected....
|
1 |
28.09.2006 13:47:02 |
|
|
Absolute Value
How do you create a function to yield an absolute value of a cell in another
cell. For example, A1= -23. I want the absolute value 23 to be deplayed in
B12. But, if the A1 value is 23 instead, still the absolute value in B12
would still be 23.
hope this makes sense.
Thx
eric...
|
3 |
28.09.2006 13:29:02 |
|
|
help needed
Hi,
I have two columns in excel showing our company's pricing and our
customer's pricing. Both columns should read the same but i want to add
a formula that will show any differences.
any ideas?
thanks in advance.
--
cward1...
|
2 |
28.09.2006 12:47:16 |
|
|
Re: 2006 West Coast Excel / Access User Conference
2006 West Coast Excel / Access User Conference - October 25-27, 2006
http://www.exceluserconference.com/WCEUC.html#Tentative_Schedule
Mike Alexander
Alison Balter
Dick Kusleika
Simon Murphy
Jon Peltier
Bob Umlas
The regular registration period is coming to a close on September 30th. Be
sure to register this week if you would like to get in before the late
registration period begins....
|
1 |
28.09.2006 12:08:37 |
|
|
Using COUNTIF on multiple fields
I'm trying to use COUNTIF to summarize different conditions with 2
parameters.
Example 2 column table:
Apple 1
Apple 3
Bear 3
Bear 1
Bear 2
For example, how can I get a count of everything that is a Bear AND is
>1?
Sorta like this (but this is the wrong syntax):
=COUNTIF(A1:B5,AND(A1:A5=Bear,B1:B5>1))
Thanks!
...
|
14 |
28.09.2006 11:57:22 |
|
|
IF Function Problem Excel 2000
I'm trying to calculate a formula in Excel using the IF function. Here is my
code.
=IF(B2>=9/1/2006,5,IF(B2>=6/1/2006,4,IF(B2>=3/1/2006,3,IF(B2>=1/1/2006,2,IF(B2>=9/1/2005,1,0)))))
Basically this is what I want returned.
If B2>=9/1/2006 then it equals 5
If B2>=6/1/2006 then it equals 4
If B2>=3/1/2006 then it equals 3
If B2>=1/1/2006 then it equals 2
If...
|
5 |
28.09.2006 11:40:14 |
|
|
In a function, How do I copy the cell color as well as text
All I want to do is to say for example that Cell A1 is equal to Cell G8 and
have A1 contain the same text as G8 and have the same fill colour...
|
2 |
28.09.2006 11:35:01 |
|
|
VLOOKUP return text not date
I am using VLOOKUP to return a date, however it returns the number of the
date, rather than the date. I know that Excel stores dates as numbers, hence
how do I get around this?...
|
4 |
28.09.2006 11:11:02 |
|
|
REmid function
Hi All,
I am using the REmid function to pick out 13 character strings that end with
l, h, c or u.
e.g. cell A1 contains....
FIELD C2 @CHANGE ("PRPPRUNWECEOl") SIGN NOZERO;
=REMID(A1,"\b\w{12}(l|h|c|u)\b") returns PRPPRUNWECEOl
However, i also have 13 character strings that contain "$" and "£" i.e.
PRPGU$NY$CILl.
The REMID function above does not return these strings, what do ...
|
6 |
28.09.2006 11:03:10 |
|
|
Can Excel show changes between two separate spreadsheets?
...
|
1 |
28.09.2006 11:01:02 |
|
|
Packing characters
Hi
I have an exercises where I have a list of different names, of different
lengths but I want a result which packs out the name with trailing spaces so
that the final length of the name and spaces always equals 15 for each.
ie john needs 11 spaces added to it for the length to be 15 but andrew needs
9 spaces added.
Thanks
G...
|
4 |
28.09.2006 10:52:39 |
|
|
demand planning templates
...
|
1 |
28.09.2006 10:15:01 |
|
|
Can a formula find a comment in a cell
I would like to check to see if a cell has a comment or not, without using a
macro. In other words, If the value of the cell is between 10 and 20, and
there is not a comment attached to that cell, I want to display "No". If the
value of the cell is between 10 and 20, and there is a comment attached to
that cell, I want to display "Yes".
In a macro, I can use:
If (Cells(row, col).Comm...
|
4 |
28.09.2006 06:47:12 |
|
|
excel searching
How do I get excel to quit looking for a add in that has been deleted? I am a
bit of a novice so lack the expertist needed for this.
Thanks Anyone...
|
3 |
28.09.2006 06:22:01 |
|
|
conversion of book bar code to ISBN
Is there a formula or method that will convert the barcode printed on book
to the ISBN. - I can scan the barcode into Excel eg barcode is 9781585955565
and the ISBN is 158595556 - the last digit in the ISBN number is a checksum
digit, but I really need the ISBN.
thanks for any suggestions/advice
...
|
5 |
28.09.2006 06:21:00 |
|
|
Comparing data
Dear friends,
I have the list of names that changed with the time. I need to compare them
and find out the differences. Anyone can help me with this issue? Any
assistance will be appreciated. Thanks beforehand
...
|
5 |
28.09.2006 06:04:01 |
|
|
Dynamic Cell Lables? Or better solution....
What I am trying to do: Create cell labels that are a composite of the
contents of other cells.
Example: An investment club contributions sheet for all months and all
members
A1 = Name
A2 = John Smith
B1 = January
B2 = $500
I want to create a label for cell B2 such that it takes from $A2 and
$B$1 so that the label is something like "January:John Smith" .... or
something similar.......
|
6 |
28.09.2006 05:44:56 |