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
Linking computer dates (time) to spreadsheet dates that have formu by bigisle
Aloha I am hoping someone is out there who can assist me. I have spent two days trying to do two simple things in a medicine sheet I made up. It involves...
January 3rd, 2010 09:05 PM
by ryguy7272 Go to last post
3 130
Why messages fail to appear on MSNews server by Joe User[_2_]
Rick Rothstein and I had similar experiences recently: posting responses that failed to appear on the MSNews server. Of course, there can be many factors...
(Multi-page thread 1 2)
January 3rd, 2010 07:31 PM
by Joe User[_2_] Go to last post
11 271
I'm unable to change font size on a excell sheet by Steve
I receive an email with a chart that allows me to enter info in a specific area. I received this a couple of years ago. Now I want to change the font size...
January 3rd, 2010 07:03 PM
by Gord Dibben Go to last post
1 132
Totalling seperate cells from a HLOOKUP function by SimonSNA400
is it possible to sum the product of 2 or more cells, 1 cell being the result of a HLOOKUP function, without creating a third cell for individual...
January 3rd, 2010 06:15 PM
by T. Valko Go to last post
8 245
Help with a predictive analytic by Rachel Costanza[_2_]
I am looking to create a fun dashboard that will tell people how often to check their social media outlets based on the number of friends / followers etc...
January 3rd, 2010 05:35 PM
by Rachel Costanza[_2_] Go to last post
0 116
Why do I get #### when I Autosum in Excel? by Otter Daughter
Windows XP SP3. I am a newbie in Excel. I am using the AutoSum function. Sometimes, I get correct dollar figure. Other times, I get a row of ##### signs,...
January 3rd, 2010 04:42 PM
by Dave Peterson Go to last post
2 155
nested ifs by david rose
Hi all, I am unfamiliar with nested IF statements. I want to have a formula evaluate the following: b1=.005, b2 could =-.004 or b2 could =.004 If b1 is ...
January 3rd, 2010 11:58 AM
by Joe User[_2_] Go to last post
2 176
need help with creating a formula which checks more than 40 cells by Faizan
Dear Heros, I am working on setting up salaries for emplyees based on new pay and grade system. the Pay and Grade system is organized to have 8 grades and...
January 3rd, 2010 10:13 AM
by Ayushj Go to last post
1 174
Sum Products with VLOOKUP by TWJOHN
Is it possible to sum the product of 2 columns, 1 column being the result of a VLOOKUP function, without creating a third column for the individual row...
January 3rd, 2010 07:02 AM
by T. Valko Go to last post
3 128
N/A Error with VLOOKUP Formula - Excel 2007 by David Scarfe
I have used the following formula to replace N/A with 0, where there is no value to return. =IF(ISNA(VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE), 0...
January 3rd, 2010 06:12 AM
by [email protected] Go to last post
6 193
Excel - count if a number falls within an array in a column & add by Nigel
Trying to write a formula that creates a count if a number in a cell in an array (a column) falls within a certain range, and then adds them up:...
January 3rd, 2010 05:53 AM
by ryguy7272 Go to last post
2 132
EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE by Bearski
My spread sheet, before I had this trouble, computed all the cells that contained formulas to show the values. Along the way I must have done something that...
January 3rd, 2010 01:42 AM
by Mike Middleton Go to last post
2 181
How to count the maximum number of consecutives? by JP
I need to determine the maximum number of consecutive negative numbers in a column. The column contains formulas that evaluate to a positive number, a...
January 3rd, 2010 12:19 AM
by JLatham Go to last post
9 1,016
graphic in excel based upon result by Mike S
In one of the available templates, there are icons that appear in the results cell based upon if the result is at or below budget, and also variable icons...
January 2nd, 2010 09:19 PM
by B. R.Ramachandran Go to last post
1 145
scoring multiple ski meets from one master list by confused
trying to score (6) different ski meets off of one master ranking. two teams are scored against each other points go from 16 down to 2. all teams run the...
January 2nd, 2010 08:12 PM
by confused Go to last post
0 109
Excel 2007 / right-click / pick from drop down list by R Vaughn
I am an Excel 2003 user who is beginning to use Excel 2007. In the "2007" version, what is the purpose of the "Pick from drop down list..." option...
January 2nd, 2010 05:35 PM
by Dave Peterson Go to last post
1 145
January 2nd, 2010 05:32 PM
by Dana DeLouis[_3_] Go to last post
1 244
Finding links to other files by AAMIFC
Hi I have an excel workbook were I have copied a worksheet from another file into. I have removed all referances that I could find to other workbooks, however...
January 2nd, 2010 05:12 PM
by JoeD Go to last post
3 97
sumproduct including previous years by tleehh
=sumproduct(d18:d1000,--(year(b18:b1000)=year(now()))) I need a formula to add all the values in d18:d1000. All the previous years including current year.
January 2nd, 2010 04:37 PM
by Rick Rothstein[_2_] Go to last post
1 128
Which Function(s) should I use? by Marbol
Hi All, I want to generate 5 lists using the preference column from raw data which is in the following format: Preference Name Club 1 ...
January 2nd, 2010 04:04 PM
by Ken Johnson Go to last post
7 132
Post New Thread


Display Options
Showing threads 4221 to 4240 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 08:28 AM.


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