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 Reverse Sort Order Last Post Replies Views
Having trouble with vlookup and match by ADiscrete1
If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet I have those numbers embedded with many others as well as additional information...
November 17th, 2005 03:09 AM
by ADiscrete1 Go to last post
8 113
Specifiying the worksheet name in a cell by adiss
I have several different xls with multiple worksheets in each I have written the report that generates the data but I must manually go into each field and...
April 28th, 2006 12:26 PM
by adiss Go to last post
2 78
SUMPRODUCT by Aditya
Hello. I am trying to calculate minutes from a conference database record within a given period. This is what my sheet looks like. Date Time Country...
September 24th, 2004 04:15 AM
by Biff Go to last post
1 82
keyboard shortcut by Aditya
We know the keyboard shortcut for selecting the total column (CTRL+spacebar). once when i was using this, some how it got removed. Can any one of you helpme...
February 21st, 2005 02:34 PM
by R.VENKATARAMAN Go to last post
1 274
Applying formula on formula by Aditya Kumar
I have used IF formula on 10 grid values to get desried values.Further, on these values i want to apply average formula. Whenever i apply the average onto...
October 31st, 2007 04:26 PM
by ilia Go to last post
6 56
adjust sales tax on my Excel Invoices by Adjusting Tax rate
How do I adjust the sales tax percent? I downloaded a template from Office' Website
July 3rd, 2006 04:24 AM
by CaptainQuattro Go to last post
1 111
SUM OF GROUPS by ADK
I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of...
October 28th, 2005 08:04 PM
by ADK Go to last post
5 93
back date calculation? by [email protected]
I would like to find out what each entry date would be if I had a global start date, each entry had a day count and the result would be a backwards calendar...
January 15th, 2006 06:10 PM
by Paul B Go to last post
1 86
IF, between two numbers by ADK[_2_]
How would I use and if statement based on between two numbers?? Example--- For cell A6: IF A5 is between .99 and 5, 1, 0 A5 = .25 ....so A6 is 0 A5 = 1...
July 19th, 2007 01:32 PM
by Bob Phillips Go to last post
2 49
Closest value lookup? by ADK[_2_]
I have a sheet with specific numbers. On another sheet, the user would input a value. I like excel to find that number or the closest number then return the...
(Multi-page thread 1 2)
June 21st, 2007 09:13 PM
by T. Valko Go to last post
12 179
formula range by ADK[_2_]
is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula...
June 15th, 2007 06:46 PM
by ADK[_2_] Go to last post
5 58
which function can get the desired result? by ADK[_2_]
Is there a function for this: example: cell B1 = 115 cell B2 = 120 cell B3 = 200 B1 thru B3 are variables that will change based on user input. I want cell...
May 9th, 2007 03:10 PM
by David Biddulph Go to last post
3 76
random by ADK[_2_]
I have cells A1 through A10 with player names (John, Joan, Tom, etc.) I would like to generate 5 teams by random. How can I do this with excel? ....without...
May 1st, 2007 06:26 PM
by Bernie Deitrick Go to last post
1 59
create a master list from other sheets by ADK[_2_]
I have 12 sheets that consist of bill of materials. I would like to have a master sheet which combines all the sheets into one bill of material. Problem:...
April 17th, 2007 08:05 PM
by ADK[_2_] Go to last post
0 134
if between two dates by ADK[_2_]
B1= 1/1/2007 B2 = 10/3/2007 A3 = 1/12/2007 B3 = X (X being the letter X ...so "X" in formula) B3 exquals X if A3 is between or on B1 & B3 otherwise cell...
April 12th, 2007 09:38 PM
by AdmiralAJ Go to last post
5 84
end date by ADK[_2_]
If I input a start date in a cell, and give the number of days required to complete the task in another cell.......How can I compute the end date omitting...
April 11th, 2007 07:39 PM
by T. Valko Go to last post
3 76
Need to count based on different criteria in two columns by Adlin
Hello. I am trying to count the number of Items in Col A that have and a value of greater than 0 in Col E. For example: Col A ...
May 25th, 2007 08:05 PM
by Adlin Go to last post
3 61
Formula with natural English language by adman4
I've been having the hardest time figuring this out. Maybe someone here could help? A column in my table has a series of city names. I have another table on...
January 22nd, 2009 04:16 AM
by adman4 Go to last post
3 64
Earn up to 1000 $ per month only for reading your Mails!!!!!!!! by ADMIN
HTML HEAD META NAME="GENERATOR" Content="Microsoft DHTML Editing Control" TITLE/TITLE /HEAD BODY P /P /BODY /HTML
May 23rd, 2006 02:46 PM
by ADMIN Go to last post
0 63
Excel changes my text by admin
Help! When I type "HSA" into a cell, which is formatted as text, Excel changes it to "HAS" and I can't figure out how to change this. Thanks! -- Admin
April 14th, 2005 09:57 PM
by Nick Hodge Go to last post
3 95
Post New Thread


Display Options
Showing threads 1321 to 1340 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:13 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.