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
Forecast IF Error Formula by Denver
Hi, I have this formula in my excel worksheet FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1))) I want to add the IF(ISError) formula from the above forecast...
June 21st, 2009 07:05 AM
by Denver Go to last post
2 79
June 21st, 2009 03:06 AM
by FSt1 Go to last post
1 81
Pasting formats and values without formulas by Rae
How can formatting (number and font, cell highlighting, size, etc.) and cell values be pasted without pasting formulas?
June 20th, 2009 04:48 PM
by Gord Dibben Go to last post
3 72
Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP by PJ Murph[_2_]
There are single digits in Col A (0-9). I want to know how many times the double digit numbers in Col B end in the number from Col A. (e.g. if Col A=1then if...
June 20th, 2009 04:36 PM
by PJ Murph[_2_] Go to last post
3 79
含有計算公式的文*句* by rg88
如何在同一個cell裏面,寫上含有計算公式的文*句*,而這文*句*裏的數目會隨著輸入的數**據該公式更新?
June 20th, 2009 06:07 AM
by rg88 Go to last post
0 76
General ledger spreadsheet continued by Mark C[_3_]
My specific problem is when my spreadsheet contains calculated values for example: PAID =F5+I5+L5+O5+R5+U5+X5, where PAID is the title of a column and all of...
June 20th, 2009 03:32 AM
by JoeU2004 Go to last post
1 79
sumproduct with partial charcter matching by Matt
I'm trying to achieve the following summary based on the data in the 'Data table' below. I require assitance to construct a sumproduct formula that will...
June 20th, 2009 03:30 AM
by Max Go to last post
3 55
Can I use NOT with COUNTIF? by JALunceford
Can I use NOT with COUNTIF? I have a column with values of "Complete" an "Not Complete". I don't want to add the "Not Complete" in the count. I've racked...
June 20th, 2009 02:25 AM
by T. Valko Go to last post
6 72
lookup same or similar by NeedToKnow
Hi all, I have tried to search old messages without luck. I have 2 files which has column A = Vendor name, col B = order value EUR, C-f = other data. I need...
June 20th, 2009 01:09 AM
by Keith Faulconer Go to last post
3 100
Find matching records in two tables using mulitiple criteria by RC
-- RCIn this case there are two tables of data of different sizes copied into the same worksheet. What is needed is to find each row of records in the first...
June 19th, 2009 11:41 PM
by RC Go to last post
2 80
Prepending numbers by Florian68
How do I prepend or add a number to the beginning of a series of numbers? For instance, I have a 4 digit number, 1001, that I want to be 11001. This is the...
June 19th, 2009 09:57 PM
by T. Valko Go to last post
2 55
Return value based on another vlaue by Jesse
I am trying to search a list of names (1200 names) for an exact match then return back a department number. For instance if John Doe works in Dept. 10. I...
June 19th, 2009 09:08 PM
by Fred Smith[_4_] Go to last post
1 60
Conditional Formulas by Wendy
I need to know how I would write the formula for this function, if anyone could help me that would be wonderful If a number in a cell is between 1-15 then I...
June 19th, 2009 08:21 PM
by Wendy Go to last post
6 64
Iteration by Khalil
What is iteration and how to use it; please advise regards Khalil
June 19th, 2009 08:21 PM
by Khalil Go to last post
4 68
formula to limit expenses to 1 of 2 values by cynomolgous
My spreadsheet tracks expenses for faculty accounts. They are limited to $700 for conference travel OR $500 for other research expenses. I added a column for...
June 19th, 2009 07:34 PM
by Bernie Deitrick Go to last post
6 79
writing an formulae with variable parameters by Formulas with variable parameters
I want to find the maximum (in each week) but along the years the first and last position changes. For that i use "=MAX(D124:D1345)" Now imagine that I...
June 19th, 2009 06:58 PM
by Bernie Deitrick Go to last post
2 69
#Value in random cells by Michael
I have a formula to calculate the hours I work based upon time in and time out - time in is deducted from time out. Since my time is based on two weeks and...
June 19th, 2009 06:31 PM
by JoeU2004 Go to last post
2 65
General ledger spreadsheet by Mark C[_3_]
I am in the process of developing a general ledger spreadsheet for my church. The spreadsheet shows a list of the different funds in the church and I am...
June 19th, 2009 06:27 PM
by JoeU2004 Go to last post
3 74
Excel Spreadsheet by Lynn
Can anyone help me with an excel spreadsheet using interest rate?
June 19th, 2009 06:07 PM
by Marcelo Go to last post
5 68
Macro/Formula help by fgwiii
Hello, I am trying to run the following code as part of a macro and for some reason after I added additional entries to the ActiveCell.FormulaR1C1 = "=OR ...
June 19th, 2009 05:54 PM
by Luke M Go to last post
5 58
Post New Thread


Display Options
Showing threads 9941 to 9960 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 03:08 AM.


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