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
Refer to other tabs in formula by Gary T
I have a series of tabs within a workbook labelled "April 2008", "May 2008", "June 2008", and so on. In cell A1 of each tab, I have entered the start date of...
September 23rd, 2008 07:21 PM
by Glenn[_6_] Go to last post
2 570
Sampling by snickerbart
I am trying to find a formula in EXCEL that I can use to extract a specific line of information form one worksheet to another. Here's my problem: I am give...
September 23rd, 2008 07:11 PM
by Glenn[_6_] Go to last post
1 241
How do I make the default insert comment bigger? by dab
I cannot see how to make the default insert comment bigger and I have to get really close to the screen to read them. Is there any way I can make them bigger...
September 23rd, 2008 07:08 PM
by Gord Dibben Go to last post
2 261
Editing spreadsheets in emails by John at Work
Hi I receive requisition spreadsheets that I want to populate and reply to the sender or senders. Currently I need to open the sheet, enter info, save and...
September 23rd, 2008 07:01 PM
by John at Work[_2_] Go to last post
2 193
Can I use an OR function with SEARCH in conditional formatting? by RAYCV
I am creating a conditional format using the thfe following formula =SEARCH("rejected",$F4) I also need the cell to be highlighted if F4 contains the word...
September 23rd, 2008 06:46 PM
by T. Valko Go to last post
3 225
Excel formula by Alex
Hi I have this formula, please can you help me what does it menas "=TABLE(P7,P8)"
September 23rd, 2008 06:29 PM
by Spiky Go to last post
3 129
VLOOKUP and SUM by Rebecca
I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine...
September 23rd, 2008 06:18 PM
by T. Valko Go to last post
5 146
Rank Function: Refer to more than one range by Gary T
Hi I would like to enter a RANK functino that refers to more than one range when performing the rank calculation - is this possible? e.g. I have numbers in...
September 23rd, 2008 06:10 PM
by T. Valko Go to last post
4 135
Macro deleted but still asking to enable? by Jane Doe[_3_]
I deleted a Macro that I decided not to use. Followed typical steps and deleted from list of Macros. I still get the question when I open the file to...
September 23rd, 2008 05:58 PM
by T. Valko Go to last post
5 152
Insert Function in an email button by Barb
I have an excel document that has an "email button". The insert function has it putting the current page onto the body of the email. I would like to have it...
September 23rd, 2008 05:42 PM
by Spiky Go to last post
3 211
I need to scan a column by Vercingetorix.XIII[_2_]
I need to scan a column on a second page and look for a name, then scan another column on the second page and check for how many months it has been (less...
September 23rd, 2008 05:23 PM
by T. Valko Go to last post
6 190
If between 2 numbers, multiply by Gee...
I know this will be simple, but I just can't get my head around it. I need a formula that will calculate a percentage: If A1 500 but 1000 then A1*.02 See...
September 23rd, 2008 05:18 PM
by Gee... Go to last post
5 199
I want multiple formulas to always extract from same cell(s) by JohnW
I have constructed a table of information for multiple workplaces. Each workplace has data common to them all, e.g.. Project1 ...
September 23rd, 2008 04:45 PM
by ~L Go to last post
1 154
Using an Excel sheet for batch delete by Colin Hayes
HI All I have an Excel worksheet with a list of file names in column A. I'd like to use this list to look into a named directory (perhaps built in to the...
(Multi-page thread 1 2)
September 23rd, 2008 04:38 PM
by pgarcia Go to last post
18 420
Importing, but only certain information by Sweetie
Hi Peeps, I have what i would call a master list, has ID numbers and names. How do i use a blank sheet, type in the ID number for example, and excel to...
September 23rd, 2008 04:35 PM
by Spiky Go to last post
3 130
Sumif for multiple conditions by DMcCormack
Do anyone know if it is possible to do a sumif function for more than one condition? What I want to do is sum the items in column C that meet the criteria of...
September 23rd, 2008 04:30 PM
by ~L Go to last post
3 115
Array function that returns values within several intervals by Hjuler
Hi, I need to subtract numbers in a column (A2:A4) from the numbers in a row (B2:D2) in all possible combination, Find and return all values that match...
September 23rd, 2008 04:11 PM
by Hjuler Go to last post
6 155
I cannot open xls document sent by e-mail by Rose B
I am using Windows Vista Home Premium, Microsoft Works Suite 2006 and Tren Micro Internet Security Pro 2009 - I cannot open xls documents sent in an e-mail...
September 23rd, 2008 04:08 PM
by Spiky Go to last post
2 164
Mathmatical functions in Excel by MAC JUNIOR
How do you find the Antilogarithm of a number
September 23rd, 2008 03:58 PM
by omnitechsupport Go to last post
4 144
filter for round numbers by Julieeeee
Is there a way to filter or sort for only those values that have no cents? I have a column of discount amounts, and I want to see only the flat rate...
September 23rd, 2008 03:45 PM
by Pete_UK Go to last post
2 138
Post New Thread


Display Options
Showing threads 20021 to 20040 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 11:11 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.