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
Formula to identify text into columns by Forgone
I've been given a question in excel and I think it can be done but can't figure out how to do so. The worksheet they have has in Column A - a description of a...
March 17th, 2009 10:27 AM
by Jarek Kujawa[_2_] Go to last post
7 79
MOREFUNC by lehigh46
Hi All: For some reason Morfunc is not working. I tried re-installing it, but after that Excel does not recognize it anywhere. I spcificly need it for...
March 17th, 2009 09:39 AM
by Bob Phillips[_2_] Go to last post
1 59
Link updates Excel 2007 by Alain Schneiter
Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust...
March 17th, 2009 09:38 AM
by Alain Schneiter[_2_] Go to last post
6 77
vlookup 2 arguments by lab-guy
I've seen several responses about using match and index to accomplish; don't see it working for me. Need to do: Select Grade from Datablock where student_id...
March 17th, 2009 05:15 AM
by Shane Devenshire Go to last post
4 70
Comparing Excel Dates by Dashman
I have a list in which I want to find similar dates and times in a column and extract the earliest date/time. I have been manually sorting the date/time...
March 17th, 2009 02:21 AM
by Dashman Go to last post
5 60
Refresh pivot table in workbook A when changing a cell in workbook by gildengorin
I believe this takes me into the VBA realm and that is uncharted territory for me. Here we go: I have 10 pivot tables in workbook A on worksheet 1. I need...
March 17th, 2009 01:57 AM
by Shane Devenshire Go to last post
1 71
How do I do A repeated measures ANOVA on Excel 2007??? by Molly F
I have a satistics assignment due this week and I can't find instructions for Excel 2007 anywhere. My problem is I don't know what to put in the "rows per...
March 17th, 2009 01:54 AM
by Shane Devenshire Go to last post
1 83
Lookup closest to by sgl
I have the following table Name Date Amount Anemi Test 31-Dec-11 ...
March 17th, 2009 01:23 AM
by Ashish Mathur[_2_] Go to last post
5 77
Whats wrong with this function? by Angelsnecropolis
B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45...
March 17th, 2009 01:22 AM
by Shane Devenshire Go to last post
5 44
Euroconvert function in Excel 2000 returns a #NAME? by pasqualejr
I use Office 2000 on a Windows 98se machine, Euro Currency Tools is installed and the box is checked but the Euroconvert function doesn't work, I just get a...
March 17th, 2009 12:20 AM
by pasqualejr Go to last post
0 492
Attach code by MAX
How to attach the code to a Sheet_Change event
March 17th, 2009 12:11 AM
by MAX Go to last post
5 342
Conditional Formatting by Joe Gieder
First thank you for your help. I'm trying to use conditional formatting to highlight the cell that is the lowest among these cells and I tried using this...
March 16th, 2009 11:13 PM
by Joe Gieder Go to last post
2 75
Outline/group data below by Steve[_7_]
In xl2007, to the bottom right hand side of the "Outline" section (where the group and ungroup buttons reside), click on the small arrow. This is the setting...
March 16th, 2009 11:04 PM
by Steve[_7_] Go to last post
0 61
basketball bracket by tonyalt3
Does anyone out there have a spreadsheet that would check to see if tournament picks are correct/incorrect and then total up points on a summary page?
March 16th, 2009 11:01 PM
by Dave Peterson Go to last post
5 78
Formula/Function for Counting Characters in a cell by CyndiR
I'm trying to find a formula/function that count all characters in a cell. Our employee's street address may exceed the maximum 25 characters allowed and I...
March 16th, 2009 10:25 PM
by Gord Dibben Go to last post
4 58
Even or Odd Year Function by Dave H[_12_]
I am trying to use the Year Function =Year(A1). If A1 is actually a vlookup when I place the fubction in cell B1 it works fine. However if I place...
March 16th, 2009 10:19 PM
by rspowell Go to last post
3 91
call external function by DavidB
How do I convert a column of IP addresses to resolved DNS names (eg using the Windows command line function nslookup() - I wonder why this isn't a standard...
March 16th, 2009 10:04 PM
by DavidB Go to last post
2 78
Linking cells within workbook with ALL formating by ATworker
I know how to link cells in different sheets in the same workbook but I cannot get all of the formatting to link. Two worksheets. One is a subset of the...
March 16th, 2009 09:58 PM
by ATworker Go to last post
3 59
Vlookup to find a match in a string by KCK
Hello, I am trying to use vlookup to match the contents of a cell with a portion of a text string and return another cells data. Maybe using Index and Match...
March 16th, 2009 08:59 PM
by KCK Go to last post
6 55
Cell not showing all letters in text by DuPage
I typed BVE...Result in Cell is BE
March 16th, 2009 08:50 PM
by Shane Devenshire Go to last post
5 49
Post New Thread


Display Options
Showing threads 13201 to 13220 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 09: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.