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
autosum by
is it possible to autosum from 2 different sheets
October 2nd, 2003 07:50 PM
by Paul B Go to last post
1 123
Pivot Table "Show All" Check Box missing in Excel 2000 by
Hope someone can help with this. A large array of data I have is sorted and filtered using a pivot table. Works well in XL2002 & XP, being able to uncheck...
May 7th, 2004 03:45 PM
by Curtis Go to last post
2 188
Date counting formula by
What is the formula to count the number of days only between two dates
June 9th, 2004 10:49 PM
by Frank Kabel Go to last post
2 65
Q: locking some, but not all, properties of a cell by
Folks, Is there a way of locking the format of a cell, but not the contents? We have a shared yearly planner type spreadsheet in which cells are coloured to...
July 12th, 2004 04:35 PM
by MikeC Go to last post
2 63
Tally matches?? by
Would like to have a worksheet that keeps a running tally of the number of times a specific value occurs in several other worksheets. Is there a way to count...
July 14th, 2004 04:31 PM
by Go to last post
2 86
Gotit by
Nevermind, got it
July 16th, 2004 12:23 AM
by Don Guillett Go to last post
1 73
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20 database which is multiplied by a specific volume. When I=20 have no pricing in the database for a product...
July 22nd, 2004 10:51 PM
by Aladin Akyurek Go to last post
2 60
Date and formulas by
Hi I have a spreadsheet with a load of dates when a particular service was carried out. I would like to create a formula in another cell with a date which is...
August 9th, 2004 04:24 PM
by Norman Harker Go to last post
9 98
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 139
Spell check and protected worksheet by
Does anyone know how to enable spell check when a worksheet is protected? I've tried a number of different options, but whenever I protect the worksheet I...
April 8th, 2004 09:23 PM
by Go to last post
2 151
Summing Filtered Rows by
Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the...
March 29th, 2004 09:22 PM
by Frank Kabel Go to last post
4 109
comparing values for matches by
I would like to set up a cell to look for a number match for a cell next to it in another worksheet and over many columns and rows. Does the value in...
October 27th, 2003 10:55 PM
by Go to last post
2 103
auto filter macro by
I want to use auto filter or some other device to hide those rows whose first column has a zero in it. I would like to come up with a macro that automatically...
November 23rd, 2003 10:16 PM
by Don Guillett Go to last post
4 179
Average based on two rows and two criterea? by
Caution: I have a tendency to go to San Fran by way of Miami. With that disclaimer... In FIRST column to right of Grand Total, enter: =IF (e10,1,0) NEXT...
December 12th, 2003 04:16 PM
by akyurek Go to last post
2 105
vlookup table_array reference listed in another cell by
If anyone can help with this vlookup question I would appreciate your input. I am trying to place in the vlookup...
December 12th, 2003 06:25 PM
by Paul Go to last post
2 103
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 86
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 190
excel auto save settings not retained by
I'm running XP Home and Excel 2000. My auto save settings (interval and not requiring a prompt to save) are not be retained after closing and reopening...
February 15th, 2004 08:33 PM
by Peo Sjoblom Go to last post
3 176
long formula by
Could you suggest a way to trim this formula...
April 23rd, 2004 07:11 PM
by Jennifer Go to last post
9 93
List Boxes by
Hi All, How can I make a list box that has a series of values that are based on the values selected in another list box. Example List Box 1 A B
September 14th, 2004 10:27 AM
by mangesh_yadav Go to last post
1 137
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 11:43 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.