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
Want a 3rd "results" sheet. by Beth
I'm just not that familiar with Pivot Tables, etc. Sorry for the stupid question. I've got Spreadsheet 1 that has a bunch of data and only a subset of it is...
October 8th, 2003 07:37 PM
by Beth Go to last post
2 395
DECTOBIN-function for decimal numbers >= 512 ? by Martin Saevik
Anyone knows how to use this function for decimal numbers from 512 and up ? I get the message #NUM! whene I try coverting decimal numbers 512 and above. Thanks...
(Multi-page thread 1 2)
October 8th, 2003 07:37 PM
by J.E. McGimpsey Go to last post
10 682
Normal View & Print Preview by Brad
I would to know if anyone could answer a question for me? I am using Excel 2000 with XP Operating System. When I set up a spread sheet and adjust my cells for...
October 8th, 2003 07:41 PM
by Brad Go to last post
0 936
More Logical Test Needed. by Krappo
The following formula is unacceptable as the Logical are more than...
October 8th, 2003 07:57 PM
by Krappo Go to last post
4 151
Functions and AutoFilter by Beth
I would like my function result to reflect the change in the worksheet when filtering using AutoFilter. For example, I have a COUNTIF function that returns...
October 8th, 2003 08:24 PM
by Peo Sjoblom Go to last post
3 134
Problem with Tabs by Robert B
I have recently upgrade to Excel 2002. I had excel spreadsheets that had multiple tabs from an older version (not sure which version) I was using Access to...
October 8th, 2003 08:37 PM
by Harald Staff Go to last post
2 476
PIVOT TABLE/CHART by Karen
Howdy. I created a pivot table from a spreadsheet of data. Then - from the pivot table, I created a pivot CHART. The pivot chart plots different products...
October 8th, 2003 08:40 PM
by Debra Dalgleish Go to last post
1 196
Is this possible??.... by Dan B
I'm pulling in names and addresses from a seperate workbook. I have 2 address lines. If the second address line is blank in my source data, is there a way to...
October 8th, 2003 08:43 PM
by dizzykid Go to last post
5 147
locking formula by puronombre
I have a column with this formula for a columd of data: IF ($I164$J164,2,0) and I need to insert a column between H and I so the formula changes to compare...
October 8th, 2003 08:57 PM
by Ken Wright Go to last post
3 108
vlookup woorkbook by anna
Is it possible to use VLookup to lookup an external sheet in a macro?
October 8th, 2003 09:47 PM
by Don Guillett Go to last post
1 128
how to change the color when i select drop-down list by AQAA
Hi,.. I have a drop-list on A1 and it contains (jan, feb, mar, apr,..etc..) and i want to change the color of $B$1, $B$2 when i select one of ...
October 8th, 2003 10:20 PM
by AQAA Go to last post
2 319
Tryring to find right formula by Joe
What I have is 5 columns of data A=Part number B=Cost C=Qty D=Quoted E=Comments 123 1.00 1 History 456 .50 7 ...
October 8th, 2003 10:27 PM
by Joe Go to last post
4 136
cell malfunction by Debbie
Please help - it is driving me crazy. I have a column of "total points" it is a simple sum of cells across the row from a-al and the formula is copies in all...
October 8th, 2003 10:35 PM
by ozzie Go to last post
1 117
EXCEL caused an invalid page fault by emetzger
I keep getting this fault and tells me to contact vendor. I created the sheet and its been working fine, now all the sudden I get this fault. Any...
October 8th, 2003 10:47 PM
by emetzger Go to last post
4 424
help by Scott Frickman
October 8th, 2003 11:12 PM
by Scott Frickman Go to last post
0 140
Don't want zeros to show by Jann
I am filling a column with a simple formula: =A13*D13 =A14*D14 How can I fix it so the zeros do not show when the there is no quantity in A columns? Thank you...
October 8th, 2003 11:20 PM
by Dave R. Go to last post
3 188
37684 Days by Bob
Example: A B C 1 3-Mar-03 7-Mar-03 4 2 4-Mar-03 -37684 3 8-Mar-03 37688 4 5-Mar-03 2-Mar-03 -3 The formula...
October 8th, 2003 11:44 PM
by Dave R. Go to last post
2 114
October 9th, 2003 12:22 AM
by Andy Brown Go to last post
7 121
Multiple worksheets by I'm lost
I am trying to combine data between many worksheets in 1 book. I want to select specific cells in each sheet and have them calculate on another sheet. I have...
October 9th, 2003 12:39 AM
by Go to last post
4 125
Closed workbook link by formula by bmg9611
Is there not a way to use this as a User Defined Function? ------------------------------------------------ ~~ Message posted from...
October 9th, 2003 12:44 AM
by Harlan Grove Go to last post
1 332
Post New Thread


Display Options
Showing threads 1061 to 1080 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 01:44 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.