|
|
Nesting drop-down menus by
Alonso[_2_]
Hi everybody
i'm working with nested dropdown menus
in column A select a machine
in column B choose a product (depends on the machine)
in column C pick a...
|
October 17th, 2008 06:59 AM
by Gav123
|
1 |
100 |
|
|
|
|
1 |
98 |
|
|
|
|
4 |
256 |
|
|
Date Formulas by
kaz
Could someone please help with a formula to work out the difference between
two dates and show how many years, months and days there are
|
|
7 |
105 |
|
|
dates by
rebecca
How can I change the date format 01/01/08 to 010108
|
|
6 |
107 |
|
|
Need help with logic or Vlookup formula by
Andrea
I am relatively new to excel and need help with creating a formula.
Based on the table below my goal is to take information from column A (or a
range of...
|
|
9 |
124 |
|
|
Excel VBA and Comment boxes by
DCPan
Hi,
I wrote something that would automatically place the cell content into a
comment box, and replace the cell content with the words "See Comments".
Now,...
|
|
3 |
133 |
|
|
|
October 17th, 2008 12:09 AM
by Max
|
1 |
110 |
|
|
Reference left most value in cell by
rtwiss via OfficeKB.com
How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true statement,
false statement)
Ex: A1= 45
I want...
|
|
3 |
119 |
|
|
Complex Conditional Formating by
Ben A[_2_]
I am trying to create condtional formating to turn a cell red with a complex
IF/ LOOKUP Function for the rule. The Function works outside of conditional...
|
|
6 |
86 |
|
|
Vlookup type thingy by
JockW
Creating a internal phone book for a company.
Sheet 1 has the following details:
Division
Department A
employee 1 123456
employee X 123457
employee 3...
|
|
5 |
92 |
|
|
Allocating remainders by
ramtroop
Example--I have ten vendors, each gets a % of a total. The remainder needs
to be allocated to the vendor with the highest %. Any way to automate that.
|
|
2 |
91 |
|
|
function? by
RT
Is there a Function for this formula??
=(E4*C4)+(E5*C5)+(E6*C6)+(E7*C7)+(E8*C8)
|
|
2 |
93 |
|
|
|
|
10 |
155 |
|
|
Correlation analysis by
todd012976459210
HELP!
I need to do a correlation analysis of mutiple variables against an
observable daily event. Can someone profiicient in Excel and statistics guide
me?...
|
|
6 |
96 |
|
|
IF NOT Statement by
rtwiss via OfficeKB.com
What am I do wrong here?
=IF(NOT(ISNUMBER(J12),ISNUMBER(K12)),"boy","girl")
--
Message posted via...
( 1 2)
|
|
10 |
225 |
|
|
Run Macro Based On Time by
Sabosis
Hello-
I have a workbook that send out department stats out every hour to our
management team. I need to add something (might be an IF statement) to
run a...
|
October 16th, 2008 09:31 PM
by Sabosis
|
2 |
81 |
|
|
AND, MAX by
PAL
I am working with the formula below. G2 and I2 are dates, or blank. If both
are blank, I would like a blank in the field, if one or both have dates, I...
|
|
8 |
97 |
|
|
IF Statement with two variables by
RoadKill
I've gone brain dead on this.
Here is my formula, what am I doing wrong?
Thanks
=IF(H12="Tier 1" & J12="Yes",(150*B12),"None")
|
|
8 |
109 |
|
|
|
October 16th, 2008 08:56 PM
by RagDyer
|
7 |
129 |