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
convert time to 1/4 hours by lktx
I have created a spreadsheet for keeping track of work hours. I have a calculation already for hours worked but need to be able to convert 7:45 to 7.75,...
February 15th, 2010 06:14 PM
by lktx Go to last post
2 88
vlookup and multiple criteria by aprendiz
I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 ...
February 15th, 2010 06:13 PM
by T. Valko Go to last post
5 77
lookup to multiple rows and columns by aprendiz
I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 ...
February 15th, 2010 05:55 PM
by macropod[_2_] Go to last post
1 84
Problem in calculating the outcome by Elton Law[_2_]
Dear Expert, I have problem in doing a task. Say below ... A1 is name. B1 to Z1 is comprised of 25 names ... A2 is Shifts. There are 12 Shifts in a week. ...
February 15th, 2010 05:46 PM
by PJ Go to last post
6 120
UDF's via Automation Addin in Excel 2010? by Ralf Steinstraesser
Hi, does anybody know about the compatibility of Excel 2010 with User Defined Functions via the Automation addin model. We had developed a plugin, which was...
February 15th, 2010 04:44 PM
by Charles Williams Go to last post
1 273
Looups and multiple criteria by aprendiz
I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 ...
February 15th, 2010 04:35 PM
by Glenn[_6_] Go to last post
1 101
Lookup and multiple criteria by aprendiz
I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 ...
February 15th, 2010 04:19 PM
by aprendiz Go to last post
0 73
Matching names and inserting spaces by ILunacy
I hope someone can help me out with this. Say I have column A filled with like 500 names, and column B filled with 300 of the same names. Is there a way or a...
February 15th, 2010 04:17 PM
by ILunacy Go to last post
3 132
Workday function question by Spike
I am slightly confused with the Workday function and would appreciate advice. If I have paid someone to work 21 days (Monday to Fridays, weekends (Saturday...
February 15th, 2010 03:52 PM
by Mike H Go to last post
2 98
Times by Sandy
I have a drop down list in C5 and D5 with times ranging from 12.00 AM to 11.45 PM. I have the following formula in E5 which works well to calculate hours...
February 15th, 2010 03:15 PM
by JLatham Go to last post
2 92
How could I display an excel cell contents in a page header ? by Leo
I need that an specific cell contents will appear in the header of several pages. How should I define it?
February 15th, 2010 02:45 PM
by Gary''s Student Go to last post
1 149
Auto Short by Fareez
Dear Friends I want a function which should auto short the numbers or letter EX: 1 2 4 if i enter now 3 it should go above 4 automatically (I am not expert in...
February 15th, 2010 02:36 PM
by Jacob Skaria Go to last post
2 101
Matching data by Trish Smith
Hi everyone, I get database outputs in the form of CSV tables. There are 3 tables Location , Learner and Result. MS Query is used to match up the data from...
February 15th, 2010 01:35 PM
by Trish Smith Go to last post
0 63
Array addressing question... I think by John Bennett[_2_]
Hi, I have a problem I can't seem to solve. Columns B through G contain data. Row 4 contains a name. Other rows contain numerical data. I'm trying to figure...
February 15th, 2010 12:04 PM
by Bob Phillips[_3_] Go to last post
1 96
1st Wed, 1st Sat, 1st Sun by Keyrookie[_52_]
Hey all, I received this formula on this forum to always show the 1st Wed. of a month: =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())-3) What I now...
February 15th, 2010 09:58 AM
by Stefi Go to last post
5 105
Weird VBA Behaviour by msnyc07
Again, I'll apologize as not a coder, I am fixing code I was provided. I checked and checked and determined somehow that the VBA is WORKING as are my...
(Multi-page thread 1 2)
February 15th, 2010 09:04 AM
by Joe User[_2_] Go to last post
13 196
help in formula by Junaid[_2_]
I have given a formula that gives the specific cell data into the text i.e ="text "&AB4&" text" now my problem is that AB4 is the percentage it gives me 7 or...
February 15th, 2010 06:18 AM
by Joe User[_2_] Go to last post
1 61
Sum of cell which use if array function by Pran
Hi, I have many cells using if function which result is number. I'd like to sum all of those cells, unfortunatelly i cant do that, the result is none. How...
February 15th, 2010 04:41 AM
by T. Valko Go to last post
1 101
Lookup function by marvin
I have excel 2003. I did a vlookup for my transcripts page. In the first vlookup i needed it to look for the letter grade and give me the gradepoint...
February 15th, 2010 01:03 AM
by L. Howard Kittle Go to last post
1 65
Conditional Formatting for one cell matching another with text by MomHudd
I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7 MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7...
February 15th, 2010 12:06 AM
by David Biddulph Go to last post
2 85
Post New Thread


Display Options
Showing threads 2941 to 2960 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 09:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.