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
calculations by
I have a file like Dept PayType Amount 2312 OT 500 reg 1000 vac 10 ss 5 2566 ot 5522 reg 42 vac ...
October 4th, 2004 03:44 PM
by Frank Kabel Go to last post
4 202
Bring Back Qualified Sum from another WB by
I'm in WB Main.xls with 4100 as text in cell D6; I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls,...
April 8th, 2005 01:01 AM
by Don Guillett Go to last post
4 416
how to change a number to name by
I have a bowling league schedule that looks like this: Lanes 1 2 3 4 5 6 7 8 9 Teams1-2 3-4 5-6 7-8 9-10 11-12 13-14...
(Multi-page thread 1 2)
April 19th, 2005 12:21 PM
by wally667 Go to last post
10 153
Changing Numbers by
Hi In a blank cell type 1.15. Copy it (Ctrl+C). Select the range you wish to change and go to Edit|Paste|Paste Special|Multiply. Make sure you take a copy...
May 12th, 2005 04:32 PM
by Jason Morin Go to last post
4 114
Fibonacci function/command in excel?...tia sal by
Fibonacci function/command in excel?...tia sal Greetings all, Is thier a Fibonacci function or command built into excel? TIA
June 7th, 2005 06:07 PM
by JE McGimpsey Go to last post
1 89
Consolidating sheets by
Hi We are buying a company and I need to create a stock spreadsheet from their workbook. I would like a single sheet containing the information from about 25...
July 7th, 2005 08:57 PM
by Go to last post
3 332
Problems saving a worksheet with links to a New Location by
Does anyone know how I can resolve this issue ... I have a directory which contains 129 worksheets which have links to external data (in a Master Spreadsheet)...
July 7th, 2006 05:09 PM
by Dave Peterson Go to last post
1 88
Depreciation Formula by
I don't expect to get any bites on this one, but, "Hey, it's Friday -- it could happen!" Just got this one dropped on my lap -- we have a spreadsheet with...
July 9th, 2006 11:53 PM
by Fred Smith Go to last post
1 97
Running Excel 2000 VBA Application on Excel 2003 by
I have a VBA application written in Excel 2000. Running the appl on Excel 2003 generated errors, and the appl would not run on the Excel 2003 PC. (I can't...
August 8th, 2006 06:04 PM
by Go to last post
0 77
How do you get Info to show on Every Page when Printing by
I am creatng an Excel document. I have created the first row #1 with the info that will follow below in each cell. As I get to the additional pages I want to...
March 24th, 2005 09:31 PM
by Gary Brown Go to last post
2 286
No Subject by
ssage-ID: Date: Mon, 21 Mar 2005 15:13:14 -0500 From: Debra Dalgleish User-Agent:...
March 21st, 2005 01:00 AM
by Go to last post
0 135
Need help with formula by
Hi! I need to create a formula that will count unique (duplicating/repeating)values. I have numeric data in one column and text data in another.I want to...
October 5th, 2004 06:20 PM
by Frank Kabel Go to last post
2 158
Filling drop down box by
hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I...
November 26th, 2004 01:54 AM
by Go to last post
3 119
how to use lookup a value by date for criteria in Excel sheet by
Thank you for your help, it seem function one of part. I also prefer when I change sheet2 "A2" value to 3.2.2001, the sheet2 "C3" value will be changed to...
January 11th, 2005 05:22 AM
by Max Go to last post
2 320
vlookup data hidden within worksheet by
Hi, Can anyone explain why it is that a vlookup table automatically 'hides' itself within a worksheet that utilizes the vlookup function but the vlookup table...
January 26th, 2005 01:09 PM
by Go to last post
0 563
Formula returning #N/A by
In Sheet1 I have the following formula in B149: =IF(VLOOKUP(A149,MyClinics,3,FALSE),"Yes","No") MyClinics is a named range on my sheet - Reference List In...
January 27th, 2005 12:14 AM
by Aladin Akyurek Go to last post
4 126
Conditional formating by
Can I use conditional formatting so as to look at Column A A1 a2 A2 Turns EA 1.00 red CS 100 Blue BX 50 ...
January 31st, 2005 10:35 AM
by Bob Phillips Go to last post
1 298
No Subject by
ssage-ID: Date: Fri, 11 Feb 2005 21:00:43 -0500 From: Debra Dalgleish User-Agent:...
February 13th, 2005 11:43 PM
by nbrcrunch Go to last post
1 97
lookup tables in cells by
Hi all. I was wondering how to error trap inported data that uses one column as a lookup. i.e., that column has imported part numbers and the column next to...
February 28th, 2005 10:47 AM
by Aladin Akyurek Go to last post
5 289
Hi and function help please by
My worksheet looks likes this: A B 1 Name Fruit 2 Sam Apple 3 Sam Apple 4 Sam Apple 5 Sam Orange 6 Jane Orange 7 Jane ...
August 17th, 2006 05:57 AM
by Biff Go to last post
4 74
Post New Thread


Display Options
Showing threads 21 to 40 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 10:34 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.