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 92
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 91
Hiding zeroes in Office 2002 by
Hi My mate uses Excel 2002. I've talked him through setting up a few formulae, one of which is like this: =IF(A2="",0,VLOOKUP(A2,F:H,2,FALSE)) When A2 is...
May 23rd, 2005 04:24 PM
by Go to last post
3 104
How many in column by
Hi Try something like this: =COUNTIF(A2:A2000,"White") -- Andy. "Ralph Smith" wrote in...
May 24th, 2005 06:11 PM
by Ralph Smith Go to last post
4 117
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 53
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:27 PM
by Gary Brown Go to last post
4 95
Updating data with an ODBC link to ACCESS by
Does anyone know the best approach for this? I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional spreadsheets which have ODBC links to various...
July 6th, 2006 02:09 PM
by Go to last post
1 47
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? by
I'm not certain if this one belongs in the EXCEL or ACCESS Newgroup ... ==================================== I have an Aggregate Transfer Spreadsheet Macro...
July 12th, 2006 10:08 PM
by Go to last post
0 77
Is there a formula for inches to feet and inches? by
I work with lengths, in inches (sometimes 50000 +inches), but need a quick way to convert them into feet and inches. Here is an example: a1 144.625 b1...
August 12th, 2006 12:45 AM
by daddylonglegs Go to last post
2 58
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 96
No Subject by
ssage-ID: Date: Mon, 21 Mar 2005 15:13:14 -0500 From: Debra Dalgleish User-Agent:...
March 21st, 2005 12:00 AM
by Go to last post
0 101
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 116
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 12:54 AM
by Go to last post
3 75
Help with array formula by
Hello friends, I believe that the solution to my problem lies in the writing of an array formula; but since my creativity with writing array formula is very...
January 20th, 2005 04:17 PM
by Go to last post
2 168
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 12:09 PM
by Go to last post
0 260
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 26th, 2005 11:14 PM
by Aladin Akyurek Go to last post
4 70
Fiscal year total from running 12 months by
I maintain data for the previous twelve months in Excel 2002. I want to calculate statistics based on fiscal year data, which is a changing subset of the...
February 9th, 2005 12:11 AM
by Go to last post
2 107
No Subject by
ssage-ID: Date: Fri, 11 Feb 2005 21:00:43 -0500 From: Debra Dalgleish User-Agent:...
February 13th, 2005 10:43 PM
by nbrcrunch Go to last post
1 71
Array formula that alphabetizes a list by
Is there an array formula I could use that would alphebatize a list?
March 17th, 2005 10:40 PM
by Biff Go to last post
2 160
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 39
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 08:24 PM.


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