|
|
Drop Down List More by
bettyh
I have a drop down list, I want it to select the choice when the first letter
is typed in. How can I do that?
I just need the dropdown to ensure there are no...
|
|
2 |
176 |
|
|
Excel Spreadsheet on Purchase Ledger by
Naz
Hi, i am just starting up a small business and was wondering if anyone could
guide me the correct way of having control of the suppliers and their payment...
|
|
2 |
153 |
|
|
|
|
8 |
152 |
|
|
Sorting Data by
ginnie
If I have two columns, Column A which has Dates and Column B which has
numerical values for that date. And I have several dates that I need to take
that...
|
November 25th, 2009 04:33 PM
by Pete_UK
|
1 |
104 |
|
|
|
November 25th, 2009 04:32 PM
by John
|
2 |
151 |
|
|
|
November 25th, 2009 04:10 PM
by Swish7
|
0 |
121 |
|
|
Cell size by
Emece
I have a worksheet where I need the cells to be a square. Is there a way to
do this? Or should I specify same width and heigth so as to obtain a...
|
|
2 |
133 |
|
|
|
|
1 |
113 |
|
|
|
|
0 |
114 |
|
|
|
November 25th, 2009 03:23 PM
by MMs4MSU
|
0 |
131 |
|
|
How to retrieve the value? by
Eric
Does anyone have any suggestions on how to retrieve the first value after the
first ";"? On following example, I would like to retrieve 427,75 value, and...
|
November 25th, 2009 02:45 PM
by Luke M
|
3 |
86 |
|
|
ignore #n/a by
GENO
Hi
I would like to ignore cells which reflect #n/a and consider cells with a
value from 0 .... , here is my current formula
...
|
|
2 |
81 |
|
|
Hyperlink Viewing Pane Question by
Dennis
I have a hyperlink in Excel for a folder on our server. When I click on the
hyperlink in brings up the two viewing panes. The left side shows all the
other...
|
November 25th, 2009 02:22 PM
by Dennis
|
0 |
110 |
|
|
Calender sizing by
Joel
Hi
I was wondering if anyone could help me a problem, I have created an
Expenditure sheet showing my monthly bills. I have placed a calender Object
on...
|
November 25th, 2009 02:09 PM
by Joel
|
0 |
104 |
|
|
KEEP duplicate records by
Shon[_2_]
Is there a facility in Excel 2007 to KEEP duplicate records? I can find ways
of removing them through remove duplicates and advanced filtering but I want
to...
|
|
3 |
89 |
|
|
Help with setting up a formula by
Greggo G[_2_]
Hi. I need some help setting a formula for the following:
Info on Sheet1
Operation Item A Item B Item C
1.Cut 10 min 12 min 15...
|
|
2 |
79 |
|
|
Sumproduct and Sumif formulas by
Caroline
hi all
Hope someone can help! I'm using these 2 formulas:-
=-(SUMPRODUCT(('Actuals YTD'!$A$2:$A$630=3014111)*('Actuals...
|
|
2 |
95 |
|
|
|
|
3 |
100 |
|
|
|
|
2 |
94 |
|
|
|
November 25th, 2009 01:37 PM
by Luke M
|
1 |
96 |