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
placing people into age groups based on their DOB by JSAUS
I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to...
March 17th, 2010 03:42 PM
by JSAUS Go to last post
3 185
i can't get this formula to work by kyle
i'm trying to write a formula where if the cell below it minus the active cell is -21 x -23 then write one, else leave it blank. so here's what i got so...
March 17th, 2010 03:28 PM
by kyle Go to last post
3 174
The Tueday prior to a holiday... by Steve
If I have holidays identified with an H in the A column, I need to find the prior Tues, from the Sat prior to the holiday. Basically I need to find the Sat...
(Multi-page thread 1 2)
March 17th, 2010 02:59 PM
by Steve Go to last post
10 287
implementing formulas in excel by Ian
How formulas can be implemented in excel by connecting to it using odbc in c#. Help with some sample code will be greatly appreciated?
March 17th, 2010 01:41 PM
by Ian Go to last post
0 165
How to replace formula with its result by jclown
Hello Everyone, I am using a function to calculate stock levels. For example =2*BR5. But what I want is the cell to display the answer once it has been...
March 17th, 2010 10:59 AM
by jclown Go to last post
2 166
actual row number by climate
I have 63 file. My data set on to column X, and G2 is row number related to column X. I need to macro or formula, when run it on any file, copy of column X...
March 17th, 2010 08:59 AM
by climate Go to last post
3 193
How can I test the text content of a cell by catefaulkes
I wish to create a logical test - an IF statement that tests whether a cell contains H, M or L, and output the result as a number. I cannot get the IF...
March 17th, 2010 06:50 AM
by macropod[_2_] Go to last post
4 175
Importing cells frmom a calendar workbook by AZSteve
"Time-off Calendar" is Excel workbook with 12 worksheets, Jan, Feb, Mar, etc. Each is set up like a calendar with 7 columns (days of week) across and...
March 17th, 2010 05:27 AM
by AZSteve Go to last post
4 272
Highlight date nearest to TODAY() by Colin Hayes
Hi I have dates in a column in this format : 16/01/2010 16/02/2010 16/03/2010 16/04/2010 16/05/2010 16/06/2010
March 17th, 2010 04:51 AM
by Dennis Tucker Go to last post
5 237
If and LOOKUP - results in multiple columns by Joodle
I want to lookup a value in a table, then return a value to a different column based on the result. For example: Sheet 1 has: col A ------ 1
March 17th, 2010 03:26 AM
by Teethless mama Go to last post
6 182
Main Form - copy exact data from multiple worksheets with live lin by uncreative
Hello, I've been searching through the forums, but haven't found anything yet. Does anyone know of a way to copy data from multiple worksheets (i.e. 30) to...
March 17th, 2010 02:43 AM
by IdiotZ42 Go to last post
1 194
SUMIF with multiple criteria by GBExcel via OfficeKB.com
Hi, I need help to SUMIF, subject to several criteria being met. Here is the setup: 1. I need a formula for cell BB24. The header (cell BB23 contains the...
March 17th, 2010 02:09 AM
by T. Valko Go to last post
5 142
find smallest positive number among datas by Cerberus
How to find the smallest positive number among datas in Excel?
March 17th, 2010 01:58 AM
by Ashish Mathur[_2_] Go to last post
6 140
Selecting rows with the same criteria by Ruslan
Dear All, I got a list of data like: A B C D 1 1 ABC 55 Wilson 2 AFD 60 Adams 3 1 DGC 76 Korinth 4 AFV 83 ...
March 17th, 2010 01:49 AM
by Ashish Mathur[_2_] Go to last post
5 146
Cash Statement- Accruing balances by cjarrar
we are attempting to create a Cash Statement report for a single account and would like to include a To Date, Month To Date and Fiscal Year totals. Is there...
March 17th, 2010 01:08 AM
by Fred Smith[_4_] Go to last post
1 191
Help with formula: finding text by Jonas Ornborg
Hi, I would like to ask for help with a formula for comparing name in a cell with a list of names in a table. If there is a match it should return a...
March 17th, 2010 12:55 AM
by Gord Dibben Go to last post
4 119
force alignment? by Art
I know how to format a cell so the alignment is centered both vertically and horizontally. However, if a user copies/pastes text from, say, Microsoft Word...
March 17th, 2010 12:54 AM
by Gord Dibben Go to last post
7 379
return different values based on 4 criteria? by Susie (SFAngelgirl)[_2_]
Need Formula or macro to allocate the "Scheduled hours" based on Group Counts: If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C"...
March 16th, 2010 10:31 PM
by Susan in Sacramento Go to last post
4 139
March 16th, 2010 10:23 PM
by Gord Dibben Go to last post
1 136
Using a cell's value to copy another cells info to another workshe by badger2407
I am not sure that this is possible, but I will ask. I am running a bowling tournament that has many teams (2 people/team) over several shifts. These teams...
March 16th, 2010 10:21 PM
by Gord Dibben Go to last post
1 161
Post New Thread


Display Options
Showing threads 2061 to 2080 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:30 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.