| Thread | Last Post | Replies |
|
| IF - Nesting... almost got it - need a bit of help | 22 Aug 2005 22:31 GMT | 1 |
=IF(S8="CLOSED","1","0")
Got that far... but need a final push
I need it to say - if =CLOSED 1
if =OPEN 0
|
| drop down lists/validation tables | 22 Aug 2005 22:16 GMT | 1 |
I have a worksheet with 6 columns, in each, I want to create a list that
I can pick from. Example, column A would be Sales Rep. When I get to
cell A2, I want a drop down list that has all of my reps in it. I can
then pick the rep from the list and it populates in the target cell. ...
|
| How do I calculate operating expense | 22 Aug 2005 21:54 GMT | 1 |
 Signature
K.E.
Tx.
|
| Automatic Date Entry | 22 Aug 2005 21:48 GMT | 1 |
How can I get excel to automatically add to a row the date that the row of
data was entered? Can I add a second column to say when it was last amended?
|
| Logic Tree, MS help = useless | 22 Aug 2005 21:43 GMT | 3 |
My setup is this:
4 columns, with "yes" or "no" in each column, describing a set of
objects. I have a logic tree that my boss gave me, with 15 possible
integer outputs, corresponding to the yes/no paths each object might
|
| multiple results when using filter function | 22 Aug 2005 21:33 GMT | 2 |
Good Morning Folks...
I will try my best to explain this. When you filter this the TYPE will show
all the options in the drop down combo box. So far what I able to solve is
that when select TYPE (let say for example TYPE 1), it will display the TYPE
|
| VLookup and HLookup at the same time | 22 Aug 2005 21:17 GMT | 3 |
How do you do a vlookup and hlookup at the same time:
D E F
A 1 4 7
B 2 5 8
|
| Make an =if show - instead of 0 | 22 Aug 2005 20:58 GMT | 3 |
='Accounts Payable'!L3
I want this formula to show - if it is "0" .
The Accounts Payable L3 is also a formula.
Is an if error required?
|
| merging sheet1 to sheet2 | 22 Aug 2005 20:55 GMT | 3 |
Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel.
Commonly I need to copy data from sheet1 and paste to sheet2. Here's the
kicker--what is on row 1 in sheet1 may be on row ...
|
| I need to insert a drop down menu in a cell? | 22 Aug 2005 19:45 GMT | 1 |
It has been a while since I have sat down and worked with excel, so if you
coule help me out by explaining to me how you insert a dropdown menu in a
workbook that would be great.
Thanks
|
| Can I modify Excel 2003 color palette to accept Pantone colors? | 22 Aug 2005 19:39 GMT | 1 |
My company uses a selection of colors chosen from the Pantone library. If I
want to use these colors in Excel can I "tell" Excel to apply the Pantone
library or do I have to individually modify Excel's standard colors?
|
| I want to use the same function as SUMIF, but for two criterias | 22 Aug 2005 17:46 GMT | 3 |
Is it possible to sum one column based on two criterias, for example country
and type of store? I have done that for countires with SUMIF, but I now want
to have two parameters instead.
I would appreciate any help on this,
|
| how to reference external refereces from a list | 22 Aug 2005 17:17 GMT | 7 |
Example:
worksheet1.xls
A B
1 Albert Operations
|
| Copy Formula - EXACTLY | 22 Aug 2005 16:45 GMT | 6 |
Somewhat of a novice with Excel ... how do I copy a formula and paste it
without having the formula change the range?
Here's what I'm copying:
=VLOOKUP("1A",Players!C4:F57,4,FALSE)
|
| Max number of IF statements | 22 Aug 2005 16:08 GMT | 3 |
What is the max number of If statements you can use in a formula ?
Thanks,
yosef
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread