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
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
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
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
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
#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
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
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
Change Case by Gary Ballance
I have the same question. Is there an easy way to change data in an entire spreadsheet from lower to uppercase?
September 15th, 2003 05:34 PM
by Don Guillett Go to last post
2 329
Error #VALUE with TEXT(A1;"[HH]:mm") when changing regional settings by Thierry De Bleye
I got the answer , the danes use :mm instead of :mm do somebody knows how to get a list of used time format per countries ? Regards Thierry
September 15th, 2003 06:20 PM
by Harlan Grove Go to last post
1 393
attaching website links to excel file by lori
I am creating an excel file that I want to insert website links that I can access right from the excel file by double clicking them. I was able to do it in the...
September 15th, 2003 06:26 PM
by JM Go to last post
1 373
Calander by John Mansship
Let me rephrase my Calander question. Does anyone know how to copy the date clicked on the calender to a cell? Example: In Excel VB, I inserted a calander...
September 15th, 2003 06:30 PM
by John Manship Go to last post
2 320
Vlookup or Offset question by Bill
Not sure how to accomplish this so i will attempt to explain. Any assistance would be greatly appreciated! Sheet1 - consists of four columns of data for...
September 15th, 2003 06:34 PM
by Bill Go to last post
2 305
concatenating cells by Rosson Cain
Hello, I need to concatenate two cells together. The problem is that the first cell always needs to be 6 digits long (e.g. if the entry is 23456 it need to...
September 15th, 2003 06:50 PM
by Cecilkumara Fernando Go to last post
2 298
Examples needed by JM
Anyone know a site (library) in MS with examples?
September 15th, 2003 06:51 PM
by [email protected] Go to last post
1 426
Bolding specific text in a formula by Scot Rundell`
I am concatenating 3 cells, '=a2&b2&c2' and with the result of this, i need the text that is in cell b2, to be bold, so that i can get an answer of 'This is...
September 15th, 2003 06:53 PM
by Harlan Grove Go to last post
4 444
Formula by pnoel
I need to extract a number from a text string, then list the number in a diffrent cell. Please Help. pnoel
September 15th, 2003 07:04 PM
by Harlan Grove Go to last post
3 417
How to prevent function range auto-modification ? by Manuel
Hi, I've discovered a feature that I find quite anoying: when I write something in a cell next to a range of cell used in any function, this range is changed...
September 15th, 2003 07:09 PM
by Harlan Grove Go to last post
2 661
Sumif of cells less than a system date by CJE
A B C 1 1/31/2003 2/28/2003 9/15/2003 2 1 1 1 =SUMIF(a1:c1,"=TODAY()",a2:c2) Should be simple but the formula...
September 15th, 2003 07:11 PM
by Peo Sjoblom Go to last post
1 378
Countif using Criteria "<>""" ? by RagDyer
Thanks Tom, Never heard of "UsedRange" concept before. (Lots'a things I've never heard of !) But are there any other functions with similar...
September 15th, 2003 07:11 PM
by RagDyer Go to last post
0 528
Calculating Duration by Barbara
Hi, I am trying to set up a spreadsheet calculation where I determine the duration in days between a date entered in Column A and a date entered in Column B....
September 15th, 2003 07:11 PM
by Barbara Go to last post
2 355
Post New Thread


Display Options
Showing threads 21 to 40 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 12:17 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.