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
how do I lock column and row names on spreadsheet by Cheryl D
I need to lock my column and row names so that as my spreadsheet gets larger I can still see the titles so I can put the information in the right places
March 23rd, 2005 05:01 PM
by AnneKragh Go to last post
2 108
Help needed with IF function by Ed
Hi All, I am trying to come up with a spread sheet that would convert amount in certain foreign currency to local currency equivalent and show final value in...
March 23rd, 2005 05:26 PM
by dave Go to last post
1 96
Can I set up the formula to update automatically? by pugsly8422
I have a sheet with 12 columns, 1 for each month. I am updating it monthly and I want it to take the average of the months I've used as I update it. The...
March 23rd, 2005 05:43 PM
by Duke Carey Go to last post
1 136
using treater than and replacing numbers by mja
I have a colum of numbers. I would like to find all of the numbers that are greater than $36,000.00 and replace that numberwith $36,000.00.
March 23rd, 2005 06:59 PM
by bj Go to last post
1 68
Excel only calculates the confidence interval for a population . by manpahayes
Excel only calculates the confidence interval for a population mean through the =CONFIDENCE() function. I want the flexibility to calculate the confidence...
March 23rd, 2005 07:07 PM
by manpahayes Go to last post
0 98
greater than replace numbers by mja
I have a column of numbers. I need to replace any amounts over $36,000.00 with the amount of $36,000.00.
March 23rd, 2005 07:41 PM
by Arvi Laanemets Go to last post
1 90
Time Card by Dan B
Hi, I need help with a formula for a simple time card that does NOT round....so it will show the exact hours and minutes between a start and stop time,...
March 23rd, 2005 09:25 PM
by Dan B Go to last post
2 115
Please Help...How can I do this? Select a cell by zoombr
How can I do this? Select a cell A(1+any value) ... for example: If any value = 2, the select cell will be A3.
March 23rd, 2005 09:34 PM
by Ron de Bruin Go to last post
1 90
Cell Frequency by james
Is there a way to count the frequency of cell contents? Example: A B 1Smith Joe 2Smith Mary 3Jones Fred 4Smith Joe 5Jones Fred
March 23rd, 2005 09:49 PM
by N Harkawat Go to last post
1 58
time card excel sheet by Nancy Comello
I currently use excel to track over 70 employees but I need either a formula for the following scenrio. In 7:45am out 12:00am in 1:25pm out 6:00pm then have...
March 23rd, 2005 10:09 PM
by Dan B Go to last post
1 195
CAGR by Mike
I am trying to calculate CAGR by using the suggested fromula XIRR but contnue to get #NAME? as an answer and not the xx%. Is this formula correct?
March 23rd, 2005 10:14 PM
by Myrna Larson Go to last post
4 145
Referencing a worksheet name by Greg114
Hello, I have a workbook with 10-15 worksheets with different names. I am trying to set up a "Summary" worksheet that will have each worksheets name in column...
March 23rd, 2005 11:23 PM
by Harlan Grove Go to last post
3 87
IRR # NUM by Tracy
Hi all I have a formula that works if I change some the final value in the array, please tell me if this number is a limitation in Excel or I am...
March 23rd, 2005 11:31 PM
by Tracy Go to last post
2 74
Rounding criteria within a nested vlookup and hlookup by Jay Z
I am working to track commodities markets. Basically the situation is this: - I enter market pricing information for the two commodity markets in 4 decimal...
March 23rd, 2005 11:34 PM
by Bob Phillips Go to last post
1 204
SORT MIXED DATA by jem
I am trying to sort a spreadsheet which has part numbers as the main description (ie: 500111, 500123, 500111A, 500111B, 500123A ...) I want the sort option to...
March 23rd, 2005 11:41 PM
by d Go to last post
3 85
Most repeated number by nuno
Hi all, I have a table with several rows and columns with several numbers in it. I was looking for a formula which could tell me what was the most...
March 23rd, 2005 11:47 PM
by nuno Go to last post
4 94
Converting EST to PST by neilalan
I would like to convert Eastern Standard Time to Pacific Standard time. In other words, add 3 hours to a time formatted as hh:mm. I haven't had any luck even...
March 23rd, 2005 11:49 PM
by neilalan Go to last post
3 88
Linking workbooks by Debbie
I have many coordinators who fill out a long template with stat numbers. (THey continue to update this template all year long and it contains each month stats...
March 24th, 2005 12:26 AM
by Ron de Bruin Go to last post
1 83
March 24th, 2005 12:26 AM
by Gord Dibben Go to last post
1 243
INDIRECT, OFFSET et. al. by Wazooli
How do I get the following formula: =IF(ROW()=VLOOKUP($A2,$AY$1:$BC$49,3,FALSE),MEDIAN(INDIRECT(VLOOKUP($A2,$AY$1:$BC$49,4,FALSE) & ":" &...
March 24th, 2005 01:23 AM
by Wazooli Go to last post
2 173
Post New Thread


Display Options
Showing threads 12001 to 12020 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:17 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.