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
event vba by irosh
hi all how can i intercept an add entire row event ?
November 11th, 2008 10:25 AM
by irosh Go to last post
4 86
breaking a field out by JCM
I have a column of cells that all have a last name followed by a comma and then a first name. I need to have the last name in one column and the first name...
November 11th, 2008 09:44 AM
by Dave Curtis Go to last post
3 129
Reference column by climate
Hi I have a matrix (A2:BJ200) on sheet1, and column A consist of name of stations which name of any station repeated in 3 cells.( i say Reference column). On...
(Multi-page thread 1 2)
November 11th, 2008 06:24 AM
by climate Go to last post
14 255
copy cells using formula by Kashyap
can anyone help me in copying cells from one sheet to another which has todays date
November 11th, 2008 05:17 AM
by Kashyap Go to last post
3 109
IF and OR statements by bob
I'm trying to create a formula that does the following from sheet2: If the text in sheet2 column A equals the text in sheet1 column H and the text in...
November 11th, 2008 04:57 AM
by T. Valko Go to last post
1 111
Lookup less than a number by Rod
Hello. I would like to be able to do the equvivalent of: look up a number in range MaxTermAvail and if the number is the left value then bring back the...
November 11th, 2008 03:46 AM
by T. Valko Go to last post
6 108
count if question by gurmy77
I am trying to help out the office at work with this one but I seem to be missing something. First off they are using excel 2003. I know the first answer is...
November 11th, 2008 03:38 AM
by Ashish Mathur[_2_] Go to last post
3 132
function to only show unique cells in range (e.g. B2:B20) by OnTheEdge
I'm trying to figure out how I can automatically only show unique values in a column range using a function. Is there a way to do this? Thanks...
November 11th, 2008 03:03 AM
by Ashish Mathur[_2_] Go to last post
6 128
If statement only shows value in first cell by Mea
I'm trying to use an IF statement to find a value in a row array, and return that text value in the formula cell. 1 a b c d e 2 101...
November 11th, 2008 02:54 AM
by Ashish Mathur[_2_] Go to last post
3 106
Expanding a named range by jayceejay
I Have a set of values in a column that keeps track of customers for a given product. I have a CountA function set up to count the non-null values in the...
November 11th, 2008 02:52 AM
by jayceejay Go to last post
3 104
Need to find matching criteria in 1 column, then add amounts in a by HeatherJ
Hi, Trying to match criteria in one column and then add amounts that are in a second column. Need to find all in column A that match, then add amounts in...
November 11th, 2008 02:51 AM
by Ashish Mathur[_2_] Go to last post
4 131
How to determine the value? by Eric
Does anyone have any suggestions on how to determine the value? There is a list of values under column A 191,189,183,177,175,171,167,165,155,153,151 There is...
November 11th, 2008 02:12 AM
by Teethless mama Go to last post
2 105
How to use a range in a custom function? by Danny
I am trying to do a custom lookup function where the range remains constant a1:b365 and I am trying to lookup a long list where some references are blank and...
November 11th, 2008 01:48 AM
by Danny Go to last post
5 109
formatting question by Belinda7237
I have a column with various numbers in the millions and want to format: 12,342,000 to $12.3 Is there a way i can easiliy format a column this way?
November 11th, 2008 01:37 AM
by Belinda7237 Go to last post
1 93
countif function by jerry
I have a 4 column spreadsheet. Col a = date, Col b = time in, Col c = time out, Col d = minutes spent. I would like to count all the entries that fall...
November 11th, 2008 12:39 AM
by T. Valko Go to last post
8 102
IF Statement with AND Statement by Ken Quick
I have a Statement that Shawn Devonshire helped me setup. Suppose you set up a table like this starting in cell A1 A B ...
November 11th, 2008 12:11 AM
by Ken Quick Go to last post
4 92
Help with function, if possible by Steve D
Hi all, Using Excel 2003. I have 12 sheets, each labled with the month name, I use each sheet for a calendar for that month. Sheet looks similar to this, D1...
November 10th, 2008 11:20 PM
by Steve D Go to last post
8 168
Conditional formatting by Dinesh
I am using office 2007. I have created Pivot Table. Column A which is called "Area" has a filed setting set up as "Automatic" as subtotal. Pivot has columns...
November 10th, 2008 11:06 PM
by ShaneDevenshire Go to last post
1 86
Identifying unique values among duplicates by bob
If sheet2 cols A and C match the value in sheet1 cols H and I, I want to return the number of unique values in sheet 1 column A. Can anyone provide a formula...
November 10th, 2008 10:43 PM
by T. Valko Go to last post
4 103
No. of columns in a Pivot Table by mathel
Hi, I am new to Pivot tables and I am trying to do a report to track certain information. I created a workbook that has 19 columns and intended to do 3...
November 10th, 2008 10:43 PM
by ShaneDevenshire Go to last post
1 96
Post New Thread


Display Options
Showing threads 18001 to 18020 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:40 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.