|
|
Sort anomoly by
Hawthorne 53
My column A, "Account Description" is formatted as General; Column B, Fiscal
Year, is formatted as Number. On a two level Sort, Col. A and then Col. B,
all...
|
|
2 |
95 |
|
|
Ending in Macros by
Evil with a K[_2_]
I am unfamiliar with the writing MACROs I rely specifically on recorded
macros. My issue is I format and consolidate a large number of excel files
prior...
|
|
2 |
114 |
|
|
Template Instructions by
dd53
What do you call the pop up instructions embedded in the templates and how do
you remove them when you save your changes?
--
love life
|
|
4 |
169 |
|
|
Function Question by
Having Issues
I know this should be easy, but I haven't done formulas for a while.
I am trying to copy top to bottom of a spreadsheet via formulas instead of
copying and...
|
|
5 |
166 |
|
|
autosum and page breaks by
forward
autosum works unless I ask it to calculate across page breaks? ie =T1:T100?
thanks
|
|
1 |
101 |
|
|
|
|
4 |
135 |
|
|
Excel 2007 Conditional Formatting by
Jordan
I am trying to apply conditional formatting to a column of numbers based on
the value in the cell.
If the number if greater than 1 I would like it to be...
|
May 18th, 2009 08:49 PM
by Jordan
|
3 |
105 |
|
|
Making a row blink as a warning. by
Anthony
I am setting up an excel sheet, so that it can help me know when instruments
need calibartion or PMs. I want to make a row blink or flash.
|
|
2 |
120 |
|
|
Polynomial Trendline by
Royi Avital
Hello.
I found the Trendline function in Charts very useful.
My question is: Are there equivalent functions?
hat I mean, I know about "Trend" and "Linset"...
|
|
5 |
246 |
|
|
|
|
2 |
240 |
|
|
How to combine, IF, AND, OR Functions by
Simony32567
Hi all
I need some help combining IF, AND, OR functions (if it is possible)
What I am looking to do is:
I want all the results to display in F70
I have...
|
|
2 |
132 |
|
|
Find unique values using 2 variables by
Tony7659
I have 2 columns of data: 1 numeric (with some " " from the formula) and 1
text. I need to find the count of rows with unique values in column 2 and
numbers...
|
|
2 |
226 |
|
|
|
|
1 |
139 |
|
|
count unique values if 2 variables by
Tony7659
I have 2 columns of data, 1 numeric (maybe with "" due to formula) and 1
text. I need to count any rows with numeric values in column 1 with the same
text...
|
|
3 |
185 |
|
|
|
|
5 |
158 |
|
|
formulas by
FUNACH
need to average lowest 6 out of 10 cells?
|
May 18th, 2009 06:23 PM
by FUNACH
|
2 |
130 |
|
|
Rich Text Boxes by
SueDot
Is there a way to insert a rich text box into a worksheet?
We need a box that basically works like a Word document - it will mostly be
used to created...
|
May 18th, 2009 05:00 PM
by SueDot
|
2 |
130 |
|
|
Look up functions by
[email protected]
Hi,
I am currently in the process of trying to return a value based on a
data element being found with a specified date range.
One element is the look up...
|
|
2 |
174 |
|
|
add-ins by
Rynosun
I am using vista, there is no tools tab, however, in excel options for
add-ins, the analysis toolpak is checked, but still is not appearing on
add-ins menu...
|
|
1 |
164 |
|
|
Unable to Spell Check in Excel by
Microsoft User[_2_]
While Using Spell Check in Excel i am getting the message "Formula is too
long" and hence Unable to check the Spell Mistakes.
Kindly Reply back with...
|
|
1 |
117 |