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
Multiple Sumif conditions by Alcala
Hello and thank you in advance for your assistance. I am trying write a formula for the following calculationj: In column B i have the initials of sales...
August 18th, 2008 05:30 PM
by Alcala Go to last post
2 57
Sumproduct with three arrays by Alcala
Hello and thank you in advance for your assistance. I have a spreadsheet as follows: Column C= Revenue Column D= Units Column E = Months, as a number (i.e....
December 13th, 2008 01:26 AM
by Alcala Go to last post
2 54
Creating Visual Excel Cell Alerts by alchemist
Hi there guys, I'm relatively new to this but would appreciate your help. Basically what I am trying to do in excell to create visual alerts in the same cell...
January 28th, 2010 05:16 AM
by CellShocked Go to last post
5 167
Isolate rows based on highlight (Excel 2003) by Alcide
Hello All, I am trying to select some rows that are highlighted and then take those highlighted rows and place in a new worksheet. I tried using Find by...
April 21st, 2005 05:40 PM
by Alcide Go to last post
2 234
Counting characters within a cell by Alco Engineer
In order to help update an existing spreadsheet, I want to be able to count either the number of numbers in a given cells, or alternatively the number off...
November 4th, 2008 07:08 PM
by Spiky Go to last post
5 79
Conditional Date formatting in a column of numbers by Alco Engineer[_2_]
I have a sheet where I am referencing another sheet which is in another workbook and is independant. For the sake of the exercise, Column C can either store...
January 15th, 2009 02:11 AM
by Alco Engineer[_2_] Go to last post
2 88
Making User defined functions available in all new workbooks by Alco Engineer[_2_]
Hi Guys, I have a few basic user defined functions I've made up so that I can easily calculate and also avoids common errors I've made. Can I set up a...
March 10th, 2009 11:15 PM
by Alco Engineer[_2_] Go to last post
5 161
linking worksheets and copying formulas in cells by alcorjr
You should use copy-paste and then clear up the original position, instead of cut Hope it helps!;) --- Message posted from http://www.ExcelForum.com/
December 29th, 2003 11:53 PM
by Dale Hymel Go to last post
2 336
Pivot Table categories by Alder
If I have a datalist like the following, is it possible to produce a pivot table with a single row for each unique combination of values in column A and B? ...
August 18th, 2009 12:30 AM
by Alder Go to last post
4 113
Copy Values to next empty cell range by Aldo Cella
How can I program this? I want to copy c19:g19 on sheet1, to the same sheet, and paste special(values) to the next empty row in this cell range,...
March 11th, 2008 12:22 AM
by Gord Dibben Go to last post
1 84
Lookup Array Formula by aldsv
A dozen google searches didn't solve this problem, but I know you can... I have a row of data (I actually have a lot of rows, and a lot of columns): I need...
October 25th, 2005 01:45 PM
by aldsv Go to last post
4 172
Display value from another workbook, if less than display a blank by aldutson
I want to display the value of a cell from another workbook. If the cell from the other worksheet is empty or the value is "0" then I want to display a...
July 27th, 2006 08:45 AM
by David Biddulph Go to last post
2 124
COPING FULL PAGE PATTENS TO ANOTHER PAGE by Alec
I'm setting up a yearly spread sheet that has different colour pattens in different cells etc. I wish to copy the full page patten layout onto the other...
November 29th, 2006 06:10 AM
by Jaleel Go to last post
1 80
Date Values by Alec
I currently have a cell that shows week commencing, ie Mondays date only for any particular week, I currently update this cell every week. I have been looking,...
October 31st, 2003 12:11 PM
by Alec Go to last post
4 123
Passing Variables into a Link by Alec
I have written VB code that, on the press of a pushbutton, creates new sheets from a template, it also puts the sheet name in cell A1 of the new sheet. I also...
October 9th, 2003 02:12 PM
by Alec Go to last post
4 261
vlookup in if by Alec Green
can you uses vlookup within an if statement, I can both functions to work separately but not together. Thanks Alec
(Multi-page thread 1 2)
February 22nd, 2006 09:38 PM
by Pete_UK Go to last post
10 171
Lookup Vector > Lookup Value by Alec Kolundzic
Hi, CABLE SIZE CAPACITY 1.5 18.0 2.5 24 4 31 6 41 10 56 When I use...
June 10th, 2005 02:14 PM
by Alectrical Go to last post
6 299
Detecting Blanks and Non Text Characters. by Alec Kolundzic
Help =IF( E61="Cable",Q61,IF( E61 ="Terminal",IF(ISBLANK(Q61),"",CONCATENATE($R$17," ",Q61)),"")) The above function concatenates the contents of R17 and Q61...
May 26th, 2005 04:28 PM
by Alec Kolundzic Go to last post
4 119
Highest Number Offsets by Alec Kolundzic
Can anyone help; I'm trying to find the highest number in a column, then copy that number and the data in the cells of the next two rows into three adjacent...
September 16th, 2004 12:00 PM
by Alec Kolundzic Go to last post
4 113
Highest Value by Alec Kolundzic
I'm looking for a function that will find the maximum value in a column, then will put that value in a cell
(Multi-page thread 1 2)
September 19th, 2004 09:11 AM
by Aladin Akyurek Go to last post
17 194
Post New Thread


Display Options
Showing threads 2181 to 2200 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 05:34 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.