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
MROUND by emz486
Hope someone can help but whenever I use the MROUND function the answer is always (#NAME?). Does this even when I copy the example from the help menu. Anyone...
April 22nd, 2009 07:40 PM
by T. Valko Go to last post
3 70
Comparing 3 Columns by [email protected]
I've been searching for a while, but I am out of my league trying to figure this one out on my own. I would like to compare three columns. A B C 1 ...
April 22nd, 2009 07:15 PM
by [email protected] Go to last post
2 143
concatenate won't work by TracySLPS
I used a .txt file to import into excel. i have saved it as a .xlsx file and now i need to concatenate columns p-t. all columns are text columns, i used the...
April 22nd, 2009 07:12 PM
by TracySLPS Go to last post
6 95
Lookup table for rates? by Wanda
Hi All! I'm still getting used to Excel2007 :-| Here's my question. I'm trying to create a worksheet that will calculate interest on accounts on a daily...
April 22nd, 2009 07:08 PM
by Wanda Go to last post
4 91
minimum value in a column, which row no? by Darius
Using Min (range) I can find the minimum value of a column of data. But how can I find which Row number it belongs?
April 22nd, 2009 06:53 PM
by T. Valko Go to last post
6 93
simlple question by Darius
In a cell F8 I have a number as for example: 3115 now in Cell M2 I want to say : =J3115 Problem is this 3115 number may change, so how M2 value change the J...
April 22nd, 2009 06:31 PM
by Jacob Skaria Go to last post
3 80
cells selection by Davey
When I use the curser to select a single cell, multiple cells are selected. If I tab, the highlight stays within the selected cells. When I use the arrow...
April 22nd, 2009 06:27 PM
by Gord Dibben Go to last post
7 198
One text for particular period by kashish
If A1 = Any date, I need a formula for A2 with conditions like If A1 between 01 Jan 2009 to 31 Mar 2009 then A2 = Q1 If A1 between 01 Apr 2009 to 30 Jun 2009...
April 22nd, 2009 05:52 PM
by Dave Peterson Go to last post
5 83
Automatically add and subtract by BadBoy
Hello all, I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I...
April 22nd, 2009 05:52 PM
by BadBoy Go to last post
3 73
average with N/A by dernspiker
I have a spreadsheet with 9 worksheets (named by employee last name). On the 9th worksheet I want to get the average of cells B4 from each of the other...
April 22nd, 2009 05:50 PM
by Dave Peterson Go to last post
3 72
"Validation" question by Shannon
When validating a cell from a list, is it possible to create a formula tied to that validation? For instance: column A - each cell has a drop down option...
April 22nd, 2009 05:08 PM
by Eduardo Go to last post
2 66
circular reference - iteration by rock
I am building a forestry growth and harvest model that forecasts out twenty years ahead. I need to be able to change assumptions such as beginning volume...
April 22nd, 2009 04:50 PM
by rock Go to last post
5 163
Conditional functions on portions of cell data by sabow71
I manage a strength report for my employer that accounts for each employee using a unique number assignment system. This system is designed to allow me to...
April 22nd, 2009 04:49 PM
by sabow71 Go to last post
4 112
Sumif query by ArcticWolf
Hi, I have a sheet of sales data (c1000 lines) and need to sum it all up into areas. My sales data is: Area,Value,Include 1,10,Yes 2,9,Yes 3,8,No
April 22nd, 2009 04:47 PM
by ArcticWolf Go to last post
4 86
Formula for selecting a Leap Year. by BadBoy
Hello, The first formula below checks to see if the word February is in one cell and the year 2012 in another and if so, will place the number 29 in another...
April 22nd, 2009 04:41 PM
by Glenn[_6_] Go to last post
9 80
Countifs by Carl
Excel 2007: Trying to use Countifs To simplify, in column B, over the range B2:B1250, I have the letters a,b,c,d I need a count of "a", =countif(...
April 22nd, 2009 04:28 PM
by Teethless mama Go to last post
1 56
Concatenate Dates by EllenM
Hello, I need help to concatenate a date field. For example, I'd like one of them to say "Posted 1/12/2007". Instead I'm getting "Posted 39094". Thanks in...
April 22nd, 2009 04:14 PM
by EllenM Go to last post
2 55
All my textbox disappear.. by Hwee
Hi I am currently doing some work on excel 2003 and suddenly all my textbox disappear. I can no longer use the textbox function. Please help. I have a lot of...
April 22nd, 2009 03:55 PM
by Gord Dibben Go to last post
1 64
change date format without retyping dates by sarajane82
i am trying to fix a spreadsheet that a coworker made. it includes a formula that subtracts one date from another. the problem is that the person put the...
April 22nd, 2009 03:49 PM
by Gord Dibben Go to last post
3 85
Keep Leading Zeros in Concatenation by EllenM
Hello, I have a column of numbers that I've added leading zeros to make 6 digits. I've done this using the a custom format of "000000". So 1 becomes 000001,...
April 22nd, 2009 03:47 PM
by EllenM Go to last post
5 299
Post New Thread


Display Options
Showing threads 11881 to 11900 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:02 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.