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
File Creation Date by Thomas M.[_2_]
Excel 2007 I have a need to insert the file creation date into a workbook. I could swear that I've done this before, in earlier versions of Excel. ...
January 5th, 2010 02:15 AM
by Thomas M. Go to last post
3 121
Autofill problem in Excel Office 2007 using Windows 7 by SteveG
Weird thing... the app is set up to allow auto fill... but dragging only copies ccontents... furthermore, the "series" selection in the drop down menu is...
January 5th, 2010 01:19 AM
by Gord Dibben Go to last post
1 109
How do I extract the decimal places from a number in excel? by Marli
I need to produce a spreadsheet that rights the example: 1,245.89 as one two four five 89. I've tried the left and right formulaes and the len one but the...
January 5th, 2010 12:51 AM
by Ashish Mathur[_2_] Go to last post
3 138
formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another by Michelle
I am working on a spreadsheet and need help developiung a formula (my excel knolwedge is very basic).... In y2, I want a formula that subtracts w2 from x2 but...
January 5th, 2010 12:43 AM
by Gord Dibben Go to last post
3 149
matching and entering data by MarkyMark
Hi, will try to explain my problem as best as I can. I have 2 worksheets. Each worksheet has in column A a list of unique customer numbers. Sheet 1 has...
January 5th, 2010 12:28 AM
by Ashish Mathur[_2_] Go to last post
3 142
Timetable problem by Albert.Harmse
Hi I need to calculate the time worked for the employees on a weekly and monthly basis, but knowing all employees they are not always at work. So we use...
January 5th, 2010 12:19 AM
by Ashish Mathur[_2_] Go to last post
4 141
calc. an anniversary date(50 years) after marriage date in excel by datakop
I need to be able to accurately calculate an anniversary date. For example I need to add 50 years to the marriage date e.g October 22 1960 and get October...
January 5th, 2010 12:03 AM
by Ashish Mathur[_2_] Go to last post
3 115
Look up if a value from an array "A" is in either array "B" or "C" by Francisco Rodriguez[_2_]
Hello: I got a consolidated list of items, "C", which is the latest update of items I need to analyze. In the past I had received two previous lists "A" and...
January 4th, 2010 11:49 PM
by Max Go to last post
8 123
Creating a duplicate workbook without values by JTG
I created an inventory management workbook for 2009. I'd like to make one for 2010, complete with all headers and formulas but with the data fields blank. ...
January 4th, 2010 11:23 PM
by Gord Dibben Go to last post
2 114
Weekly Time Sheet Summary by FMW
Good morning, I am having a problem with time sheet reporting. We have a weekly timesheet which hourly employees complete every week. Most have been saving...
January 4th, 2010 11:18 PM
by ryguy7272 Go to last post
2 122
Weekly Time Sheet Consolidate by FMW
Good morning, I am having a problem with time sheet reporting. We have a weekly timesheet which hourly employees complete every week. Most have been saving...
January 4th, 2010 11:11 PM
by ryguy7272 Go to last post
1 116
How do I get a macro to be non worksheet specific? by navel151
I can't figure out how to make a macro non worksheet specific like they were in previous versions of Excel. I want to have a macro that will sort the same...
January 4th, 2010 10:46 PM
by Gord Dibben Go to last post
6 129
clueless where to start. by qteekat
I'm using 8 sheets in a workbook Sheet 1 : Col A= names of employess col C-I = days of the week I'm trying to find a function that will input the...
January 4th, 2010 10:29 PM
by qteekat Go to last post
3 91
Is there a simple formula to convert time in hundredths to minute by Ron
I get an exported excel file that has the time in hours/hundredths and I have to convert it to hours/minutes - example 6.18 = 6:11, 6.15 = 6:09, etc. I'm...
(Multi-page thread 1 2)
January 4th, 2010 09:42 PM
by Fred Smith[_4_] Go to last post
10 380
Converting hour/minutes to hours/hundredths by Tbazemore
I have an excel spreadsheet which has hours/minutes and I need to convert it to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete this...
January 4th, 2010 09:36 PM
by Luke M Go to last post
1 122
Lookup and return next value by LL
My Production Planner is exporting data from a Program that helps create our scheduling priorities. However, there are calculations that she needs to...
January 4th, 2010 08:35 PM
by Bernard Liengme Go to last post
1 103
Hyperlink text from linked workbook by Albert, Norway
I have a seperat workbook for each of my clients with the clientno as the filename i.e. 1001.xlsm, 1002.xlsm etc. All these files are in lets say c:/docs....
January 4th, 2010 07:30 PM
by Héctor Miguel Go to last post
1 103
Summing and Averages with non-numeric cells by Erinayn
I have a 7 question survery with the following possible responses 1 2 3 4 5 N/A We then take ther responses and average them. I'd like to eliminate the N/A...
(Multi-page thread 1 2)
January 4th, 2010 07:13 PM
by Erinayn Go to last post
11 200
Statistical question by Rachel Costanza[_2_]
I am looking to create a dashboard that will tell people how often to check their social media outlets based on the number of friends / followers etc they...
January 4th, 2010 07:10 PM
by ryguy7272 Go to last post
3 112
Real time function by terrylee
Hi, I am using the function "=now()" to get the date and time. I have also set the tool option calculation to automatic. However, the time is not...
January 4th, 2010 06:13 PM
by Michael.Tarnowski Go to last post
5 204
Post New Thread


Display Options
Showing threads 4181 to 4200 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 04:30 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.