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
Importing data with tabs by Jack Deuce
We are trying to help our neighbor publish some documents she has been working on but am having trouble dealing with multiple tabs she sometimes uses between...
February 12th, 2010 03:22 PM
by Glenn[_6_] Go to last post
3 65
Modyfy table data by [email protected]
Please advise how to change the format of table 1 to table 2: Table 1 Family Code Person_ID Family...
February 12th, 2010 02:50 PM
by Luke M Go to last post
1 66
Lookup Cell Address by hmmm
I'm trying to lookup a value in a list, but return the cell address (or row number) of where the value was found instead of the value itself. So if my table...
February 12th, 2010 12:53 PM
by Ron Rosenfeld Go to last post
4 73
Help needed for Excel formula using if, iserr, match and vlookup! by midget
Hi I need help with the following formula: =if(=iserr(=match(a2,LIST,0))=0,=vlookup(a2,DATA,1),0) Excel says there is something wrong with my formula but won't...
February 12th, 2010 11:02 AM
by Pete_UK Go to last post
1 86
Selecting a range of cells based on the date. by Solomon
Hi MS Office Help, I would like to know how to choose a selection of cells based on what month it is. For instance, if the month was january, excel would...
February 12th, 2010 10:11 AM
by Normek Go to last post
1 87
Update to formula by Jen_T
Is it possible for a formula to look in cell and check if it contains specific text? I was provided the following formula, below, but it only checks to see...
February 12th, 2010 07:05 AM
by T. Valko Go to last post
4 79
My mouse cursor vibrates back and forth incessently. Won't stop. by MBDColorado
I have a new Dell Studio that has MS Office Basic 2007 pre-installed. MS Windows 7 is the operating system. I migrated my EXCEL 2003 programs over to MS...
February 12th, 2010 05:00 AM
by MBDColorado Go to last post
0 448
A Percentile IF function by RGulley
Hi i was running if there was a percentile IF function or a way to run something similar to an average if function. Lets say I have a data set like...
February 12th, 2010 04:20 AM
by Joe User[_2_] Go to last post
1 69
How to use conditons within a LOOKUP function? by THIS-IS-A-JOURNEY
I'm working with a function that needs to look at the number according to whether its less than. =VLOOKUP(35600, A2:C3,2, ) A B...
February 12th, 2010 01:41 AM
by Ashish Mathur[_2_] Go to last post
6 96
count all text values except a certain one by justjill111
if i have the word 'ditto' scattered among a bunch of names (text), how do i count every value that's not 'ditto' ? am i trying to combine "COUNTIF" value...
February 12th, 2010 12:34 AM
by justjill111 Go to last post
5 91
all cells in 2 workbooks have automaticlly changed to date format by dloc
Why would excel 2007 automaticly change formats? Upon opening a workbook this morning all the blank cells in the 16 sheets had changed from general format to...
February 12th, 2010 12:30 AM
by dloc Go to last post
0 78
"Disclaimer" by Sandie
I need to put a legal disclaimer on all printed excel pages. The disclaimer is too large to put in the Footer. Any ideas on how to do this?
February 11th, 2010 11:59 PM
by Bill Sharpe[_2_] Go to last post
2 55
Return cell content in a matched range by Jack
I need help with the following...
February 11th, 2010 11:55 PM
by Max Go to last post
2 62
E-mail notification of answers to my posts by Brymor
Although I always check the "Notify me etc" box, i don't get any e-mail notification of replies. Can someone please tell me why this is. I'll try it again...
February 11th, 2010 11:51 PM
by Bill Sharpe[_2_] Go to last post
6 82
Done. Done. Done. by msnyc07
Will never use Excel or any other Microsoft Software, Product, Service again as long as I live.
February 11th, 2010 11:46 PM
by Bill Sharpe[_2_] Go to last post
4 75
Excel work sheets by heather
Hi, I need a formula that will automatically pull information from one worksheet to another. I need to be able to seperate all of the plans, procedures...
February 11th, 2010 11:45 PM
by Otto Moehrbach[_2_] Go to last post
1 59
February 11th, 2010 11:39 PM
by Bill Sharpe[_2_] Go to last post
1 83
Turn off speak cells by Karen
How do you turn off speak cell (when you enter a number in a cell in speaks it)?
February 11th, 2010 11:37 PM
by Bill Sharpe[_2_] Go to last post
2 94
Cant type on line E31. by tabatha anderson
I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above. Submitted via EggHeadCafe - Software...
February 11th, 2010 11:36 PM
by Bill Sharpe[_2_] Go to last post
4 80
Formula to find last different value in a column? by msnyc07
I have a formula that is based on comparing the last value in a column. Basically of not null it performs an action. However I need the ones after that to...
February 11th, 2010 10:33 PM
by Glenn[_6_] Go to last post
5 90
Post New Thread


Display Options
Showing threads 3001 to 3020 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:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.