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
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 100
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 147
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 99
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 111
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 136
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 122
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 169
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 155
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 127
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 158
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 98
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 107
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 114
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 137
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 85
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 135
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 101
March 16th, 2010 10:23 PM
by Gord Dibben Go to last post
1 100
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 118
Conditional format if cell contains formula by Jean-Marc[_2_]
Is there a way (conditional formatting?) to apply a different format to cells that contain a formula, as opposed to cells that have a directly entered value?
(Multi-page thread 1 2)
March 16th, 2010 10:07 PM
by Mike N[_2_] Go to last post
13 378
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 06:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.