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
count number of dates in range by Sunflower
In column A, various contractor names are listed. In column B, completion dates have been entered for when their projects were completed thoughout the year....
March 24th, 2010 07:07 PM
by Francis Go to last post
2 150
Excel not pasting the formula or reference by Lindsey[_4_]
I am trying to take a worksheet "apple" and copy it to a new workbook "banana". It works for another worksheet but not this one. I am highlighting the whole...
March 24th, 2010 06:51 PM
by Luke M[_4_] Go to last post
1 133
Date Formatting by DaveMoore
With the help of Biff yesterday I entered the formula ="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy") which returned Closing Balance at 31-Mar-2010 exactly as I...
March 24th, 2010 06:41 PM
by Daryl S[_2_] Go to last post
2 124
Sumproduct? by Hannah
Good Afternoon Please could someone help.... I have a monster spreadsheet that tracks recruitment numbers and as part of our monthly reporting i need to...
March 24th, 2010 05:49 PM
by Glenn[_6_] Go to last post
1 165
Too many rows highlighted by RLD
When I click on a row, multiple rows are automatically selected. This happens to all of my sheets in my workbook. Do I have a bug? How do I fix this?
March 24th, 2010 05:33 PM
by Mike H Go to last post
1 173
Data Validation drop-down width, with named range source (XL03 and by ker_01
I have a data validation cell (List) that uses a named range as the source. The named range is: GraphLocList=Sheet2!$B$1:$J$1 The list is mostly 3-letter...
March 24th, 2010 04:31 PM
by T. Valko Go to last post
4 167
Date Calculation problem by petedacook
Hello, I have a work sheet with "JIRA" priority levels and dates the JIRA was created. Each priority leve allows a certain number of days to be complete...
March 24th, 2010 03:08 PM
by petedacook Go to last post
3 159
In new Office 2007 EXCEL, can more the 8 IF statements be used? by MORRIPJ
In EXCEL 2003 was limited to 8 IF statements (or other functions). Does EXCEL 2007 allow more than 8? Just started using EXCEL 2007 yesterday.
March 24th, 2010 02:58 PM
by Mike H Go to last post
1 154
Data Validation List - Can I have multiple ranges displayed? by Jim
I am using Excel 2007. I have two named ranges: Customer_ID and Customer_Name. I currently have a data validation list with the source '=Customer_ID'. This...
March 24th, 2010 12:46 PM
by Jim Go to last post
4 163
Data Connection Wizard by Richard Horn[_2_]
Need some help with the Data Connection Wizard. We have a database which is on one of our internal servers and it is accessed by a url. Can I, or how do I...
March 24th, 2010 12:16 PM
by Richard Horn[_2_] Go to last post
0 143
Hidden column by showiesg
A column is hidden. I can only see this column in the print preview mode. I tried to unhide it using the usual method of Format , Column and Unhide but its...
March 24th, 2010 11:27 AM
by arealbasketcase Go to last post
1 100
formula question... by 000ani
Just wondering if this is a valid formula... =(B5*C5)+(B6*C6) -- curiouscash
March 24th, 2010 07:14 AM
by Joe User[_2_] Go to last post
2 138
Convert Date in Text to month and Year by Excellency
I am trying to convert text to month and year. In the cell it displays as 07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it adds...
March 24th, 2010 03:42 AM
by T. Valko Go to last post
3 145
Matching two sets of data? by Zuo
Hi, I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C...
March 24th, 2010 03:25 AM
by Zuo Go to last post
5 136
file names by Mr Widget[_2_]
Is there a way I can collect multiple file names from within a folder and get them to display within a excel. If it involves using a macro I haven't been...
March 24th, 2010 02:06 AM
by Ashish Mathur[_2_] Go to last post
3 171
find all instances of a search item and put result in a single cel by Art
Is it possible to search a column in one sheet for all occurrences of a search item and then put the result of that search in a single cell on a second...
March 24th, 2010 01:46 AM
by Ashish Mathur[_2_] Go to last post
5 184
Automating a Worksheet by hankb
I have a lengthy worksheet which requires a single numerical input on A1 and it produces a single numerical output on F30. It has numerous formulas. I would...
March 23rd, 2010 11:48 PM
by Max Go to last post
6 138
Calculating Resolution Rates by Rhonda Urbanczyk
I'm trying to calculate resolution rates from our help ticketing system in Excel - I've tried several recommendations from here and they're not counting...
March 23rd, 2010 11:41 PM
by Rhonda Urbanczyk[_2_] Go to last post
4 111
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!! by gamn
I have a problem using AND function on date data. In cell A2, I have date date "10/1/2009". In cell A3, I have AND fuction as =AND(A2=10/1/2009,...
March 23rd, 2010 11:22 PM
by Bernard Liengme Go to last post
5 146
Justify across selection by bfloyd
I found the "center across selection" formatting function but I really need to "justify across selection." Any ideas? -- bfloyd
March 23rd, 2010 09:02 PM
by Ziggy Go to last post
1 141
Post New Thread


Display Options
Showing threads 1861 to 1880 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 10:05 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.