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 Reverse Sort Order Last Post Replies Views
Addition base on condition by 68magnolia71
Hello you all, I have the following problem with a production sheet: A B, C, etc =the names of thr products next column = production time next column =...
April 15th, 2005 08:39 PM
by 68magnolia71 Go to last post
4 100
time differences in a column by 68magnolia71
Good evening everyone, On this forum I've been given (3/29/2005, Bernie Deitrick) formulas to calculate time differences in column C base on the word "start"...
May 9th, 2005 09:46 PM
by 68magnolia71 Go to last post
3 99
Last text value in a column by 68magnolia71
Good evening, On this forum I've been given formulas by several persons that give the last NUMBER value in a column. I tried to adapt them for TEXT. One of...
April 19th, 2005 08:50 PM
by Domenic Go to last post
1 67
time differences in a column by 68magnolia71
Need to calculate the difference between two cells in a column. Exemple A B C Start 1 date/time open ...
March 31st, 2005 06:19 PM
by Bernie Deitrick Go to last post
7 238
mag-text in merged cells-automatic row heigh by 68magnolia71
Bernie, sent me a macro (Jim macro) that automatically sets the row height based on text length, given the column width. The works well. Unfortunately I have...
(Multi-page thread 1 2)
April 9th, 2005 08:43 PM
by Dave Peterson Go to last post
10 194
Condtional formatting by 68magnolia71
Hello everyone, I'm looking for a condtional formatting formula based on 2 conditions. The conditions are based on a text that are in 2 different cells in the...
April 15th, 2005 09:46 PM
by 68magnolia71 Go to last post
2 90
Sumproduct by 6pak
I can not get the sumproduct function to work properly. I have read a number of threads and followed the example to a tee, but function will not work. Here...
February 21st, 2007 03:07 PM
by Duke Carey Go to last post
4 74
worksheets linking in Excel? by 703
I made a worksheet for tracking manpower assignments. Once I had it done, I copied that worksheet 15 times, named each tab to an employees name. When I cut...
August 25th, 2006 06:48 AM
by Max Go to last post
1 92
Maintain - AutoFilter and Subtotals selection/layout? by 7777
Hello, in utilizing Excel's 2 built in tools of: File - Filter - AutoFilter ....and... File - Subtotals is it possible to keep the specified...
October 1st, 2009 11:46 PM
by 7777 Go to last post
0 109
#NAME? by 77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
August 28th, 2008 06:54 PM
by 77Debbie77 Go to last post
5 132
=SUMPRODUCT Col E = B, Col F = blank by 77Debbie77
I am using the formula below to try and get the total count of Col F when it is blank (Col F is text data and some employees did not enter a comment) when...
August 28th, 2008 09:14 PM
by Dave Peterson Go to last post
7 139
two sided printing by 789
I have a 200 page worksheet to print. I like the idea of putting it in 100 pages, using both sides of the paper. Excel 97 had this feature. I now have Excel...
May 30th, 2004 08:22 PM
by David McRitchie Go to last post
2 290
How do I get cell data in multiple Excel files into one summary fi by 78degreesinHI
Anybody care to help? Much Mahalos (thanks very much) in advance for trying. I want to be able to gather data from specific cells within multiple...
August 29th, 2006 02:05 AM
by Cbus Go to last post
4 207
WORKBOOK INDEXING by 7of9
I have a multipage workbook (40 pages) and want to set up an Index page. I tried hyperlinking, but when I copy it for the following year's use, the...
February 17th, 2009 09:12 AM
by Pecoflyer[_195_] Go to last post
1 127
vlookup character limitations by 808bobby
is vlookup limited in retrieving cell contents greater than 255 characters? I have a vlookup function that is properly retrieving the cell, but the text...
February 19th, 2010 12:30 AM
by Dave Peterson Go to last post
1 123
time format by 818jaime
Can some one please tell me how to format time exported from Avaya IQ. example time exported 00:01:23 I need to format to only read 1:23 in excel 2007. Thank...
May 7th, 2010 04:23 PM
by 818jaime Go to last post
4 100
META Tags Explained And How To Use Them For Ranking by 88059355
The META tags are used to provide extra information about a web page. There was once a time where a good search engine ranking could be achieved by simply...
January 16th, 2008 05:25 PM
by 88059355 Go to last post
0 72
vlookup, two worksheets by 88Keys
I want to take data from one worksheet and put it into another using vlookup. I have been able to do this in Lotus 1-2-3 by specifying the entire path of the...
July 2nd, 2004 06:04 PM
by 88Keys Go to last post
2 108
Can you make cells in Excel flash or twinkle? by 8buds4u
I was wondering if there was a way to make "text" in a field of an Excel spreadsheet to flash or twinkle on & off.
March 29th, 2005 05:35 PM
by Harald Staff Go to last post
1 148
Dates by 904allen
I have a sheet that figures dates, it can go back 3 years the user now puts in the dates for each year needed, it looks like this 4/1/05 to 12/31/05 ...
March 27th, 2008 01:58 PM
by Pete_UK Go to last post
9 100
Post New Thread


Display Options
Showing threads 541 to 560 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 07:22 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.