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
Calculating age from birth dates by John Nall
I need help with a similar problem. I am making a spreadsheet with the names, DOB, and DOD dates for persons in a church cemetery. I am having trouble with...
September 15th, 2003 04:39 AM
by Myrna Larson Go to last post
2 689
Comment boxes by Martina
Hello experts, If you have a large spreadsheet set to view at say 60% how do you make the comment boxes readable?? kind regards Martina
September 15th, 2003 06:51 AM
by Jon in Ohio Go to last post
1 721
almost DSUM, but is there another database - criteria funcion? by Lance
Have you tried Sumif() sumif(b1:b100,"=A",c1:c100) Lance -----Original Message----- I have a problem with excel. I have a list of expenses, sorted by...
September 15th, 2003 08:05 AM
by beppe005 Go to last post
1 676
Don't show Zeros by Morpheseus
I know I've seen this somewhere but I cannot find it. I looked all day with no luck. I have to ask what I know is a simple question :( I did up an invoice. ...
September 15th, 2003 09:42 AM
by Andy Brown Go to last post
2 744
Trim function limitations by Boz.theale
I have imported text from another application and want to convert the contents of cells into a continuous string - ie like trim but removing all spaces,...
September 15th, 2003 09:45 AM
by Andy Brown Go to last post
2 798
excel custom menu by Lynn
Thank you! A problem is that when a user click on a chart in the workbook, the menu is no longer showing on the commmandbar. Until user clicks somewhere else...
September 15th, 2003 10:16 AM
by Andy Wiggins Go to last post
2 763
MS.Excel vs Works Spreadsheet by Excel Gure
I am confused, why does Microsoft have two excatly alike products on the market? Office XP and Ms. Works? Works is is around $50 and MS Office XP sells for...
September 15th, 2003 11:30 AM
by Chip Pearson Go to last post
3 626
How do I extract specific data out of a cell to another cell by red bioroid
Anone one got any ideas on this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet...
September 15th, 2003 12:27 PM
by Ron Rosenfeld Go to last post
1 459
split worksheet by patrick072040
Can you split a worksheet in half vertically, but scroll vertically on both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It...
September 15th, 2003 01:00 PM
by Jim Rech Go to last post
3 530
Time-of-day Average by GBL
Hi: Cell designations are H8:H51. I used your entire formula. But didn't understand where you got the "hhmm" designation. My military-time cell examples a...
September 15th, 2003 01:03 PM
by Bob Phillips Go to last post
2 537
sumif function by Dee
I am trying to use sumif function to add up a range in excel using color as "CRITERIA". Is this possible? or is there another way to go about it? Thanks.
September 15th, 2003 01:24 PM
by JMay Go to last post
5 373
Numbering rows for sorting by Dan
If i understand you correctly try this: Say you want your numbers from A1 to A1000 In A1 input the number 1. In A2 input the number 2. Hilight (select just...
September 15th, 2003 02:08 PM
by Andy B Go to last post
1 452
Combo Box & Linked Workbooks by D B
I have two questions: 1. Drop Down Boxes: Is there a way to actually convert a cell(s) to be a combo box? The only way I have been able to achieve this is...
September 15th, 2003 02:42 PM
by Arvi Laanemets Go to last post
1 482
Excel column headings by Wayne
EVery time I open EXcel for a new worksheet, the columns are shown as numbers, the same as the rows. How do I change it so that they are letters? Makes it much...
September 15th, 2003 03:01 PM
by Andy B Go to last post
1 444
Notes by Pinda
Is it possible to have a note attached to a phrase rather than a cell? So where ever that phrase may be duplicated within a worksheet, it will carry the same...
September 15th, 2003 03:06 PM
by Andy Brown Go to last post
1 440
Excel "IF" function problem by Johan
Our domain uses group policy to configure user rights on the workstations, and it appears that on certain machines, or rather under certain user profiles, the...
September 15th, 2003 03:08 PM
by JM Go to last post
2 504
VLOOKUP problem by Crystal
I'm using the VLOOKUP worksheet function and I'm having some issues with the result affecting my other formulas. Instead of the lookup returning "#N/A" when it...
September 15th, 2003 04:03 PM
by Anon Go to last post
1 440
Pivot range update on mulitple tables by aablank
I am using the same range for a number of pivot tables. If I add to the data, is there a way to update all of the tables at once? Right now I need to update...
September 15th, 2003 04:12 PM
by aablank Go to last post
0 444
excel.exe program error by Dawn
I have a spread sheet that I'm running macro's in, and it keeps coming up with the error message "excel.exe has generated errors and will be shut down...
September 15th, 2003 04:39 PM
by John Wilson Go to last post
1 383
Selecting from a list by Mike
I want to be able to select from a list based on the contents of another cell. For example, in A1 I can select the value from a list of 4 options. Cell B1 has...
September 15th, 2003 04:46 PM
by Anon Go to last post
1 485
Post New Thread

Display Options
Showing threads 1 to 20 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 04:38 AM.

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