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
Data Validation by retired bill
I have a column in my worksheet in which I am using data validation with V-lookup from another worksheet. When I click on the drop down list in the column...
April 26th, 2009 04:18 PM
by Gord Dibben Go to last post
5 66
Excel to inport data by Danny
Excel to inport data via the Com port 1
April 26th, 2009 01:58 PM
by joel Go to last post
1 77
Excel formula help by sam8
I'm trying to update assessment excel sheet of my college. I tried the following formula for grades in 2007 excel and it worked fine. but the same formula...
April 26th, 2009 11:26 AM
by sam8 Go to last post
7 124
view excel worksheet & freeze internet window synchronously by John H. Herrlinger
I want to "freeze" a "sized" internet Vanguard brokerage account data sheet on the same Excel worksheet screen to compare data (both "restored down" to 1/2...
April 26th, 2009 11:14 AM
by John H. Herrlinger Go to last post
0 103
link data from several speadsheets by Sherry S[_2_]
Hi all, I am trying to learn this as I go. I have 31 speadsheets all in the same workbook to represent the days in the month of January. They are exactly...
April 26th, 2009 09:26 AM
by AB Go to last post
3 92
Having trouble printing without the cell gridlines on new system by Beau
loaded office 2003 on new vista 64-bit system. Seems to work fine, but print drivers have a different look to them. I am having trouble trying to print excel...
April 26th, 2009 06:58 AM
by Beau Go to last post
0 112
EXCEL Help please by Jesson
Does anyone know what formula i can use to look for specific text within a range? IE: i have 20 cells......... 5 have the word "orange" in them, 6 have the...
April 26th, 2009 06:07 AM
by L. Howard Kittle Go to last post
3 70
Flow Chart by Chems23
Any ideas on how can I create a use a flowchart (from a worksheet) to create an scenario that would give an answer to a particular process. Example: I have A...
April 26th, 2009 03:57 AM
by Chems23 Go to last post
0 81
Office 2003 Excel funtion - data table by Jolly
I often use the data table function in excel 2003 but while working on the spreadsheet and not touching the cells with the "Table" function on adhoc basis...
April 26th, 2009 03:42 AM
by Ashish Mathur[_2_] Go to last post
3 79
Trapping errors in a VLOOKUP function by Blue Max
The VLOOKUP( ) function results in an #N/A error if an exact match cannot be found when the 'range_lookup' value is FALSE. In our case, this error taints...
April 26th, 2009 03:03 AM
by Ashish Mathur[_2_] Go to last post
1 81
How to refresh links across workbooks by apache007
Dear all, I have workbook A that has plenty cell references in other workbooks (about 10 workbooks approx). Currently, in order to refresh data in workbook...
April 26th, 2009 03:02 AM
by Ashish Mathur[_2_] Go to last post
1 77
Vlookup from more than one Tab by DILipandey
Hi Experts, Is there any way that vlookup can lookup value from more that one tabs. Refer following formula:- =vlookup(A1,(Sheet2!A:B,Sheet3!A:B),2,0) So...
April 26th, 2009 02:59 AM
by Ashish Mathur[_2_] Go to last post
4 101
returning a SUM from text. by tommyuptown
I have inserted yes/no checkboxes into a spreadsheet, I am looking for a Sumif that will return a total for all yes' answers in the column.
April 25th, 2009 09:44 PM
by Mike H Go to last post
1 60
comparing and isolating duplicates in two columns by monkeytrader
Thanks for your help in advance. If i have values in column A, and values in column B, is there a quick and easy formula that will isolate the...
April 25th, 2009 07:02 PM
by T. Valko Go to last post
2 53
Count Num of Unique items in col ? by NaplesDave
I need to be able to count the number of times an item Uniquely appears in a column. IE: Result cell NAMED: Species Contents of...
(Multi-page thread 1 2)
April 25th, 2009 04:10 PM
by Sheeloo Go to last post
11 114
Variable reference in a function by Wildebraam Production
Is there a way to write an Excel function so it can read a variable and use it as a reference? For instance, to read a value from cell C1 in Sheet2 to A1 in...
April 25th, 2009 03:50 PM
by Dave Peterson Go to last post
3 60
How do I move addresses in my contacts into an excel format? by tskaar
I am trying to all my addresses in my contacts into an excel format, so that I can email it to someone who is doing invitations for me. How do I transfer all...
April 25th, 2009 02:03 PM
by Jacob Skaria Go to last post
1 71
SUMPRODUCT usage by wild turkey no9
Hi There Is there an easy way to configure sumproduct to do the following: multiply col A * Col B when col B = either E or N or D Thanks Kevin
April 25th, 2009 10:30 AM
by Bob Phillips[_2_] Go to last post
5 81
Extracting certain text from text string by Haydie-lady[_2_]
I have a database list that I export into xls monthly. Once pasted in xls the list is just one column w/ several rows a text string (see below). I need to...
April 25th, 2009 09:55 AM
by bosco_yip[_2_] Go to last post
2 76
Index match combination by rhhince[_2_]
Can someone help me clarify this equation. =INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606),SLOPE!A507:A606)) I am asking excel to go to column D of the...
April 25th, 2009 08:51 AM
by Jacob Skaria Go to last post
4 80
Post New Thread


Display Options
Showing threads 11721 to 11740 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:48 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.