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
Function NOW by PeterW
I would like to have the function “NOW” on more then one place in a worksheet and be able to choose when each cell is calculated
June 15th, 2009 02:54 PM
by PeterW Go to last post
4 126
Sorting in Pivot Table by Volkan Cetin
How can i sort data in pivot table when i selected more than one item in raw section.?
June 15th, 2009 02:14 PM
by Volkan Cetin[_2_] Go to last post
1 179
Function for tax? by TB in DC
Let's say I get a hotel for two nights at the same hotel. One night costs $50 and the second night $55. The total bill is $105. The tax is 12.75. Is there a...
June 15th, 2009 02:04 PM
by TB in DC Go to last post
2 140
Help me! by Razzak
Please help me. I would like to separate one word from a cell. Example : Cell A2 = The Quick Brown Fox Question-1: How to separate "Fox" from Cell...
June 15th, 2009 01:25 PM
by Jacob Skaria Go to last post
3 134
Finding a Date 90 days previous to present date by Vinod
Pls help me in executing a date 90 days before a present date. eg:Format of the file Present Date days before previous...
June 15th, 2009 01:18 PM
by Jacob Skaria Go to last post
2 138
excel formulas by moumin
what is the meaning "the formulas in the cell idiffers from the formula in this area of the spreadsheet"?
June 15th, 2009 12:18 PM
by Jock Go to last post
3 156
Tab naming from a Reference cell by Finance Guru
Hi All, Using Excel 2007 Can I name a worksheet tab from a cell contained within the worksheet. I want to name a worksheet from the date contained in say A1...
(Multi-page thread 1 2)
June 15th, 2009 12:13 PM
by David Biddulph Go to last post
14 334
Using formula to find out a Date 90 prior to a particular date by Vinod
I am trying to use a formula for finding out a date 90 days before a particular date. I used the formula =DATE(2009,9,25-I80) for finding a date that is...
June 15th, 2009 12:09 PM
by David Biddulph Go to last post
2 103
Reference to next non-blank cell by Hilvert Scheper
Hi there Dear specialists, Can I Please have some help with this; I want a Formula that finds and returns the Text-string from the next Non-Blank Cell in the...
June 15th, 2009 11:59 AM
by Hilvert Scheper Go to last post
5 134
Formula Help Needed by puting_uwak
Help please! I have this formula in cell...
(Multi-page thread 1 2)
June 15th, 2009 09:35 AM
by Harlan Grove[_2_] Go to last post
11 268
Data in columns. Which formula will identify last completed colu. by Piet[_2_]
If I have monthly data, from left to right in columns, and I need to extraxt the LATEST months data to a particular cell (I.e. current you only have May 2009...
June 15th, 2009 09:35 AM
by fake_be Go to last post
2 170
Match multiple values by willemeulen[_41_]
I need to match 3 values as follows: B5 match with sheet1!A3:A194 C5 match with sheet1!B3:B194 D5 match with sheet1!C3:C194 Return value from column...
(Multi-page thread 1 2)
June 15th, 2009 08:48 AM
by willemeulen[_46_] Go to last post
15 226
Text file import by Boris
Hi, I have an external data query and am trying to create a formula that returns the name of the file from which the query data is taken. This is of course...
June 15th, 2009 08:41 AM
by Boris Go to last post
0 115
Time Situation by Jafferi[_2_]
Cell A1 ~ 8:00 Cell A2 ~ 17:00 Cell A3 ~ ABS(A2-A1)=9:00 XXX How can I formulate that Cell A3 is equal to 8:00 after minusing lunch of 1 hour. I keep on...
June 15th, 2009 08:12 AM
by Per Jessen Go to last post
1 124
SUMIFS by MurrayBarn
A B C D 1 01/11/2008 Motor -10,039.24 -1,232.89 2 01/11/2008 Non-Motor -12,414.70 -1,524.61...
June 15th, 2009 08:02 AM
by MurrayBarn Go to last post
4 183
Protect selected settings in 'options' by John
In a particular workbook I have selected certain settings (tools, options, view), namely not showing the sheet tabs, horizontal scroll bar, formula bar. For...
June 15th, 2009 07:48 AM
by Harlan Grove[_2_] Go to last post
4 128
Extracting information to automatically find previous value. by Rocko
I have the following information $442,400 $+16,900 ($+1,200) contained in one cell & would like to be able to subtract the 2nd figure $+16,900, from the...
June 15th, 2009 04:26 AM
by T. Valko Go to last post
3 145
HELP with conditional formatting and a max time by YS1107
I have a spreadsheet that I am trying to get 8 cells to conditional format based on the "highest" condition of one cell. I got 2 of the three conditions to...
June 15th, 2009 03:47 AM
by YS1107 Go to last post
2 169
"AverageIf" by fozzie888
I want to create a formula along the lines of a "SumIf" but for averages - the target cells are blank and will be filled in later, so until they are the...
June 15th, 2009 03:07 AM
by Shane Devenshire[_3_] Go to last post
4 151
Sum Of Last Two Entries in Rotating Columns by Loadmaster
Hi daddylonglegs came up with the array formula =SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)LARGE((COLUMN(D2:AH13)*100+ROW(D2:AH13))*( D2:AH13""),4),...
June 15th, 2009 02:55 AM
by T. Valko Go to last post
7 176
Post New Thread


Display Options
Showing threads 10121 to 10140 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 08:27 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.