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
Macros and different lengths of files by Gretta
Can I create a macro that can automatically repeat itself depending upon the length of the file?
January 26th, 2005 03:07 PM
by Harald Staff Go to last post
1 90
Date format within a text syntex? by Brw
I have two date fields that users enter dates into. I have a field with the following formula where I want the dates to appear within a preformatted...
January 26th, 2005 03:13 PM
by Harald Staff Go to last post
2 105
How to write IF function in Excel 2000 when there are two conditi. by Dajana
I need to write the IF function for two conditions: if a cell value is 2 but at the same time 4 (between 2 and 4) if true is equal to 4 otherwise if false is...
January 26th, 2005 03:15 PM
by Max Go to last post
1 147
Is IF the best choice by br0ke
I have the following list (which in real terms goes to 10 variables). I have tried nested IF's but got nowhere. What is the best way of auto-completing the...
January 26th, 2005 03:19 PM
by br0ke Go to last post
2 108
COUNTIF by Gary T
Hi, I want to count the number of entries in column A. Formula is to count all cells that have data in them. Cells could theoretically contain a...
January 26th, 2005 03:21 PM
by Max Go to last post
1 121
Variable validation-password protect sheet by Marty
I am using the Variable validation procedure( DataValYesNoClear.xls) from: http://www.contextures.com/excelfiles.html in my workbook and it's working great....
January 26th, 2005 03:27 PM
by Marty Go to last post
0 181
Date by Ginny
So simple, yet I can not seem to get this right. I need month/year only in one cell. Thanks.
January 26th, 2005 03:36 PM
by IC Go to last post
1 105
Help with Complex SUMPRODUCT formula by Murph
I need some help with a complex SUMPRODUCT Formula I have. I'm using 5 different columns in the formula to come up with the data I need. the first column is...
January 26th, 2005 03:40 PM
by Domenic Go to last post
5 190
Error Return Value from and INDEX(A:2,MATCH()) function by BJ
Hello, I am using the following function =IF(INDEX('Page A'!F:F,MATCH('Page B'!A9,'Mar A'!A:A,0))=#N/A,"",INDEX('Page A'!F:F,MATCH('Page...
January 26th, 2005 03:59 PM
by BJ Go to last post
4 192
How to monitor productivity within departments using Microsoft Exc by Vicki
I'm gathering production numbers for all 7 internal departments within our work unit, I would like to know if this can be done in Excel? The info that I would...
January 26th, 2005 04:03 PM
by Vicki Go to last post
0 89
Is there a template for rapid debt repayment in Excel? by fofanna
Am using Excel 2002. Looking for a template that will calculate time to repay debts with fixed payments each month, rolling amounts from paid off debts toward...
January 26th, 2005 04:07 PM
by fofanna Go to last post
0 215
IF(ISNA formula problem by Brad
I'm using the above formula to return a blank cell or a 0 if my vlookup returns an N/A. Where this is a problem is that I have a...
January 26th, 2005 04:14 PM
by JulieD Go to last post
7 136
Currency in cell ref by gb_S49
I am using the following to consolodate the cell contents into one cell for a chart label. My problem is H2 data is numeric (no prob) K2 is currency (£) and...
January 26th, 2005 04:17 PM
by Josh Go to last post
3 105
index,match + 1 cell below? by StevenL
if you are using the index/match combination function is it possible to index the row below the result. In other words is it possible to take result...
January 26th, 2005 04:55 PM
by SteveT Go to last post
4 100
Is VLOOKUP the right function? by bay
Hello, I am working on a worksheet with 3 columns. A with dates, B with invoice numbers, C with names. I'd like to put a function in cell D1 that looks up a...
January 26th, 2005 05:35 PM
by Peo Sjoblom Go to last post
3 107
Function to look at two cells and return a third by jlmam
I'm hoping someone can help me. This seems like a simple task but I'm at a loss. Here is a current working formula, but I need to look at TWO cells...
January 26th, 2005 05:41 PM
by jlmam Go to last post
2 225
'IF' FUNCTION for 2 columns by Lisa
I have a list of reference numbers in column A, and a list of prices in column B (Sheet 1). In a separate sheet (Sheet 2) I have ref numbers and their price...
January 26th, 2005 05:56 PM
by Bob Phillips Go to last post
5 174
Looking for an easy way to replace letters with acutes by Speak-ezy
Is there an easy way to change letters with acutes to letters without acutes (i.e. replace á with a, é with e, ó with o, etc.) without doing a Find/Replace...
January 26th, 2005 06:04 PM
by Daniel.M Go to last post
4 148
splitting and rejoining text in cells by sh0t2bts
I have some data that I have pulled back from an SQL server that I need to match but they clearly do not match in computer terms as A = B. I have two columns...
January 26th, 2005 06:50 PM
by sh0t2bts Go to last post
3 91
Formatting Fields by Naguib
Hi I have a spreadsheet which has a number of formatted fields. Basically, it's a list of numbers where each number is coloured a specific colour...
January 26th, 2005 07:02 PM
by Bob Phillips Go to last post
1 157
Post New Thread


Display Options
Showing threads 10201 to 10220 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:06 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.