|
duplicate entries
I have a cloumn that you have to put in an EE number, it the useis Vkookup
to find the employee and the propigates the information requested. I need a
way to tell if I enter a duplicate number in the EE number column. any ideas...
|
5 |
12/31/2008 5:51:01 PM |
|
|
check and uncheck macro
How can I use the checkbox to use a different macro when it's checked
or unchecked? In this example: I want to copy paste from one location
if
is unchecked and from a different location if is check and I uncheck
the checkbox.
Facts:
The checkbox is placed on a worksheet, named May
A checkbox from the Forms toolbar
My checkbox is number 11 (checkbox11)
the first task is to cop...
|
6 |
12/31/2008 5:49:27 PM |
|
|
Unicode in Office 07
I am having problems with Unicode...when I upgraded to 07
the unicode string does not represent the same characters as it
previously did in the older software...furthermore the character I
used to use does not come up in my character map anymore as
having an Alt code...I have found other Alt codes for that character
on the internet but they dont actually work in Excel 07 ...
|
1 |
12/31/2008 5:49:01 PM |
|
|
Lookup - in various areas within Workbook
I need to do the following:
(1) Lookup the values in Worksheet #1, Column G,
(2) FIND the SAME value in Worksheet #2, Column E
(3) RETURN the Value from Worksheet #2, Column B (on the same row where the
lookup value was found in Worksheet #2, Column E
Worksheet #1, Column G
Apples
Worksheet #2
Col B Column E
ABC ...
|
3 |
12/31/2008 5:28:00 PM |
|
|
How do I select all cells with a value less than 1?
I need to eliminate all cells with a value less than 1, but I don't know how.
Can anyone help explain this to me?
Thanks!...
|
5 |
12/31/2008 5:18:18 PM |
|
|
convert bond price to decimal including +
looking for formula to convert bond price to 32nds
columns have for example
79-10 which is 79 + 10/32
103-12 which is 103 + 12/32
79-10+ which is 79 + 10.5/32
103-12+ which is 103 + 12.5/32
saw a post on here about converting 32nds but not +'s...
|
10 |
12/31/2008 4:33:15 PM |
|
|
Complex lookup
Good morning --
I'm trying to design a lookup table to work like this:
Type Apples
Value 35
Value Earnings:
Range 1 Range 2 Range 3 Range 1 Range 2 Range 3
Apples 10 25 50 $50 $75
$100
Oranges 25 50 75 ...
|
5 |
12/31/2008 4:32:40 PM |
|
|
Return a Title based on a name
I have a proposal sheet used by multiple users, and I would like the cell I
have dedicated to the title of the individual proposing the work to be filled
out automatically once they have placed there name in the cell dedicated for
a signature. Any and all help would be greatly appreciated. ...
|
5 |
12/31/2008 4:17:01 PM |
|
|
Extracting text from a cell
Hello,
I am attempting to extract text from an email address in a cell.
For example
If the cells are the following
GeneralName@Company.com
Testing@AnotherCompany.com
I want to write a formula that will extract
Company
AnotherCompany
Any help will be appreciated....
|
5 |
12/31/2008 4:16:27 PM |
|
|
Formula Help
I need help setting up the following cell formulas. Can anyone help with this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0
...
|
4 |
12/31/2008 2:49:02 PM |
|
|
How do i find last not empty cell in a range
My senario (xl2003)
B3,B4,B4 holds an X
C5,C6,C8,C9,C10 holds an X
E4,E5,E6,E7 holds an X
and nothing more on that sheet
Is there a formula that return's a cell-address C10 (last not empty)
And how to do the same in VBA
i no about selection.specialcell.xllast to find row 10
and now i do a loop thru rng A10 to F10
but is there another smart way ?...
|
10 |
12/31/2008 1:59:02 PM |
|
|
Total costing
Hello
I am working on a payment file
The first sheet called costing contains a list of all items that we
might purchase
A5 : List of Items
B5: month 31/12/2008
C5: 1/1/2009 etc
each month i entered the item and the total price of what we bought
each month has his own sheet
Sheet 31-12-2008 " B10=List of Items C10= Total amount
Sheet 1-1-2009 " B10=List of Items C10= Total a...
|
2 |
12/31/2008 12:54:00 PM |
|
|
Please help
I had posted a question with subject "Help in ranking Formula" and I got the
reply mail from notifyMS@microsoft.com and tried clicking the link "Read and
rate the response' even that doesn't work or even searching by the subject
doesn't retrieve data pls help....
|
3 |
12/31/2008 12:10:01 PM |
|
|
Parse Before Line Break
I could use some help making a formula to return all characters before a
carriage return [or an alt-enter or Char (10), depending on how you referr to
it].
The Cell has a lot of text in it and can have more than 1 carriage return in
it...
Any ideas?...
|
4 |
12/31/2008 8:35:39 AM |
|
|
Sum Function w/ #DIV/0!
Is there a way that I can add a column that includes #DIV/0!
Biff...
|
14 |
12/31/2008 8:32:04 AM |
|
|
SUM 3D Reference using variable sheet limits
I want to SUM the values in the X35 cells from multiple sheets named for
months (Nov2008 . . May2009 etc.). I need to be able to easily change the
limits of the sheets to be included in the calculation, (ie: Nov2008 . . May
2009, then recalculate for Jan2009 . . April2009).
AD31 will contain the name of the first included sheet ('Nov2008), AF31 will
contain the name of the last includ...
|
7 |
12/31/2008 8:14:00 AM |
|
|
Using the return from ADDRESS within another formula?
Hey all,
Wondering if I can get some help with this. Is there any way I can use
the ADDRESS function within another formula?
I have a formula right now which essentially tells me the start of a
range I want to start an offset from So, this formula, using ADDRESS,
currently returns "$B$33." Here's the formula in case you are
interested:
=ADDRESS(MATCH(F14,commandsxp,0)+2,MATCH(E14,room...
|
6 |
12/31/2008 8:13:00 AM |
|
|
how to link format of cells
I need to update the format/appearance (text and fill color, border etc) in
other worksheets, as and when I manually change them on the first sheet.
More clearly, I have to generate four different types of consolidated
reports from the daily reports. I have a master worksheet for
updating/entering the daily reports ( i change the cell content and
appearance). As a when I updated this work...
|
2 |
12/31/2008 7:45:47 AM |
|
|
Excel Iterative calculations
I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?...
|
4 |
12/31/2008 7:30:01 AM |
|
|
Elegant Formulas
I use Notepad++ that allows a more clear (elegant) way to edit/
visualize script like this
function changeImages() {
if (document.images) {
for (var i=0; i<changeImages.arguments.length; i+=2) {
document[changeImages.arguments[i]].src = eval
(changeImages.arguments[i+1] + ".src");
}
}
}
// END -->
If I have a excel formula like
=ISNUMBER(FIND(LEFT(B2,1), "AW...
|
3 |
12/31/2008 6:39:19 AM |
|
|
parsing name in cell by comma?
Trying set up worksheets for use in access.
Sheet A has a list of doctors and their practices, i.e., Name= Smith, John
I., Practice= Anytown Pediatrics
Sheet B has a list of patients and their admitting doctor, but in this case,
it's Smith, John I (no period).
Trying to get to a result of associating the admitted patients to
appropriate practices. I think the best is to parse the MD...
|
4 |
12/31/2008 6:36:00 AM |
|
|
If statement with multiple ifs
Not sure if I'm explaining this right but here it goes:
Trying to get an IF statement where if a certain set of data is entered into
a cell the resulting cell will have a certain output:
ie. If A1=Red then b1 would be 1 or if A1=Blue then b1 would be 2, etc.....
Hope someone can help on this!
Thanks,
Sean N...
|
5 |
12/31/2008 6:14:01 AM |
|
|
#NAME?
I received a spreadsheet via e-mail and when I opened it all was fine.
Formulas appearing to working perfectly. As soon as I saved it to my
computer a whole column changed to #NAME? in place of the values that were in
their. The formula in the first cell is:
=IF(I42="","",NETWORKDAYS(A42,I42,NonWorkDays2008)-1). The named range
"NonWorkDays2008" is in a worksheet within the same wor...
|
8 |
12/31/2008 6:04:09 AM |
|
|
Count the times a value appears in a column based on another value
I am using the following formula to count the number of times "Web" appears
in column B based on "1" being in column D:
=IF('List of Reviews'!B:B="Web",COUNTIF('List of Reviews'!D:D,1),0)
I continue to get a #NUM! error for the logical test in the IF statement
even when the formula is reversed and I try to count the number of times
"Web" appears for every row which contains a "1" in co...
|
5 |
12/31/2008 5:56:08 AM |
|
|
Combine results of 2 formulas
In cell A1 is the formula:
=MIN(C3:C11) 'Returns the earliest date
In cell A2 is the formula:
=MAX(C3:C11) 'Returns the latest date
What I need is a formula that I can put in cell A5 which returns something
like:
12/14/08 to 01/22/09...
|
3 |
12/31/2008 5:34:04 AM |