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
Compare 2 Worksheets & Find Matches by Mark
Can anyone tell me how to compare 2 worksheets and where there is an exact match of text in a cell to return a list of matches? Or in someway highlight the...
September 15th, 2003 05:30 PM
by Ashish Mathur Go to last post
1 521
filtered list by Pam Coleman
If I have done an advanced filter from a Master db and filtered a list of juveniles within a 3 month period, and in that list some of the juveniles are listed...
September 15th, 2003 05:29 PM
by Lance Go to last post
1 406
#N/A by Bob Phillips
thanks bob..that did it..thanks for taking time to help -----Original Message----- Steve, =IF(ISNA(vlookup_formula),0,vlookup_formula) -- HTH
September 15th, 2003 05:27 PM
by Bob Phillips Go to last post
0 443
Comparing ranges by ibeetb
I would like to compare Range A and Range B and then be able to identify or write out the items in A that re NOT in B. Keep in mind,, that range B has unique...
September 15th, 2003 05:20 PM
by john Go to last post
1 391
Networkdays calculations by Linda
Everytime I enter the formula, =networkdays(l5,k5) to calculate how many days an employee will receive his/her new rate of pay for the new fiscal year, it...
September 15th, 2003 05:19 PM
by Chip Pearson Go to last post
2 390
Formatting Column with all Caps by Dean
Is there anyway to format a column to take data from another column and convert it to all caps? I can get the data from another column but can't seem to get it...
September 15th, 2003 05:06 PM
by Andy B Go to last post
1 375
Extract a number from a cell of text by pnoel
I am trying to find out what formula I would use to extract the number from the following cell: Numer of items in truck,13625. Then place the number in...
September 15th, 2003 04:49 PM
by Ashish Mathur Go to last post
2 857
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 1,172
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 1,019
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 1,109
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 975
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 1,189
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 1,034
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 997
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 1,223
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 980
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 1,096
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 1,041
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 1,325
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 1,163
Post New Thread


Display Options
Showing threads 87761 to 87780 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 02:32 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.