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 Reverse Sort Order Last Post Replies Views
If the lookup-value is a formula by Adam
Does anyone have an alternative to LOOKUP(LU_Value;LU_Vector;Range) if the lookup vector contains formulas? Thanks! /A
February 17th, 2005 03:31 PM
by Adam Go to last post
0 58
Can/Should this work? by Adam
Can the below actually be done? If so, am i just writing it incorrectly as it doesn't seem to like...
April 23rd, 2008 11:33 AM
by Bob Phillips Go to last post
1 67
Sumproduct on Dates? by Adam
I have a column of dates (in calendar order3/1/08, 3/2/08, 3/3/08,etc...) and a column of corresponding $ amounts next to each date. I need to be able to...
April 23rd, 2008 06:47 PM
by T. Valko Go to last post
2 75
replace a word with another word through out workbook by adam
I am creating a workbook with multiple pages. I would like to type a company name on the first page and have it placed in the middle of sentences through out...
December 9th, 2008 12:25 AM
by Gord Dibben Go to last post
3 58
im trying to create a date formula by adam
I am trying to set up a cell that will auto load the currant date. I really would apreciate it if someone could help me
December 11th, 2008 05:40 AM
by T. Valko Go to last post
1 58
Skip Blanks Not Working by Adam
I am trying to select every 4th piece of data from a column of 6000. I have tried copying every fourth into another column and trying to copy and paste this...
January 5th, 2009 11:17 PM
by [email protected] Go to last post
4 48
Count IF by Adam
Hey Guys, i Want to use COUNTIF function liek this.. (Range, Criteria, when you use count if, it will just let you do one if statement, (range,...
April 13th, 2009 10:55 PM
by Dave Peterson Go to last post
1 41
"IF" question by Adam
I am trying to get cell BA2 to look at BA1 and say "Yes" if BA1 is equal to either "1" or "3". I know this should be simple, but for the life of me I can't...
September 23rd, 2009 05:59 PM
by T. Valko Go to last post
3 47
how do i make a cell a search cell for a spreadsheet by adam
How do I make a cell a search/find cell for the spreadsheet. I want to avoid having to do ctrl+f and then put it in. I know it seems small but this has to...
November 3rd, 2009 12:16 PM
by john critchley Go to last post
5 71
Reducing duplicate courses to totals of each day by Adam
It might be easier if i just explain my scenerio. In each row of my spreadsheet is one person. The code (Column A) represents a course that I run. The...
June 20th, 2008 01:10 PM
by Sivakumar O. K. Go to last post
3 63
HELP - Date Range In 1 Cell Calculation by Adam
Hello, I have one cell where i enter a date 8/30/2005 (which resides in A3). And i need another cell to display a date range based on the above date. The...
September 19th, 2005 08:24 PM
by Adam Go to last post
6 95
find LAST match in column by Adam
Hi Domenic, I just saw this correspondence and I wonder if you could explain the formula because i do not understand how it can return the right value (even...
February 24th, 2005 12:18 PM
by Aladin Akyurek Go to last post
1 70
Making list with unique columns by Adam
I have a column with many different supplier, with some of the occuring many times e.g. Column A Supplier A Supplier A Supplier B Supplier C Supplier...
March 11th, 2005 10:21 AM
by Adam Go to last post
7 66
Protection of many sheets by Adam
I have a workbook with 50 sheets. I would like to protect all of these sheets with the same password at the same time. i.e. i do not want to protect...
(Multi-page thread 1 2)
December 16th, 2009 06:08 PM
by Michelle Thompson Go to last post
13 137
convert cell contents to different data file format by adam
How do I change my comma delimited file format to ASCII with each cell's text content bracketed in single quotes? eg: apple,banana,strawberry - ...
April 10th, 2005 08:39 PM
by Dave Peterson Go to last post
2 91
Cell lock by Adam
Is it possible to change the characteristics of a cell based on content of another cell. My problem is: If c2=0 then e10 should be locked if c2=1 then e10...
April 18th, 2005 10:45 AM
by Fadi Chalouhi Go to last post
1 57
Formula for button name by Adam
Is it possible to assign name of a button as a formula i.e. e.g. the content of cell C4?
April 22nd, 2005 05:10 PM
by Otto Moehrbach Go to last post
1 49
Help with a formula by Adam
=IF(B7=50000000,$B24*$D24+$B25*$D25+((B7-$D26)*$B26),IF(COUNTIF(B7,"b7$D24,b7$D26"),$B24*40000000+((B7-40000000)*$B25),IF(B740000000,$B24*B7,0))) The...
August 9th, 2005 11:13 PM
by Adam Go to last post
2 58
HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006 by adam
i have an excel absence tracking from from the templates web site it is great, how do i change or get to perform the 2006 yesr
September 3rd, 2005 06:58 PM
by Gord Dibben Go to last post
1 83
Convert currency to general by Adam
Hi, I was wondering is there any way to convert currency to a general format (or text). I need to export information from my AP application to my bank. ...
(Multi-page thread 1 2)
November 13th, 2009 11:35 PM
by Gord Dibben Go to last post
12 92
Post New Thread


Display Options
Showing threads 1161 to 1180 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 11:31 AM.


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