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
Count number of instances by Curtis[_6_]
Need a formaula to look at an entire column and count the number of different times (say date of product) Thanks -- ce
June 4th, 2010 04:15 PM
by Dave Peterson Go to last post
4 843
calculate equated monthly installment ? by D V Bidri
How do we calculate equated monthly installment value for given int rate and period for a capital available and reverse of the same. Thanks
June 4th, 2010 04:04 PM
by trip_to_tokyo[_3_] Go to last post
2 853
Troubleshoot by rwtrader
Can someone help me with the following statement: =AVERAGEIFS(BeezidTable,BeezidTable,"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))") It returns DIV/0, but...
June 4th, 2010 03:49 PM
by Paul Telford Go to last post
2 710
Import old dos sequencial data by Rich Stone
I have an old database that stored it's data in a sequencial format with fixed lengths for each field. As Windows 7 64-bit no longer allows the running of...
June 4th, 2010 03:32 PM
by Jackpot Go to last post
3 913
How to make a conditional Median function? by myra_deV
for my thesis i need to create median industry multipliers. i have a list of companies with their industry codes and multiples, but now i need to create a list...
(Multi-page thread 1 2)
June 4th, 2010 03:28 PM
by rwtrader Go to last post
16 1,876
extract data from pivottable which meets certain conditions by befuzzaled2010
What is the correct formula for extracting data from a pivot table report which meets a certain conditional set of criteria?
June 4th, 2010 02:54 PM
by Gary Brown[_6_] Go to last post
1 902
AMVERAGIF Condition by rwtrader
I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this?
June 4th, 2010 02:41 PM
by rwtrader Go to last post
6 923
MEDIANIF by rwtrader
Was this function removed from 2007 or do I just need to download an add-in?
June 4th, 2010 02:36 PM
by Bernard Liengme Go to last post
1 1,093
Macro help - add column selection by HeatherJ
I have the following replace info in a macro. Selection.Replace What:="Of", Replacement:= _ " of ", LookAt:=xlPart, SearchOrder:=xlByRows, _ ...
June 4th, 2010 02:35 PM
by Jackpot Go to last post
1 936
Average If by carl
Is it possible to compute an average given a criteria. For example, I have some data like this: 30 Day High30 Day...
June 4th, 2010 02:30 PM
by Bernard Liengme Go to last post
3 820
Can't Edit Worksheet Comments by Paul Calcagno
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...
June 4th, 2010 02:26 PM
by Dave Peterson Go to last post
1 925
How to give a string of data into different columns by Elton Law[_2_]
Super expert, If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11
June 4th, 2010 02:24 PM
by Teethless mama Go to last post
8 1,158
How do I unhide collom a? by Honnesty
I hid collom A and now can't unhide it! Please help?
June 4th, 2010 12:45 PM
by Steve Dunn Go to last post
5 863
lookup function by Keith[_22_]
I have a column listing numbers in worksheet B. I'm looking for a formula to place in worksheet A that will list the bottom number listed in that worksheet...
June 4th, 2010 11:32 AM
by Keith[_22_] Go to last post
4 872
SumIf and vlookup formula help by Nikki
I have 5 categories that I need to sum but it is on another tab. I can't remember how to use the Sumif and vlookup formula together. Product A = 100 Product...
June 4th, 2010 10:31 AM
by Steve Dunn Go to last post
2 1,054
Import external data by nordiyu
Sir, I am using MS excel 2003. I try to get data (a1:u17000) from another file using "Import external data" function. When I refresh data, not all data...
June 4th, 2010 09:49 AM
by FSt1 Go to last post
6 817
Pre-configuring Pivot table "views" by Mahurshi Akilla
I need to create several different pivot tables from the same set of data. However, I need to keep switching between the different tables and it quickly...
June 4th, 2010 06:42 AM
by Roger Govier[_8_] Go to last post
4 1,128
Pivot table in Excel 2007 by Dinesh
Hi, Somehow my Pivot table do not sums up by rows. Boxes are checked for both columns and rows for Grand total under options, Tools and Filter. Dinesh
June 4th, 2010 01:01 AM
by Debra Dalgleish Go to last post
1 1,013
tab names are wrong when printing custom footers (using [&tab] ) by S Hartman
I am printing alot of charts for one spreadsheet that contains many tabs. I would like each page printed to have the name of the tab, so I did the...
June 4th, 2010 12:55 AM
by Nadine Go to last post
1 853
Bond premium amortization using the constant yield method by lmahaffey
Anyone know of a function that calculates the bond premium amortization using the constant yield method? An example of a bond premium that would need...
June 4th, 2010 12:54 AM
by Dev Purkayastha Go to last post
1 1,002
Post New Thread


Display Options
Showing threads 61 to 80 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 05: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.