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
Formatting a Cell in Worksheets by
can u format a cell in a worksheet to accept text? for example, input multiple comments that will be hidden from view .... and then click on that cell to open...
October 18th, 2003 03:29 AM
by RagDyer Go to last post
1 307
data validation & formulas by
Hello great folks who have saved me more than once: I have a data validation list (drop down list) in one cell, which offers a choice of 3 different...
June 16th, 2004 08:10 PM
by Go to last post
8 420
How do I copy a combo box? by
When I copy a combo box, the new box is synchronized with the first box. I.E, when a make a selection in the first box the same selection is made in the new...
June 16th, 2004 07:57 PM
by Vasant Nanavati Go to last post
1 99
Two formulas by
is there any way to combined...
July 10th, 2004 05:58 AM
by JE McGimpsey Go to last post
2 81
combining functions (VLOOKUP and SUM) by
I have an excel report that needs to be fed from an excel database. The best function I found was vlookup. However, vlookup only capture the result of one...
July 9th, 2004 09:58 PM
by Frank Kabel Go to last post
1 146
formula trouble by
I am having a problem with my spreadsheet. K5 =SUM(C5:J5) L5 =INT(K5)+HOUR(MOD(K5,1)/14.4)+(MINUTE(MOD (K5,1)/14.4)/100) example: E5=.30 F5=.30 I5=.15...
July 21st, 2004 01:37 AM
by Go to last post
3 218
Where did my macro recorder tool bar go?? by
It's missing!!! the little floating tool bar with the "Start Recording"/"Stop Recording" is gone. can anyone tell me where to get it back?? tks
August 8th, 2004 02:52 AM
by JulieD Go to last post
5 147
mistake by
August 8th, 2004 09:46 PM
by Go to last post
0 219
Extracting data from one row across multiple columns to produce a list by
I've got a worksheet containing the data extracted from an electronic questionnaire, each set of answers are contained in one column with each quesion answer...
September 8th, 2004 12:09 PM
by Paul Lautman Go to last post
5 330
Workdays (inc Sat) formula by
I need a formula to tell me the number of workdays between two dates, the problem being that Saturday I consider a workday. The NETWORKDAYS function obviously...
(Multi-page thread 1 2)
May 13th, 2004 03:45 AM
by Vasant Nanavati Go to last post
13 321
font size & length of data validation by
Excelperts! Is there any way to increase the font size of the data in a data validation list AND is there any way to lengthen the box so you can see more of...
April 20th, 2004 08:56 PM
by Go to last post
2 273
Word/Excel Linked Templates not saving on exit by
We have Word and Excel templates that were developed specifically for our company. The templates can be quite massive and are heavily linked. One of the...
November 5th, 2003 07:50 PM
by Go to last post
2 640
Need formula to post data from one workbook to another workbook by
I would like to be able to have data from a number of workbooks entered automatically into another workbook that has several worksheets. The data from other...
November 5th, 2003 08:34 PM
by Randall Roberts Go to last post
1 402
Count function by
I'm trying to count a column with some kind of criteria. Count if cell contains EL or HC or MM etc. Can it be done with the countif functions? Appreciate any...
November 20th, 2003 08:16 PM
by Jason Morin Go to last post
2 221
AARON by
can AND be put into an IF statment to make two arguments. Like If C2=C3 AND B2=B3 ,B3=0,... any suggestions
December 19th, 2003 12:39 PM
by Ken Wright Go to last post
5 175
3D formulas to pull across worksheets by
I have six workbooks with about 75 tabs each. I want to return the same values from each of the different tabs, consolidated on to one tab. Right now we are...
December 20th, 2003 11:44 AM
by Ken Wright Go to last post
2 264
percentages by
how do you calculate the percentage increase when only your base number is a negative value? And is there an excel formula that will do this?
December 24th, 2003 05:38 PM
by Go to last post
0 121
Lookup with multiple results by
Is there any way to use lookup formulas to have Excel find ALL of the values associated with the lookup parameter and somehow list them out? Here's an...
(Multi-page thread 1 2)
January 26th, 2004 06:19 PM
by RagDyer Go to last post
15 424
Data Validation Limits by
I used Data validation to custom zip code because I needed to limit the numbers. Some numbers started with 00 and if I used the number or text choice the...
April 15th, 2004 07:11 PM
by Peo Sjoblom Go to last post
2 317
September 29th, 2004 11:36 PM
by JMay Go to last post
4 122
Post New Thread


Display Options
Showing threads 261 to 280 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:43 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.