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
delete all text to the left of??? by Sheila
I want to put a list in column A that will be the paths to the files I have, (ie c:\Program Files\Common Files\Microsoft\Stationery\signature.htm), but I wqant...
January 25th, 2005 06:30 PM
by Harlan Grove Go to last post
3 89
how do i calculate my mortgage payments by mike
what sort of funtions are available to assist me with my mortgage payments thx mike
January 25th, 2005 06:42 PM
by Gord Dibben Go to last post
3 207
dynamic combo boxes by tjb
OK, basically what I want is one combo box with three options: "Yes", "No" and "Void and Reissue". When the user selects "Yes" from the first combo box I want...
January 25th, 2005 08:33 PM
by Tim C Go to last post
2 320
How do I find a mode while disregarding a specific cell value? by glasskit
I would like to create a function that finds the mode of a range of cells, but does not consider a particular value in the range.
January 25th, 2005 08:47 PM
by Peo Sjoblom Go to last post
1 93
Separating data ( 1 time range) in one column by Steve
I have the following cell: 0800-1000 I need to ref 0800 in one column & 1000 in another, to ultimately subtract 0800 from 1000 to get 2 hours. What function...
January 25th, 2005 08:59 PM
by Steve Go to last post
2 107
change date function format in footer by Tori
I would like to change the automatic date function in my footer to ie. January 25, 2005 instead of 01/25/05??
January 25th, 2005 09:18 PM
by Gord Dibben Go to last post
1 274
Data Validation by Tony
One a drop-down box is created for selection can it populate multiple cells with its selection. Can I create a table with 3 columns and populate 3 cells when I...
January 25th, 2005 10:44 PM
by Debra Dalgleish Go to last post
2 83
Custom Number Format... by whitmore0112
I have a number/text that I want to apply a custom format to, but am not sure if it is possible. The number/text starts as 12K52E1, and I would like to apply...
January 25th, 2005 11:11 PM
by Ken Wright Go to last post
2 164
Need a Macro by denwah73
Would anyone have a macro (or suggestion) that can decipher which numbers in a list will calculate to a specified total?
January 25th, 2005 11:19 PM
by Rob van Gelder Go to last post
1 139
Count Unique Names in list w/ Additional Criteria? by Nodak
I have been able to use the formula below to count the "unique" company names in list, but also wanted to use additional criteria such as Unique company names...
January 26th, 2005 12:15 AM
by Jason Morin Go to last post
1 196
Lookup names to get data by Ed Wesemann
I have two name and address lists. List A is the larger list (13,000 rows) and has names and telephone numbers along with other data. List B is smaller (5900...
January 26th, 2005 12:19 AM
by Aladin Akyurek Go to last post
1 72
Does the cell have a number? by Fletcher
I want a formula that will tell me if a given cell has a number in it, so it evaluates the type of data. I looked in the help files and couldn't figure this...
January 26th, 2005 12:23 AM
by tjtjjtjt Go to last post
7 155
Calculate time difference to the half hour by Ken Ivins
I am creating an employee time sheet that the put in their starting time and ending time (From a drop down list). I would like Excel to calculate the amount of...
January 26th, 2005 12:42 AM
by Ron Rosenfeld Go to last post
5 335
Multiple Work Sheets by Daniell
I have a project that involves 6 worksheets all in the same workbook. What I need to do is get data from all the worksheet by a part number which is common...
January 26th, 2005 03:08 AM
by Otto Moehrbach Go to last post
4 228
text and numbers by sam
I have a text and number string that I use to link my excel worksheet to a PLC for extracting values. The string is: =RSLinx|demo2!'gauge_offset_y', where 0 is...
January 26th, 2005 12:05 PM
by sam Go to last post
0 65
How do I test a cell for part of text by East London
How can I test only part of the text in a cell and if true return value of a different cell
January 26th, 2005 12:36 PM
by Bob Phillips Go to last post
1 74
vlookup data hidden within worksheet by
Hi, Can anyone explain why it is that a vlookup table automatically 'hides' itself within a worksheet that utilizes the vlookup function but the vlookup table...
January 26th, 2005 01:09 PM
by Go to last post
0 563
Vlookup not returning correct value by Mandy Brookes
We have a file which is updated monthly containing 'Vllookups' combined with 'IF, ISNA' formulae. This has worked successfully for many months but suddenly...
January 26th, 2005 01:12 PM
by Bob Phillips Go to last post
1 186
calculating timesheet, time-in/time-out = total hours & minutes, . by Davidfrost
"Steve Lindsay" wrote: Need to create an Excel Timesheet that calculates the hours and minutes worked daily, based on the time-in/time-out. Then allow the...
January 26th, 2005 02:37 PM
by Davidfrost Go to last post
0 213
How to : SUM - IF formula by bruno
Can anybody help me out here ?=20 Maybe a little example to explain a bit ... Let's say I have the following data...
January 26th, 2005 02:54 PM
by Bruno Go to last post
2 100
Post New Thread


Display Options
Showing threads 10181 to 10200 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 08:10 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.