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
INDEX Function by Jerzy
Hello to all, I need to find an alternative to the "INDIRECT(A1)" function. Indirect works well enough on my PC, but that function is not supported in the...
October 5th, 2003 10:18 AM
by Charles Williams Go to last post
1 336
Display formulae by Sheryl
I have an assignment where I've had to create a spreadsheet using certain formulae. The next requirement is to copy that worksheet to a new one, and show all...
October 5th, 2003 12:45 PM
by Ken Wright Go to last post
1 330
Advanced Filter in Shared Workgroup? by Three20Three
Is there anyway to get an advanced filter to work in a shared workbook? If not, is there an alternative to advanced filtering that I could...
October 5th, 2003 02:54 PM
by Debra Dalgleish Go to last post
1 722
Countif Advise by Aladin Akyurek
In A1 on Sheet2 enter: =COUNTIF(Sheet1!A5:INDEX(Sheet1!A:A,MATCH(REPT("z",255),Sheet1!A:A)),"=Dave" ) "Michael168" ...
October 5th, 2003 03:07 PM
by Michael168 Go to last post
2 320
Converting arabic (US) numbers to text by Greg
I have seen a couple of previous posts on this topic but they have either a) not worked, or b) not made any sense. I want to be able to type a number, for...
October 5th, 2003 04:39 PM
by Harald Staff Go to last post
1 231
How to count the gap by Don Guillett
also posted elsewhere "Michael168" wrote in message ... Let say in...
October 5th, 2003 07:34 PM
by Alan Beban Go to last post
1 94
Find second occurence by Steved
Hello from Steved =INDEX=INDEX($D2:$D$217,MATCH($F$6,$B$2:$B$217,0),...
October 5th, 2003 09:16 PM
by Steved Go to last post
5 188
Countif...? by Craig
I am trying to count (in cells C3,C4 and C5 on Sheet2) 21 cells on sheet1(H4,G12,H17,G24 etc.) I have entered a formula in the cells to return the values...
October 5th, 2003 11:45 PM
by Anders S Go to last post
1 103
sum1 plz help me understand vlookup function by flick
i'm doing an assignment for my accountancy course and i need to use the v look up function in order to determine calculations of wages.... for example.... i've...
October 6th, 2003 03:29 AM
by Harlan Grove Go to last post
2 360
"Group" and sorting data by Joel Bergsman
One of my Excel spread sheets somehow (?) acquired the word "group" in its name, and many menu choices disappeared -- including the sort function. How do I...
October 6th, 2003 07:09 AM
by acw Go to last post
2 366
Autosum by barker28
Hi When I change an amount in a autosum range the total will not update why is this happening. thanks for any advice. Jill
October 6th, 2003 07:13 AM
by Andy Brown Go to last post
1 110
regression analysis specifically forecast by Michael
I have tried to get the forecast function to work properly. I have exhausted everything I could read from microsoft website including the technical support...
October 6th, 2003 07:53 AM
by Mike Middleton Go to last post
2 92
visible entire formula by Mark
Hi, I wonder, if is possible follow automatic action on cells: Multiplicate per index=1,5 each cell in range. Result operation - in each cells visible...
October 6th, 2003 09:06 AM
by Mark Go to last post
6 171
Time calculations in Excel 2002 by Andre
I need to display the result of a time calculation as a decimal e.g. 08:30 - 08:00 = 00:30 I want the 00:30 to be displayed at 0.5 (half an hour). Is this...
October 6th, 2003 10:14 AM
by Dave Ramage Go to last post
1 130
worksheet sum function by Dawna
Why does a column of numbers not total what it should? When adding the column with my adding machine, I get the total. When adding by the sum function, I'm...
October 6th, 2003 12:47 PM
by Jerry W. Lewis Go to last post
2 131
figuring bowling handicaps by Mlou
a friend is the secretary for the bowling league and wants to use Excel to figure the handicaps for the bowlers involved. Any suggestions on the formula...
October 6th, 2003 01:13 PM
by Bernie Deitrick Go to last post
1 173
Sharing worksheets with custom functions by jimlyke
What is the easiest way to share spreadsheets with custom functions? If I only send the sheet, they won't have the custom functions. If I send the sheet and...
October 6th, 2003 01:15 PM
by Bernie Deitrick Go to last post
1 259
sorting and combining data by
I've got two different spread sheets with large amount of data. These two charts however share one grout of data (in this case street address) The first set...
October 6th, 2003 01:22 PM
by Bernie Deitrick Go to last post
1 220
type date and year has to come. by shital
i have a field like:- Name of Name of Date Year Qty Rate Amt. Party Co. what i want is when i type date i want year has to...
October 6th, 2003 01:49 PM
by Peo Sjoblom Go to last post
6 427
Date formatting - Enter #'s to = formatted date by Lisa
When entering dates, how do you format the column so that you can enter just the numbers of the date (i.e. 100603) and have it appear as "10/06/03" with the...
October 6th, 2003 02:15 PM
by Peo Sjoblom Go to last post
1 276
Post New Thread


Display Options
Showing threads 941 to 960 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:00 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.