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 discount amt with conditions by cprao
Bill date qty Bill amt Pay.date Amt Bal. Days Disc@ Dis.Amt 18-Jul 18 800 19-Jul 900 -100 1 4 72 20-Jul 18 900 19-Jul 200 ...
August 8th, 2008 04:25 AM
by cprao Go to last post
3 75
Adding a blank row after a new record changes in excel by Skyblue
I need to add a blank row to excel for every time the customer number changes. I have a worksheet that contains customer numbers and invoices. So sometimes I...
August 8th, 2008 04:24 AM
by Gord Dibben Go to last post
1 87
IF function with too many arguments by ahutyra
Thanks in advance for the assistance. I am attempting to create a formula that will calculate a percentage of an amount based on three different percentages....
August 8th, 2008 02:01 AM
by ahutyra Go to last post
3 108
Problem with formula showing in cell by andyK
I am having a problem with a excel document that I exported from a pdf file. When I enter a formula in a cell the cell shows the formula continously. I know...
August 8th, 2008 12:48 AM
by andyK Go to last post
2 100
Referencing Error by MikeChicago
I have a complex spreadsheet with many sheets linked together. Sometimes when I delete rows on one sheet the links do not update. For example, if cell...
August 8th, 2008 12:06 AM
by MikeChicago Go to last post
0 82
what does this mean (PI-DLError1004) by Me
How do I fix it?
August 7th, 2008 11:52 PM
by Gord Dibben Go to last post
1 88
Nested IF confusion! by JayPee
Help needed for this newbie ... I'm using Excel2007 btw. This is so simple but I just don't know why I can't get it to...
August 7th, 2008 11:33 PM
by JayPee Go to last post
3 69
three data validation tables related to each other by Susan
I want to be able to relate the tables to the one previous to it. If 'James' is picked from CLIENTS, I would like only 'James Job 1' and 'James Job 2' to be...
(Multi-page thread 1 2)
August 7th, 2008 11:28 PM
by T. Valko Go to last post
11 153
Reducing File Size by Mike
I use an application called Hyperion to download information into an Excel spreadsheet. The spreadsheet is initially loaded with formulas. At this time the...
August 7th, 2008 11:23 PM
by Pete_UK Go to last post
1 75
Formula Creation by aleflore
I need to create a formula that will provide a result that calculates a date three years out and another date one year out with the result being the greater...
August 7th, 2008 11:13 PM
by Peo Sjoblom[_2_] Go to last post
3 72
Extracting Data from a string of text in a cell by swalker
I need to extract all the characters to the right of another character (^). This (^) character appears in every cell of the column I am working with. It can...
August 7th, 2008 10:52 PM
by Mark[_43_] Go to last post
4 152
match by robzrob
Trying to do a quite simple MATCH. In B53 I've got =MATCH(E50,'SET-UP'!A1:M34,0) E50 is a date, and there is a date exactly matching it in...
August 7th, 2008 10:51 PM
by robzrob Go to last post
6 70
Mixing text and alpha in sumproduct arrays by expect_ed
Just learning how to use Sumproduct to search for values. Looks like a very powerful little function. But I keep getting a #VALUE! error when I have text...
August 7th, 2008 10:39 PM
by T. Valko Go to last post
5 180
Another one! by Connie Martin
Here's another one I've been mucking around with and can't get. In cell C7 I want a formula that will look at the date in A7 and then go to A30:A1000 find...
August 7th, 2008 10:26 PM
by PCLIVE Go to last post
3 67
How do I activate and inactivate worksheets? by daughteroflight
I have 30 worksheets within a workbook, and want to summarize the information found on them on the front worksheet. However, when I open the workbook, I will...
August 7th, 2008 10:10 PM
by desertres Go to last post
3 82
lookup based on 2 criteria by SteveC
Column A Column B Column AU Apples text1 22 Apples text2 3 Apples ...
August 7th, 2008 09:48 PM
by Peo Sjoblom[_2_] Go to last post
1 85
extract numbers from a string by Dave
Hello, We import strings of numbers into a spreadsheet looking like this:- 12Rev999,nextrev456 124Rev8888,nextrev1234 In practice the numbers can be any...
August 7th, 2008 09:43 PM
by Otto Moehrbach[_2_] Go to last post
3 78
SUM PRODUCT FUNCTION by Sue NY
I think I need to use the SUMPRODUCT function but need help w/ the formula. Using the following data: Investor Name Payment Due Date ...
August 7th, 2008 09:18 PM
by Reitanos Go to last post
5 88
Which function? by Connie Martin
Which function and what formula would I use to add the number of the same date in the column. If the date July 22 appears in a column 10 times, what formula...
August 7th, 2008 09:09 PM
by Mike H Go to last post
3 68
link to a cell in an external spreedsheet by Terry
trying to reference a cell in an external spreadsheet. Can anyone help with the syntax? Terry
August 7th, 2008 09:07 PM
by Pierre Go to last post
3 92
Post New Thread


Display Options
Showing threads 21921 to 21940 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:57 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.