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
August 26th, 2008 10:24 PM
by Spiky Go to last post
3 88
Need ideas on which formula(s) to use in this situation by ker_01
I have a worksheet with a lot of raw data. In one column I have an identifier, in another I have dates, and in another column I have values. I need to build...
August 26th, 2008 10:18 PM
by Bob Phillips[_2_] Go to last post
3 71
Fill in a formula within a worksheet by Tracy
I have the following formula which I need to fill across the worksheet but the cell reference is from another sheet and the information within the other...
(Multi-page thread 1 2)
August 26th, 2008 10:13 PM
by Pete_UK Go to last post
12 235
Excel 2003 unites csv file row contents in a column A with squares by Dima
Hello! I exported a Windows Address book to a csv file in Windows Vista. Excel 2007 opens the file correctly, but Excel 2003 unites row contents in a column A...
August 26th, 2008 10:04 PM
by Spiky Go to last post
9 114
Count range of data by Count if dates fall in certain range
I am trying to use the with a date and a range of cells with a count range. =IF(f7:f117/31/08,COUNT(b7:b11),"") I am getting a value error. What I am...
August 26th, 2008 09:32 PM
by Spiky Go to last post
2 67
Using less than "" in formula by Bernie R
I'm trying to use a formula in one worksheet that draws data from two other worksheet. I have no problem using the "" in formulas, but when I use the ""...
August 26th, 2008 09:30 PM
by Dave Peterson Go to last post
3 101
returning a text value using a formula by KVSmith59
There is probably an easy solution to this, but I can’t find it. Any help would be appreciated. I have 3 columns. Each column has a heading with numbers...
August 26th, 2008 09:01 PM
by Bob Umlas, Excel MVP Go to last post
1 81
Using less than "" in formula by Bob Umlas, Excel MVP
=if(ust!i9="m9", if(rawdata!r2datevalue("05 may 08"),ust!$b12," ") "Bernie R" wrote: I'm trying to use a formula in one worksheet that draws data from...
August 26th, 2008 08:53 PM
by Bob Umlas, Excel MVP Go to last post
0 95
Import External Data by Date by Rubie
I have a query setup in an Excel spreadsheet that imports external data from SQL. All of the data is imported but, I only want the data for the current date...
August 26th, 2008 08:42 PM
by Rubie Go to last post
2 124
Return top ten amounts by Jane Doe[_3_]
What is the simplest way to return the ten highest amounts listed in a column? I have a column that list total cost, and I would like to list the ten highest...
August 26th, 2008 08:34 PM
by Spiky Go to last post
2 79
Column reference in Vlookup formula by Kevin K[_2_]
There are time when I need to add column to the section of the spreadsheet that I'm referencing in my vlookup formula. When I add a column, the vlookup...
August 26th, 2008 08:16 PM
by Gord Dibben Go to last post
1 87
Indirect by waldorf
i am referencing a worksheet using the indirect function. excel is automatically adding the active worksheet name to the formula which returns #REF. how can i...
August 26th, 2008 08:15 PM
by T. Valko Go to last post
5 85
No Subject by No Name
om: Pete_UK Newsgroups: microsoft.public.excel.worksheet.functions Subject: i want to create an IF formula to bring back one of four...
August 26th, 2008 08:03 PM
by No Name Go to last post
0 101
Not sure what is going to be best by dustinbrearton via OfficeKB.com
I have a spreadsheet where each row represents a shipment. Each shipment has shipment details in columns A:AP. I want cell AQ to contain the earliest date...
August 26th, 2008 07:50 PM
by ShaneDevenshire Go to last post
1 75
single entry across multible sheets in workbook by George
I have a workbook with three sheets. Each sheet contains essentially the same date just sorted by different columns. I would like to edit sheet 1 and have...
August 26th, 2008 07:46 PM
by ShaneDevenshire Go to last post
2 91
Protecting Functions within a cell by Diana
Is there anyway to protect or lock a function in a cell, so that others can't alter the function?
August 26th, 2008 07:41 PM
by Diana Go to last post
2 106
Wouldn't know what to call it! by 1Fish2Fish
I have a "table" that I created. It's just a basic grid with items on the y axis and items on the x axis (ex. types of fruit on the top, number of fruit in...
August 26th, 2008 07:37 PM
by Don Guillett Go to last post
5 80
Selecting data by date differences by saylur
I have a large amount of data which includes account numbers and 'transactions.' Each account has more than one transaction, and each transaction has an...
August 26th, 2008 06:56 PM
by Herbert Seidenberg Go to last post
3 82
i want to create an IF formula to bring back one of four results . by vsors
. . . which would be dependant on the value of the cell. eg. 0-5 = 45% 6-12 = 33% 13-20 = 25% 21 = 20% i want the formula to automatically return the...
August 26th, 2008 06:16 PM
by Gord Dibben Go to last post
4 88
Save Prompts by PMOPS
My spreadsheet has multiple tabs. When I save I want to either add a save prompt which reminds me to go back to the summary tab before saving or when I save...
August 26th, 2008 05:40 PM
by Roger Govier[_3_] Go to last post
1 130
Post New Thread


Display Options
Showing threads 21121 to 21140 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 09:04 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.