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
not sure what is wrong by Alex H
Hi i have the following code for a cell, but if I enter 01752 into RC3,5 I am getting "Long distance". Can someone tell me what I'm doing...
January 16th, 2007 09:27 PM
by Alex H Go to last post
7 89
Matching Data by Alex Hammerstein
Hi I have two sheets in a single workbook I want to look up where data in sheet 1 Column A matches the data and sheet 2 Column A and where there is a match...
March 10th, 2010 04:51 PM
by RonaldoOneNil Go to last post
1 112
Analysising data between sheets by Alex Hammerstein
Hi I am trying to pull data from one sheet to another and analyse it. I need to place in cell Sheet2!F5, the sum of Sheet1 Column E, where Sheet2!B5 is...
April 2nd, 2009 10:02 PM
by Alex Hammerstein Go to last post
0 55
Grouping data by Alex Hammerstein
Hi, I have a worksheet where data is imported from an Access Database. Column A contains the month and year on mmm-yy format and is in descending order i.e....
March 24th, 2009 03:53 PM
by Pecoflyer[_253_] Go to last post
4 107
COUNTIF by Alex H[_3_]
Hi if I want to count the number of rown where B4:B65535 31/07/06 and 01/08/07 and C4:C65535 = "No" how would I express this please Thanks A
September 10th, 2007 04:15 PM
by Alex H[_3_] Go to last post
6 78
Complicated formula help needed please by Alex H[_3_]
Hi Is it possible please to create a formula where Sheet1!A2 = the count of Sheet2!C* where Sheet2!A*= Sheet1!A1 and Sheet2!B* contains "String" Thanks Alex
September 6th, 2007 03:17 PM
by Alexey Go to last post
2 65
SUMPRODUCT by Alex H[_3_]
Hi could some kind eoprson help me please. Through help from this forum i have arraived at: =SUMPRODUCT(--('Data from MIS'!M4:M65535=A5),--('Data from...
September 7th, 2007 10:02 PM
by Alex H[_3_] Go to last post
6 69
find repeating values by Alex Kachanov
Hi! How can I find sum of repeating values in column? What formula should I use? Thanks. ________________ Alexander Kachanov aka Alex29 ICQ#...
September 29th, 2003 06:25 AM
by Leo Heuser Go to last post
6 133
joing (merge) tables by key field by Alex Kachanov
Hi! How can I joing (merge) tables by key field like in DBMS? Can't find any suitable solutions. Only by some stupid tricks, but I don't like it and it's not...
August 27th, 2005 02:32 PM
by Dave Peterson Go to last post
1 102
how to make an IF function that has the same result as COUNTIF? by Alex Khan
I imported a set of Color Functions from http://cpearson.com/excel/colors.aspx And I want to replace where I added COUNTIF in my sheet with a new function...
July 24th, 2008 11:15 PM
by Alex Khan[_2_] Go to last post
4 155
How do I set up a template for calculating absorption costing met. by Alex Lee
My company is a food processing factory. I want to set up costing department using actual absorption costing method.
February 20th, 2005 10:54 PM
by nbrcrunch Go to last post
2 82
Calculation options change arbitrarily by Alex Mackenzie
I have a date stamp function on a spreadsheet to track when people enter data; it is a function I found on an earlier posting. The function creates a...
July 7th, 2009 02:38 PM
by Bernie Deitrick Go to last post
1 81
Help with SUMPRODUCT by Alex Mackenzie
I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 ...
May 15th, 2009 08:17 PM
by Dave Peterson Go to last post
7 97
Reference previous worksheet within VLOOKUP by Alex Mackenzie
I have found several previous postings about this, but still cannot get my function to work. If I put the name of the previous worksheet (e.g. March 09!...
April 17th, 2009 07:20 PM
by Teethless mama Go to last post
2 75
Security Settings by Alex Mackenzie
What is the correct security setting to allow someone to only enter data into cells? Read & Execute or do they need Write or Modify? This is for a shared...
August 16th, 2007 04:18 AM
by Harlan Grove[_2_] Go to last post
2 65
Pivot Table Filters by Alex Mackenzie
When using the drop down on a column field to filter data in the pivot table, I find items in the list that are no longer in my data (the data was messy when...
January 30th, 2009 10:54 PM
by Shane Devenshire[_3_] Go to last post
2 54
Pivot Table - Row subtotals by Alex Mackenzie
I have a pivot table with two row fields, say Field1 and Field2. The pivot table subtotals (sums) the rows for Field2. Rather than sum, I would like to...
January 9th, 2009 04:04 AM
by Debra Dalgleish Go to last post
3 78
NOW() function that won't change by Alex Mackenzie
We use a spreadsheet to log incoming inspections of products. I want to monitor how long it takes between receipt and inspection; receipt is logged into a...
December 19th, 2008 09:16 PM
by Héctor Miguel Go to last post
4 192
Losing reference when deleting worksheet by Alex Mackenzie
I have a workbook with multiple worksheets. One of the worksheets contains data that is used in formulas in the other worksheets. The workbook is distributed...
June 28th, 2006 05:11 PM
by Alex Mackenzie Go to last post
0 59
Offset Reference Cell by Alex Mackenzie
I am using the OFFSET function with a spreadsheet created by our IT department. I have added the offset function to help sort the results in the...
December 18th, 2008 07:38 PM
by Luke M Go to last post
1 64
Post New Thread


Display Options
Showing threads 2361 to 2380 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 12:17 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.