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
Add Seconds to Date - Time Field by terminal euphoria
I have an Excel spreadsheet that provides a date/time field in one column and a seconds field in another column. How can I combine the seconds to this...
September 19th, 2008 01:36 PM
by terminal euphoria Go to last post
2 105
vlookup by Alexey[_2_]
Hi is it possible to have an AND statement in a vlookup when comparing data. For example: VLOOKUP($A29,Sheet2'!$D$4:$E$1045,2,0) will look up where the $A29...
September 19th, 2008 01:23 PM
by Alexey[_2_] Go to last post
1 101
Lookup function-text by T.Mad
Hi there I have a query about the lookup function. In one column there are registered the names of some people and in a second column there are registered the...
September 19th, 2008 01:23 PM
by T.Mad Go to last post
2 122
Final Days 2008 East Coast U S Excel User Conference by Damon Longworth
Final days to register online - Save over onsite registration Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference...
September 19th, 2008 01:15 PM
by Damon Longworth Go to last post
0 237
need help with conditional data by Alok
I have two worksheets. Worksheet A has item names and company names. Item names are unique, but not company names. In worksheet B, I want to select a company...
September 19th, 2008 01:00 PM
by Ashish Mathur[_2_] Go to last post
1 193
Need a formula to determine if date falls within a date range then by Corca
Help. Cell A1 = 16/1/08 Cell A2 = 1/1/08 Cell A3 = 28/1/08 Formula needed for Cell A4 I would like a formula for: Cell A4= if A1 =A2 and =A3 them...
September 19th, 2008 09:36 AM
by Ashish Mathur[_2_] Go to last post
2 233
notify of entered criteria by Ken
I have list of criteria “E104, E105, E107, E123, E124, E127, E131, E142, E952, E1510, ALCOHOL” The criteria is listed in "A1" How do I get my spreadsheet...
September 19th, 2008 09:25 AM
by Ken Go to last post
2 122
Vlookup look up the remark by [email protected]
Had been trying to use Vlookup function to look up the comments in the given table below , but it doesn't work well. Appreciate if anyone can enlighten me what...
September 19th, 2008 08:28 AM
by Bob Bridges[_3_] Go to last post
2 167
Find total number of unique model numbers by Brian[_16_]
Howdy All, I have a workbook that contains service data for units. Column A = Model Name (alpha) 87 model names that repeat throughout the column Column B =...
September 19th, 2008 05:51 AM
by T. Valko Go to last post
8 173
Add contents of two cells when a tick box is ticked by Andy
I have a stock control sheet with quantity in stock and quantity ordered. When the order arrives I want to be able to tick a check box, thus adding the...
September 19th, 2008 05:38 AM
by Ashish Mathur[_2_] Go to last post
2 169
Rolling figure to a cell by Brenton
I am trying to calculate a rolling figure to a cell by updating a spread sheet on a weekly basis. I want to input data on a dated row and get the formula to...
September 19th, 2008 05:36 AM
by Brenton Go to last post
2 135
SUMIF with 2 creteria one Name one DAte by Gary
rIn a previous post JMB said: How many sales Brian had in January (2): =SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1)) I have a similar problem and have...
September 19th, 2008 05:25 AM
by Teethless mama Go to last post
1 110
Formula adjust for inserted row above current row by tulip
I am averaging a column of numbers =Average(A1:A33) If I insert a row "above" A1 the formula does not adjust to include the inserted row. Is there a way to...
September 19th, 2008 05:23 AM
by Ashish Mathur[_2_] Go to last post
8 146
Match/Vlookup/Hlookup ? by Daniel Q.
Not sure what formula to use when trying to match two criteria and having them pinpoint a cell depending on teh criteria. I need the formula to go out and...
September 19th, 2008 05:08 AM
by Ashish Mathur[_2_] Go to last post
3 153
Sum and skipping cells by art
Hello all: Is it possible to sum the cells by starting from A1 and add A10 then A20, and so on every tenth cell. How do I write the formula for it?
September 19th, 2008 05:02 AM
by Ashish Mathur[_2_] Go to last post
2 125
Expire count down by Sweetie
Hi guys/Gals Im desperatly trying to work out how to put a countdown on a excel sheet for things that are due to expire. I have a hundred and one uses for...
September 19th, 2008 05:02 AM
by Sweetie Go to last post
5 146
if and sum, 2nd try. by Christy
This is what I have: Col G Col H Col I 15 in v 20 ot v 30 in n This is what I need to do: When...
September 19th, 2008 04:48 AM
by Ashish Mathur[_2_] Go to last post
6 104
Formulas by Matt
i am looking to get an average of a group of cells but I do not want the cell with a 0 in to be included but the cells numbers will change when I reuse the...
September 19th, 2008 04:39 AM
by Ashish Mathur[_2_] Go to last post
4 116
greater then less then by andrew
I am trying to do this. I have 2 cells that contain curency values in each, I want a 3rd cell to tell me which one is greater, I need the 3rd cell to show...
September 19th, 2008 04:38 AM
by T. Valko Go to last post
2 107
Forms-Scroll Bar function in Excel 2007 by DB
I recently switched from 2003 to 2007 and cannot seem to find the function to create scroll bars, check boxes, etc. in Excel 2007. I'm sure the feature must...
September 19th, 2008 04:36 AM
by T. Valko Go to last post
1 138
Post New Thread


Display Options
Showing threads 20181 to 20200 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 06:42 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.