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
creating a popup answer for an average range of cells by 1zipsails
How do I Roll over a range of cells and have their average show as a "pop up"?
August 24th, 2008 01:40 AM
by Barb Reinhardt Go to last post
1 62
Comparing/Matching two columns by shress
Hi, I am stuck with a problem. I need to compare two columns. one with ZIP and other with street names. A Single ZIP has numerous streent names. Is there a...
August 24th, 2008 12:22 AM
by smartin Go to last post
6 69
a formula to search for names in columns and then add the figures by Vercingetorix.I
I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then...
August 23rd, 2008 11:22 PM
by Vercingetorix.I[_2_] Go to last post
5 96
Average Time - With a Twist by WOLLAM
Thank you in advance for all the help. I have read the recent posts about averaging time, but none fit my question. I am trying to average a set of times...
August 23rd, 2008 10:10 PM
by WOLLAM Go to last post
3 72
Excel/Web by Mary Ellen
Why would someone want to post an excel spreadsheet to a web format? I don't know the answer to this question. -- Mary Ellen
August 23rd, 2008 09:54 PM
by Albert0 Go to last post
2 60
Locking worksheet labels and box sizes by Munchkin
I made an application in Excel 2007 for my clients to fill out with drop down boxes. I want to be able to lock the size and the labels on the application,...
August 23rd, 2008 09:25 PM
by pub Go to last post
1 76
vlookup doesn't work by mlhoward69
I am unable to do a vlookup between different workbooks. I does however work within the same workbook. Is their something I need to do to turn this...
August 23rd, 2008 09:02 PM
by L. Howard Kittle Go to last post
1 63
sum cells by Michael
Hi, I need a way to count the cells in column B in relation to column A. Both columns have numbers. I found this in the help file and adapted it...
August 23rd, 2008 08:05 PM
by Don Guillett Go to last post
1 86
find a correspond betwen the same words in two sheets diferents by rodrigo
I have one file where i have 10000 names. In another file i have some names (for example 150) that have a number associated. I want this numbers appears in...
August 23rd, 2008 08:02 PM
by JLatham Go to last post
2 71
Color of tracked changes by Nick Cumberbatch
I recently started to use Excel 2007 I have a shared worksheet which I sent to a colleague for review. After I received it back, and looked for his changes...
August 23rd, 2008 07:32 PM
by Sheeloo Go to last post
3 54
Is there a time zone conversion function in Excel? by Scott
Specifically, I was hoping for a function in Excel, when provided the time zone, date and time, would return GMT, or universal time and date. I know this is...
August 23rd, 2008 06:25 PM
by Peo Sjoblom Go to last post
1 70
Asterisk by geminitwin
Everytime I use the multiply function (*) asterisk, it repeats itself. I then have to delete all but one everytime. Very frustrating when working in...
August 23rd, 2008 06:20 PM
by geminitwin Go to last post
4 59
Repeating Asterisk by geminitwin
Whenever I type an asterisk (*), it repeats itself
August 23rd, 2008 06:07 PM
by Dave Peterson Go to last post
1 59
Find the First of the Month after 60 days by NeSchw6G
I need help making a formula to use the date in cell F3, add 60 days and then find the first of the following month. i.e. The date given would be 8/21/08...
(Multi-page thread 1 2)
August 23rd, 2008 05:46 PM
by Rick Rothstein \(MVP - VB\)[_1174_] Go to last post
11 115
Multiple Worksheet reference in a formula by Mike Maguire
I'd like to collect the value from all of the "A3" cells in a series of worksheets in one workbook. Like: =Sheet2!A3, =Sheet3!A3, =Sheet4!A3, etc, but...
August 23rd, 2008 04:34 PM
by Gord Dibben Go to last post
1 75
Sorting array function explanation please by Ken Johnson
I searched previous posts for a formula that could sort a column of text values and found this gem, which I have adapted to sort a range named AList. The...
August 23rd, 2008 04:20 PM
by Ken Johnson Go to last post
4 53
Check box logic question by Ailsa02
How do I create a series of check boxes that when you check the second box, the first box will automatically uncheck?
August 23rd, 2008 04:04 PM
by ggraves1968 Go to last post
4 99
comment by Sanjiv
Hello, I want the comment made in sheet 1 & cell A1 , to appear elsewhere in the same workbook but in sheet 2 where the cell value and the comment from Sheet...
August 23rd, 2008 03:46 PM
by Shane Devenshire Go to last post
1 51
date after another date by Gator Girl[_2_]
I'm setting up a spreadsheet which alerts us when a certain assignment is due. In cell a3 is the start date. I want to look at the start date, add 360...
(Multi-page thread 1 2)
August 23rd, 2008 02:35 PM
by Bob Phillips[_2_] Go to last post
11 110
Validate a total of a row by Charles
I have this, simplified, spreadsheet: Name A, Name B, Name C, etc in columns B1 to M1 In row 2 to row 11 are Work Functions. The staff have to enter a time...
August 23rd, 2008 02:22 PM
by igorek Go to last post
1 90
Post New Thread


Display Options
Showing threads 21241 to 21260 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:17 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.