|
|
|
|
5 |
111 |
|
|
Histogram Function by
iperlovsky
Does anyone know what the underlying formula/macro is that this function uses
to determine bin size. I have a normal distribution for which I am using a...
|
|
2 |
93 |
|
|
|
|
3 |
95 |
|
|
Can't get my xlSheetVeryHidden by
cristine
I am unable to unhide my personal workbook with my macrso. The unhide feature
under the window menu option is greyed out. I've used Format, Sheet and the...
|
|
2 |
93 |
|
|
|
|
1 |
93 |
|
|
|
June 26th, 2009 09:01 PM
by Meenie
|
2 |
89 |
|
|
|
|
1 |
93 |
|
|
|
|
5 |
76 |
|
|
|
June 26th, 2009 08:27 PM
by biz7
|
1 |
113 |
|
|
CAn IF compare two cells? by
KevinS
I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it
as DUP else goto next line and repeat the action. Compare C4 to C3, etc.
--...
|
June 26th, 2009 08:16 PM
by Mike H
|
1 |
80 |
|
|
|
June 26th, 2009 08:11 PM
by Mike H
|
3 |
96 |
|
|
Conditional =CONCATENATE formula by
Bullocks
Can't get my head around this one (perhaps it's just Friday!)
Cell B15 has a simple formula (Adding two cells)
Cell B16 shaves off a couple of numbers number...
|
|
2 |
77 |
|
|
|
|
4 |
95 |
|
|
|
June 26th, 2009 07:00 PM
by JLatham
|
1 |
102 |
|
|
tracking inventory by
Jackie
if there's a # in the "Qty. Received" cell then I want it to add to the
"Current inventory" cell but if there's a # in the "Qty. Shipped" cell then I
want it...
|
|
6 |
94 |
|
|
Sorting Dates by Month and Day only by
John P
I have a column of dates in mm/dd/yyyy format. How can I sort them according
to month and day only. Can I use the Sort/Filter function or do I have to
create...
|
June 26th, 2009 06:05 PM
by Mike H
|
6 |
90 |
|
|
Absolute value conditional formatting by
E
Please can you help me with a simple question! I want to conditionally format
cells whose absolute value is greater than 1, ie, negative numbers -1, and...
|
|
4 |
124 |
|
|
|
|
1 |
75 |
|
|
AUTOMATIC CHANGES HIGHLIGHTING by
Kanmi
How can I Track changes on worksheet using colour to highlight differences
on COLUMNS that are change from the last modification when opening the file.
I...
|
June 26th, 2009 05:15 PM
by Kanmi
|
0 |
59 |
|
|
VLookup formula question by
Tim at alliant
I want to populate cells on worksheet 2 from worksheet 1 with values that a
user selects from worksheet one. The user can select multiple values but I
only...
|
|
2 |
66 |