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
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 413
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 341
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 516
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,210
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 537
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 493
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 669
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 558
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 419
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 533
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 689
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 447
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 546
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 701
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 461
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 703
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 525
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 489
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 597
Large list of numbers to concatenate by MaggieB.
I have a list of 600+ zip codes that are curently in individual cells. I need to turn them into one list separated by commas. Is this possible? The best...
June 3rd, 2010 11:57 PM
by Gord Dibben Go to last post
3 494
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 07:51 AM.

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