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
Order form by Jamie
I'm creating an order form and I want to automatically copy information from a database that is on another sheet in the workbok. After I enter the Item number...
September 16th, 2003 11:02 PM
by Intruder9 Go to last post
1 548
Fonts of Drop Down Forms by Stijn
When using the forms' drop downs, how can I modify the font size/type ... ?
September 16th, 2003 11:12 PM
by s-o-s Go to last post
3 581
"Sumif"or "if" ...followup question by Peter
Thanx, Paul, that worked! But I have another question. If I get a "NO" and enter that in the RSVP column, can I get the "balance due" to blank...
September 16th, 2003 11:24 PM
by James S Go to last post
1 328
ROUND function or custom format by Lucy
i'm trying to round to the nearest 100th eg 1436 to 1400, or 1475 to 1500. i would like to use the custom since if we use ROUND, we don't have the numbers yet...
September 16th, 2003 11:42 PM
by Harald Staff Go to last post
1 428
Solving for Coefficients of a polynomial by Dan Mertens
Is there a function in Excel that can return the coefficients of a polynomial from a set of X values and a set of Y values? I know you can get a trendline...
September 17th, 2003 12:04 AM
by Bernard V Liengme Go to last post
1 341
Date Function: How to determine number of Saturdays in a date range by Dan Picciotto
I'm trying to create a sprdsht that will give me the number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't...
September 17th, 2003 12:46 AM
by Daniel.M Go to last post
2 621
Macro by Shane
How do I save a macro to a floppy disk so that I may copy the macro to another computer?
September 17th, 2003 01:07 AM
by Don Guillett Go to last post
1 294
Pivot Table Using Multiple sources by td
I am trying to build a pivot table using more than 1 file/worksheet. The files have the same column headings. I can not combine the 2 files as Excel...
September 17th, 2003 01:28 AM
by Debra Dalgleish Go to last post
1 676
Dates parameters/logic by BILL
Not sure how to ask this and I am very much a beginner in EXCEL. I am trying to find a way to track periodic reviews that are required every time an individual...
September 17th, 2003 02:13 AM
by BILL Go to last post
0 308
vlookup by ken Barber
I have two Workbooks. They both have the common reference numbers for various products. Workbook A lists the weights of products in rows adjacent to the...
September 17th, 2003 02:33 AM
by CLR Go to last post
1 289
LOOKUP Formula by SFrick
I'm having some trouble with a lookup formula. In row 6 J through Z I have numbers from 1 through 17 In row 8 J through Z I have random numbers for...
September 17th, 2003 02:41 AM
by Dave Smith Go to last post
3 397
finding Specific day in a named range by DK
I am OK with some Adv Beg excel techniques. But I am not sure how to get the next step done. I do a monthly schedule in grid format in excel, names down the...
September 17th, 2003 03:28 AM
by Dave Smith Go to last post
1 390
Compare 2 columns in a worksheet. by Neeraja
Hi, I need to compare 2 columns in a worksheet and see if the values are similar. Eg: A : B X-001 X-001 X-024 X-024 x-090 ...
September 17th, 2003 03:42 AM
by Dave Smith Go to last post
2 578
Totals in Days, Hrs and Minutes by Syd
247.00 5.00 125.00 640.00 535.00 610.00 186.00 785.00 265.00 380.00
September 17th, 2003 03:58 AM
by Ron Rosenfeld Go to last post
7 332
Creating Formula (Date) by TJ
Does anyone know of a way to create a formula for adding time (i.e. years-months-days) onto a date? I'm a training manager looking for a formula to calculate...
September 17th, 2003 04:02 AM
by Ron Rosenfeld Go to last post
2 698
calculating number of days between two dates by sandy
On an Excel spreadsheet, how do I calculate the nubmer of days between two dates? I previously used the DAYS360 function, but now I need to calculate based on...
September 17th, 2003 04:23 AM
by Myrna Larson Go to last post
3 631
E-Mail Hyperlinks in Excel by Ray
If an e-mail address is entered in a cell, Excel automatically creates a hyperlink. How can this automatic hyperlink creation feature be disabled? (After...
September 17th, 2003 04:30 AM
by Dave Peterson Go to last post
4 324
Excel 2000 255 character limit by Shannon
I have data that I need to import into Excel, then export to .prn (because .prn is the only text format that seems to be able to save formatting) and when I do...
September 17th, 2003 04:41 AM
by Dave Peterson Go to last post
1 566
pivot chart formatting? by hugh jass
Hello All, I am having fun getting pivot tables to show me simplified views of my data. Pretty happy with everything, except for minor details on formatting...
September 17th, 2003 05:02 AM
by Jon Peltier Go to last post
1 625
watermark by Brenda
I know I have seen this before so please excuse me for requesting it again. But how is a watermark inserted into an excel worksheet... Thank You in Advance for...
September 17th, 2003 05:08 AM
by Ron de Bruin Go to last post
3 347
Post New Thread


Display Options
Showing threads 121 to 140 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 06:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.