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
fromula to get data from multiple sheets by GAK
I want to get the data in my final worksheet from multiple worksheets depending upon the condition that i give is found true fro example i used...
August 28th, 2008 04:48 AM
by GAK Go to last post
0 113
How do I set a static date? by Shawn
In A1 I'm putting an Id number in and I would like to set a formula in B2 so that a static date appears, can this be done?
August 28th, 2008 03:51 AM
by Dave Peterson Go to last post
5 192
Multiple "IF"'s by Solar Man[_2_]
I thought I had this one licked. I have a list of TRUE FALSE cells. There are 18 of them. Say they were listed A1:A9 and B1:B9 then if A! is TRUE, insert...
August 28th, 2008 02:53 AM
by Solar Man[_2_] Go to last post
6 134
Excel by CCJ
how can i find the rate using VLOOKUP. Selling Price Loan Term 26,5354 30
August 28th, 2008 01:35 AM
by smartin Go to last post
1 106
Convert to Binary and Break out results by DCLittlejohn
I would like to take a 16-bit integer value, convert it to binary and then break the individual 1s and 0s into seperate columns. For example, a value of 5 in...
(Multi-page thread 1 2)
August 28th, 2008 01:23 AM
by Rick Rothstein \(MVP - VB\)[_1210_] Go to last post
10 203
Non-Array Play to Eliminate Blank Cells by Peter
Column A shows: 1.Apple 2.{Space} 3.Banana 4.{Space} 5.Yellow 6.Red How do I make Column B show:
August 28th, 2008 12:29 AM
by Peter Go to last post
5 103
nesting sumproduct with subtotal by SteveDB1
morning all, I have a worksheet that I'm attempting to analyze, and wanted to see if a nested sumproduct with subtotal would work. I.e., the idea made sense...
August 27th, 2008 11:38 PM
by SteveDB1 Go to last post
9 58
Basing a range for a linked spreadsheet on internal criteria by dstampor
Hello, I am trying to modify the following formula: =VLOOKUP(10,'W:\CARS Accounting\CARS Recs\Prod, Susp, Ext, Misc\2008 Product...
August 27th, 2008 11:29 PM
by dstampor Go to last post
6 149
Replace Link by Annette
I have 83 workbooks with 5 sheets per book and 21 links per sheet - and I need to replace - (basic link - ='C:\Users\Annette\Desktop\Annette Daily...
August 27th, 2008 11:12 PM
by Dave Peterson Go to last post
5 56
Worksheet calculation different from calculator's by KARTX
Calculations in my worksheet differ from the same calculation performed with a calculator by as much as 0.03. I have not been able to fix this with ROUNDUP...
August 27th, 2008 10:53 PM
by T. Valko Go to last post
9 66
Consolidating a Matching List by Peter
Assume I have a list of 30 rows with 5 fields each. A user can select whether a row is a match or not a match. I have setup a test to catch the selected...
August 27th, 2008 10:45 PM
by Spiky Go to last post
1 64
Conditional format row based on percentile by Acanesfan
I asked a similar question the other day and no one answered, because I posted it in general questions instead of worksheet functions. So I'm trying...
August 27th, 2008 10:41 PM
by Spiky Go to last post
3 78
What are the COUNT or other options ... by rugbykats
I am creating a spreadsheet that will allow me to keep track of a football game's statistics by entering the result as each play occurs. Generally, no...
August 27th, 2008 10:38 PM
by rugbykats Go to last post
3 70
Multiple IF Formula Question by Rob
I'm looking to do the following: If C5=1, -C21*12.50%, IF C5=2, -C21*15.00%, IF C2=3 and so on all the way until IF C5=10. Thanks. ~~Rob
August 27th, 2008 10:03 PM
by David Biddulph Go to last post
6 68
Average by Vercingetorix.XIII
I need some help creating a formula to calculate who was at #1 status the most throughout the month. Some people were not on list everyday and some were, so...
August 27th, 2008 09:52 PM
by Bob Bridges[_3_] Go to last post
9 93
VLOOKUP and "-" characters by Exxet
Hi, I'm using VLOOKUP to to convert a set of cells with values based on a lookup table. Some of these defined values are "C--" and "C-" as per the example...
August 27th, 2008 09:45 PM
by Exxet Go to last post
4 60
what formula can i use to find a specific value? by dan dungan
Hi, I have a table like the following A B C D E F G H 1 ON 18 19 21 30 32 40 41 2 01 08 3 03 08 4 04 08 08 08 08 5 05
August 27th, 2008 09:29 PM
by dan dungan Go to last post
1 102
SUMIFS including hidden rows by moosie
Hello, I am using the SUMIFS function but I have alot of rows hidden because otherwise it will become a very long list of data and I only need to see the...
August 27th, 2008 09:28 PM
by Bob Phillips[_2_] Go to last post
1 95
Concatenate a VLOOKUP by lehigh46
Hi All, How can I concatenate a VLOOKUP from 3 cells showing city, state & zip into one cell? Thanks in advance
August 27th, 2008 08:58 PM
by lehigh46 Go to last post
2 85
Searching A List by smartin
Given the following in a column: Number 0 1 1 0 0 1 0
August 27th, 2008 08:41 PM
by smartin Go to last post
1 54
Post New Thread


Display Options
Showing threads 21041 to 21060 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:19 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.