|
|
Edit Excel file by
pdaws
I have a macro in Excel that allows me to send an email from the spreadsheet
to another person in email as an attachment using Lotus Notes. When the...
|
|
1 |
191 |
|
|
Difference between two numbers by
Pam
I have two columns, each with numbers in them. All I want to do if find the
difference between these two numbers. Don't want whether negative or positive
--...
|
|
2 |
129 |
|
|
Conditional Formatting by
JRSmith
Hi and TIA. I have a worksheet like so. I'm trying to conditionally format
the cells in Column C. If this is possible where do a place a call to the...
|
|
0 |
117 |
|
|
COUNTIF not counting properly by
DogCrazy
Hello, I hope someone can help!
I am using the following formula: =COUNTIF(AM6:AM105,"=1.0")-(AM112+AM113)
It works great except it will not count any...
|
May 6th, 2010 07:35 PM
by Paul C
|
2 |
234 |
|
|
|
May 6th, 2010 06:42 PM
by Luke
|
45 |
2,541 |
|
|
Vlookup formula by
iv
Hello,
I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May...
|
|
1 |
194 |
|
|
|
|
6 |
180 |
|
|
|
|
0 |
164 |
|
|
|
May 6th, 2010 05:13 PM
by pdaws
|
0 |
220 |
|
|
two condition formula by
linda
I am trying to count column "a" when a condition is true and then count
column "j" when the number is a negative.
I have tried ...
|
|
1 |
123 |
|
|
|
May 6th, 2010 04:55 PM
by Arlen
|
2 |
153 |
|
|
How to clear all checkboxes on a form? by
Arlen
That's it. How is it possible to create push-button functionality that
resets all checkboxes to empty?
Also, is it possible that pushing a button could...
|
May 6th, 2010 04:20 PM
by Arlen
|
2 |
143 |
|
|
Save As csv Carraige Return issue by
WaterBug
I have a large xlsx file with the last column containing text with carraige
returns (CR). When I save this xlsx as a csv file these interim CR are
preserved...
|
|
3 |
131 |
|
|
Conditional Formatting by
Andy K[_2_]
I am trying to format cells that meet the following criteria +/- 10,000 AND
(greater than 20% OR less than (-)20%). I can't get the rules to recognize
the...
|
|
1 |
96 |
|
|
|
|
2 |
122 |
|
|
Rank order with conditions by
clamberti
I am trying to rank order data so that there are no ties.
If there is a tie in the score (column A) then Yes precedes No in column B.
If there is still a tie...
|
|
3 |
205 |
|
|
|
|
3 |
158 |
|
|
Formula help please by
John
HI, HELP REQUIRED WITH FORMULA FOR EXCEL PLEASE
Q:
EXCEL WORKBOOK WITH TWO SHEETS, ONE TITLED MON & THE OTHER STAT.
ON SHEET MON, I HAVE TWO COLUMNS (H, K)...
|
|
1 |
147 |
|
|
IF AND question by
Gamq
Hi there,
I need a function that can provide one of three answers:
1 2 1 1...
3 3 4 4...
? ? ? ?...
If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4,...
|
|
2 |
124 |
|
|
|
|
2 |
124 |