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
I am repeating the same procedure and cpt codes by Chinadoll777
I would like to have ONE procedure and ONE cpt codes
December 30th, 2009 07:56 PM
by Mike H Go to last post
1 91
Sort unique data from a colum by TR Young
I have a column (let's call it 'Column C') of data that represents part numbers required to build an assembly. In Column C are multiple part numbers, some...
December 30th, 2009 07:11 PM
by TR Young Go to last post
2 106
UDF Function by Mouimet
Hi, I have many different long formulas and I need to name each of them This way I will be able to say: Choose(A1, ATV,AVG,Unit) If cell A1 = 2 the cell will...
December 30th, 2009 06:43 PM
by Per Jessen Go to last post
1 91
Averageif year=2000 by MitzDriver
In column A i have settledate "01/02/2000", thru todays date. In column B, I have the price "195600", etc. A B settledate ...
December 30th, 2009 06:06 PM
by Teethless mama Go to last post
5 201
how do I get a function formula cell to format as a number? by Kristin
I put this formula "=IF(OR($C$9="Check",$C$9="Decrease Adjustment"),$G$8,"0")" and the cell formats as a number but when I put this formula "=(IF($C$8="Enter...
December 30th, 2009 05:55 PM
by T. Valko Go to last post
5 152
Tricky Macro Question by Philip
I created a worksheet that consists of multiple fields of data (the columns are ie. date, point of contact, completion date, etc) and based on the inputs...
December 30th, 2009 05:40 PM
by Philip Go to last post
4 136
adding numbers in a column with dates by piklelila
I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6...
December 30th, 2009 05:33 PM
by trip_to_tokyo[_3_] Go to last post
5 144
COUNTIF? by AAA1986
Each entry in my database has a category listed in column A. I would like to create a column that produces the n for each entry's category. For example, if...
December 30th, 2009 04:48 PM
by Fred Smith[_4_] Go to last post
6 105
Formatting cells to show two dates in one cell by Jo4321
I have a column in my spreadsheet that is for the date that I recieve info from clients. When I recieve this info on more than one date, I've been putting a...
December 30th, 2009 03:45 PM
by Glenn[_6_] Go to last post
3 110
Total a column contingent upon the cell to the right being non-bla by Ed Livingston
I need a total from Column C for each cell which has an adjacent cell in Column D that is non-blank. -- Industrial Technology Teacher Timberlake High...
December 30th, 2009 02:21 PM
by Fred Smith[_4_] Go to last post
3 98
Using ISNA on more than one column within an If Function by Lyons550
Hi All, I'm trying to construct a formula that looks at the following section of data: A B C ...
December 30th, 2009 01:39 PM
by Stefi Go to last post
2 131
Add one by GillianX
Hi, This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004
December 30th, 2009 11:00 AM
by Mike H Go to last post
4 76
Format date by MAX
Hello I'm working on excel 2007 and I have a workbook with 15 sheets. The problem is that the dates are all in English US and I want them in English UK. What...
December 30th, 2009 10:37 AM
by MAX Go to last post
3 95
offset formula by vmohan1978
IN CELL B1 MY INPUT VALUE VARIES FROM 1-30 IN E1 MY INPUT WILL BE AMOUNT IT VARIES ASSUME 300000. i WANT FORMULA IN A5 TO SHOW 0 AND A6 AS 1 SO ON TILL I GET...
December 30th, 2009 09:32 AM
by Max Go to last post
3 96
Auto filter custom filter by stevefromnaki
Hi, I have applied an autofilter to my data. I want to do a custom filter from there. My data is as follows: 100 110 120 200
December 30th, 2009 06:23 AM
by stevefromnaki Go to last post
2 97
a if calculation help by FredDave
Hi all i have a if calculation which i need to expand but I can't figure it out =IF(AND(D21=1,D21=7),"week",IF(AND(D21=8,D21=15),"2 wks","3 wks")) I...
December 30th, 2009 03:44 AM
by Teethless mama Go to last post
2 81
Good example of the use of Vlookup by TheQuickBrownFox
This sheet has a lot of vlookups and uses a lot of named ranges. It has current stats filled in up through week 16 of the current...
December 30th, 2009 02:47 AM
by TheQuickBrownFox Go to last post
0 89
HOW DO I TURN MY UNDO REDO FUNCTIONS BACK ON IN MICROSOFT EXCEL by NEETZ123
I have used Exel for many years and never experienced this problem before. One day I opened a file and it was okay; I could undo and redo with no problem. ...
December 30th, 2009 02:01 AM
by Dave Peterson Go to last post
1 101
How to paste data to alternating cells down a column? by wbowers
I am copying data from a column in one sheet where the entries run concurent down the column. When I paste to the new sheet I need to paste the information...
December 30th, 2009 01:22 AM
by Max Go to last post
1 98
concatenate within an excel formula by sarah - northampton
I am trying to concatenate cells and have the result execute within a formula. I am ending up with: =sheet4!A2 instead of the value that is contained...
December 30th, 2009 12:51 AM
by Max Go to last post
3 100
Post New Thread


Display Options
Showing threads 4281 to 4300 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 07:23 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.