|
|
Sort by
Brandon
I have a spreadsheet with about a thousand lines of stock sales for the year.
I need to sort by this column alphabetically by the first word after the word...
|
|
2 |
186 |
|
|
#N/A help please by
cadustin
I have tried to correct this formula with the ISNA, and not getting any
result, please fix what I am doing wrong! I put the ISNA in the beginning and
am...
|
|
2 |
202 |
|
|
Help with If Sum statement - i think.... by
Scott_goddard
Hi,
I need to be able to do the following but i can not quite arrange the
formula corectly....
I have one sheet that has all the weeks in coulumns (for a...
|
|
4 |
145 |
|
|
Rounding Up question by
spreadsheetlady
Hi,
A1 has the ROUNDUP Function referenced to B1: ROUNDUP(B1,0).
Example: B1 says: 6.2 A1 will roundup to 7. Perfect!
This works 99% of the time.
But in...
|
April 15th, 2010 05:20 PM
by Mike H
|
2 |
160 |
|
|
|
|
2 |
225 |
|
|
Ad-In Rowliner by
Eurika Stemmet
How do I prevent the background from changing when I use Row-Liner in a protected worksheet. I used the following VB Code, but the backgrounds I used changed...
|
|
4 |
183 |
|
|
Excel IF Formulas by
mgreen-NJ
Good afternoon -
I need to create a formula in a cell that indicates if that particular cell
returns a certain value then the entire row of information...
|
|
2 |
103 |
|
|
Show time as a negative figure by
JCR1987
Can someone tell me if it's possible to calculate time as a negative
figure. I'm trying to do a calculation where if you work less than
contracutual hours it...
|
|
3 |
165 |
|
|
Convert percentage into margin by
Linda
Here is my quandry and I am probably over thinking it. I have a starting
cost of $26.00 with an end cost of $26.54. I need to know the formula that
will...
|
|
2 |
214 |
|
|
|
|
7 |
185 |
|
|
Countif/SumProduct by
excelllllllll
Hi,
ok i have 2 columns....
Column A Column B
32 -
54 20
|
|
4 |
143 |
|
|
|
|
1 |
150 |
|
|
multiple dependent drop down lists by
Mikej
Hi,
I am trying to implement multiple cascading drop down lists. I have two
worksheets: a user one (with the dropdown lists and data tobe displayed) and
a...
|
April 15th, 2010 02:11 PM
by Mikej
|
6 |
204 |
|
|
Adding a value to a customer ID? by
Anne
Hello!
I have a case number for a patient. 2009-001, for example, in C2.
I also have a contact number for the patient's family member, in D2.
How can I combine...
|
|
4 |
153 |
|
|
|
|
4 |
176 |
|
|
Can I combine a Vlookup with an IF formula? by
Claire[_2_]
I'm not sure Excel can do what I want it to do -
I have a VLookup formula on my spreadsheet which is returning data, however,
I only want it displayed if it...
|
|
2 |
141 |
|
|
Filldown starting from F2 instead of F1 by
Ephraim
Can anyone help me modify the following so that when Col F fills down
it starts at F2 instead of F1. It works great but everything in Col F
is up one cell too...
|
April 15th, 2010 01:05 PM
by Ephraim
|
5 |
146 |
|
|
|
April 15th, 2010 11:12 AM
by Mike H
|
1 |
139 |
|
|
|
April 15th, 2010 09:58 AM
by Mike H
|
2 |
188 |
|
|
Pulling/Collating Data by
chrisk
Hi,
I have a workbook with 31 sheets (diary)
A9:F9 (and other rows) is the info I want with the employee's initials in G9
There are multiple entries for the...
|
April 15th, 2010 09:53 AM
by chrisk
|
4 |
165 |