|
|
|
October 3rd, 2003 10:04 PM
by ed
|
7 |
373 |
|
|
|
|
4 |
77 |
|
|
|
|
1 |
56 |
|
|
Total Field Always Visible by
brandolph
I currently have a sheet that has values in D1-D10. I would not only like to show the total of those cells, but I would like the amount to appear directly...
|
|
1 |
102 |
|
|
VLOOKUP by
Brandon
I have this function which works.
=VLOOKUP(A3,NewRev!$A$1:$B$286,2,FALSE) for A3-A500ish
However, if what is in A3 doesn't return a result from the NewRev...
|
November 23rd, 2009 06:40 PM
by T. Valko
|
3 |
100 |
|
|
Remove Text by
Brandon
I need a function to remove text from a cell and leave 5 digits at the very
end of the string.
For example:
Company One 11111
Company 2 22222
Com Three...
|
|
7 |
104 |
|
|
"IF" help by
Brandon
Here is a brief and thrown together explanation of what I want:
In cell A7 I want SUM(A1:A6)IF(SUM(A1:A60) AND IF(SUM(A1:A6=0)Leave Blank
In cell A8 I want...
|
October 6th, 2009 09:58 PM
by Brandon
|
3 |
106 |
|
|
|
February 13th, 2009 01:32 AM
by Max
|
4 |
57 |
|
|
|
|
1 |
69 |
|
|
Help with formula by
Brandon
I want to return the first date in which the sum of the previous columns
first exceeds inventory on hand (total). Should return 4/5 on this...
|
April 13th, 2010 10:48 AM
by Stefi
|
1 |
135 |
|
|
Which formula(s) do I need? by
Brandon
Hello,
It has been a bit since a statistics class and I cannot remember which
formula(s) I should be using. What I am trying to do is this: I have data...
|
November 27th, 2008 06:19 PM
by Brandon
|
3 |
62 |
|
|
Two Formulas for one Cell? by
Brandon
I am trying to execute the following formula for dates of sent/received files
and I am also showing elapsed days since the files were sent....
|
|
2 |
55 |
|
|
Excel Manual Calculation by
Brandon
I am an advanced excel user. I have used excel on a daily basis for over 15
years now. I work in accounting. Recently in the past year I have been an...
|
April 25th, 2008 07:16 PM
by Brandon
|
4 |
91 |
|
|
Time Formula by
Brandon
Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only returns
22:00...
|
October 28th, 2007 07:43 PM
by Brandon
|
2 |
78 |
|
|
Schedule by
Brandon
I'm making a work schedule in excel but I would like to make a graph or a
table showing we the employee works
Here is how the data looks like:
...
|
October 22nd, 2007 04:21 PM
by Brandon
|
5 |
50 |
|
|
|
August 9th, 2007 05:40 PM
by Tevuna
|
2 |
62 |
|
|
placing NOW function in IF function by
Brandon
Hey,
I'm trying to use the IF function to create a time stamp in another cell
if the Logical_Test is true. I'm kinda at a loss. If anyone could help me
that...
|
June 29th, 2005 09:32 PM
by bj
|
9 |
143 |
|
|
Return number of current sheet by
Brandon
I'm looking for a way to create a function to return the current sheet you’re
working in. Not it’s name (I’ve found that function), but the number of...
|
|
3 |
282 |
|
|
|
December 3rd, 2003 03:49 PM
by Brandon
|
0 |
197 |
|
|
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 |