A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 6th, 2010 08:48 PM
by Ron de Bruin Go to last post
1 174
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 --...
May 6th, 2010 08:36 PM
by Gary''s Student Go to last post
2 112
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...
May 6th, 2010 07:41 PM
by JRSmith Go to last post
0 100
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 Go to last post
2 216
Incorporating Cell color fill in an "if" logical function? by George_Sky
I want to identify a specific cell by highlighting it with a cell fill color when an "if" statement returns a "ture" response. How do I do this?
(Multi-page thread 1 2 3 ... Last Page)
May 6th, 2010 06:42 PM
by Luke Go to last post
45 2,510
Vlookup formula by iv
Hello, I'm using the following Vlookup formula: =IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May...
May 6th, 2010 06:07 PM
by Luke M[_4_] Go to last post
1 177
Basic help needed using sumproduct to do a league table by Cougarric
I have created a fairly basic league table that uses SUMPRODUCT to extract games won/drawn/lost from a list of fixtures. This works fine. However, the...
May 6th, 2010 06:07 PM
by Tom Hutchins Go to last post
6 180
Calc staff vacation time based on more than 1 criteria by Tacrier
I would like to calculate on a daily basis, accumulated vacation time based on the following criteria: Total daily hours (work and leave taken) Hours must...
May 6th, 2010 05:58 PM
by Tacrier Go to last post
0 145
assign a macro to send email in lotus notes from Excel spreadsheet by pdaws
I would like to assign a macro button to an Excel spreadsheet that when clicked will open up email in Lotus Notes 8.5.1 with the name of the Excel...
May 6th, 2010 05:13 PM
by pdaws Go to last post
0 203
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 ...
May 6th, 2010 05:09 PM
by Jacob Skaria Go to last post
1 106
Prevent Some/Allow Some cells to update on F9 by Arlen
Hi, Folks! Is there some way (using a Function or a checkbox, or even better, by simply clicking on/off the cells in question) to choose which cells will and...
May 6th, 2010 04:55 PM
by Arlen Go to last post
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 Go to last post
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...
May 6th, 2010 04:09 PM
by Tom Hutchins Go to last post
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...
May 6th, 2010 03:04 PM
by Dave Ramage Go to last post
1 96
Excell - two conditions count if factors are true when negative nu by linda
Formula to count if two conditions. I want to count column b when = "CAS" and if the number in column J is a negative number. I have tried...
May 6th, 2010 03:02 PM
by Glenn[_6_] Go to last post
2 105
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...
May 6th, 2010 02:23 PM
by Bernd P Go to last post
3 188
Why wont 'autofit' and 'wrap text' remain in tact? by Bermi Girl
I am trying to reference a cell in another worksheet that is formatted to 'autofit' and 'wrap text', but when the information of the original cell translates...
May 6th, 2010 01:29 PM
by Dave Peterson Go to last post
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)...
May 6th, 2010 11:48 AM
by Steve Dunn Go to last post
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,...
May 6th, 2010 11:33 AM
by Steve Dunn Go to last post
2 123
Copying info from worksheet to worksheet if info matches by Carrach
Hi there, would be grateful for any help. I have a very large workbook with many linked sheets. I would like to copy info from worksheet to worksheet if the...
May 6th, 2010 09:52 AM
by Carrach Go to last post
2 124
Post New Thread


Display Options
Showing threads 721 to 740 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.