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
how to include dash within a cell by Accounts jobs
If anyone can help me in this I would be very greatful We receive a list of codes like "TND4567". We manually put the dash between the text and numbers. is...
March 29th, 2007 09:40 PM
by meatshield Go to last post
7 49
Sometimes entering simple function causes it to occupy two cells, why? by [email protected]
I was putting a slightly modified version of this function into cell B12, in doing so it occupied cell B12 and B13 and merged the space together. This happens...
November 29th, 2006 07:37 PM
by [email protected] Go to last post
2 55
Out of Ideas, need help with Auto Fill by acctexecutive
I work in the sales department for a computer software company and I'm building a Territory Pipeline Tool. Currently we have 4 Inside reps that support 9...
June 21st, 2005 09:16 PM
by RagDyer Go to last post
3 121
Update one spreadsheet and reflect on another by Acctgbean
I have one worksheet that includes names. I want to add a second tab to include the same names plus additional information. I want to be able to insert a row...
November 3rd, 2005 09:36 PM
by Acctgbean Go to last post
0 82
TRIM functions by Ace
Can anybody pls help? Thankx
July 27th, 2004 02:31 AM
by Gord Dibben Go to last post
2 84
Copy formula down - cell references change - result is same for al by ace
Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All...
November 13th, 2009 10:23 PM
by Glenn[_6_] Go to last post
6 114
PROPER FUNCTION by ACE PRODUCTS
HOW DO I USE THE PROPER FUNCTION FOR MULTIPLE NAMES THAT NEED TO BE CHANGED?
July 12th, 2007 01:38 AM
by Harlan Grove[_2_] Go to last post
5 63
Tabs by Ace123
I would like to create multiple tabs based on information within the work book. Sheet 1 would contain a 3 digit number below the three digit number would be...
July 17th, 2008 02:13 AM
by Max Go to last post
1 65
Cell Column Comparison by ace21
I have six columns of part numbers (A-F) that I want to compare to each other. The part numbers that are an exact match I want displayed in column G and the...
January 16th, 2007 05:29 PM
by Max Go to last post
3 64
Date + 365 in New Column by ace214
I have a column of dates, F. I want to have the dates plus a year in column M. I figured out that you can add 365 to a date but I'm not sure how to process...
(Multi-page thread 1 2 3)
August 14th, 2007 04:39 PM
by Sandy Mann Go to last post
21 249
IF AND help! by acebrown
What's the formula for: If A1=2 or A11 then B1 If A2 then C1 If A=1 then 0 I assume it'll be an extensions of this formula which is missing the A12...
August 3rd, 2006 10:15 PM
by David Biddulph Go to last post
1 61
IF Function with & by acebrown
I'm having trouble getting the If function to work... A B 1.5 10 4 3 If 2A1, then (A-1)*B If not, then B So the result for row1 above should...
August 3rd, 2006 08:59 PM
by acebrown Go to last post
4 61
Circular Reference Formula Help by acebrown
I'm working with three cells: -original $ amount -new $ amount (original+change) -change (new-original) I would like to be able to enter a number in either...
July 22nd, 2006 01:25 AM
by davesexcel Go to last post
1 58
Check box in Filters by AceRoadRunner
Hello All, I am using Excel 2007. In Excel 2003, whenever you would apply a filter to a header row, you would be able to chose one criteria to filter. In...
July 15th, 2008 06:24 PM
by AceRoadRunner Go to last post
0 56
Searching for Duplicate Text in a column by acesandspades101
I have created a worksheet that lists identification numbers for valves and instruments on filtration machines. Now these identification numbers are unique...
August 25th, 2006 12:40 AM
by Max Go to last post
2 58
Question about Bacaratt Tracker by acesgamingworld
I am currently working on a bacarat tracker where you put in Banker, Player, or tie for my company, and need to see if there is a way for excel to give a...
October 15th, 2008 02:11 AM
by NoodNutt Go to last post
1 176
lunch break!! well..how to figure by acetoolguy
I was a row that looks this.. Arrival Departure Lunch total hours 7:00 am 5:00 pm .5 9.5 I cant seem to get the 1/2...
March 8th, 2009 04:48 PM
by Fred Smith[_4_] Go to last post
5 70
moving entries between workbooks by acetoolguy
I'm self employed, for record keeping I have an invoice, expence report and balance sheet. I fill out the invoice, then the expence report moving the invoice...
January 31st, 2010 11:15 PM
by Gord Dibben Go to last post
1 129
Help With If Statement by AceWebmaster
Can anyone explain to me how to correct the following logical expression which is designed to compare two columns. If the first column contains a 1 (indicating...
January 31st, 2006 04:35 AM
by AceWebmaster Go to last post
4 118
Find project start and end dates in a DB with many different proje by AceWriter01
I've got a spreadsheet containing tracking information for a number of projects. Each row in the spreadsheet contains the following kinds...
April 1st, 2005 03:58 AM
by JulieD Go to last post
3 193
Post New Thread


Display Options
Showing threads 1081 to 1100 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:51 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.