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
Using Lookup to locate Price from Drop-down List by Koomba
Xcel2003 Am developing an Sales Order for our small business. We have 11 products; and trying to assign Price (C4) based on Product (B4). IF statements work,...
September 22nd, 2008 06:25 AM
by Ashish Mathur[_2_] Go to last post
2 148
Goal Seek using Time by laya1024
Hi- I am doing a project that I am having difficulty with. Hope you can help. I am trying to use goal seek to see with the fourth quarter target needs to be...
September 22nd, 2008 05:26 AM
by Sheeloo[_2_] Go to last post
2 190
Concatenate group of cells by HARSHAWARDHAN. S .SHASTRI[_2_]
Is it possible to concatenate group of cells. i e for exp if cell a1 contains "a" and cell a28 contains "z" . What i want is a formula which will results in...
September 22nd, 2008 05:02 AM
by Rick Rothstein[_2_] Go to last post
6 342
how do i calculte race night odds by DAVID
I RUN RACE NIGHT AND AM TRYING TO BLUID A ODD =ALCULATER
September 22nd, 2008 05:01 AM
by Sheeloo[_2_] Go to last post
1 157
Time is locked to General format by al_gosc
Hello, I am a workforce analyst, and needs to know how many hours of lates, time off, OT's, etc..we have...so I created a worksheet. I exported the entered...
September 22nd, 2008 03:04 AM
by T. Valko Go to last post
5 143
VLOOKUP with 2 Conditions by al_ba
Hello, Sheet 1 is the Data and Sheet 2 is the result I need. Sheet 1: (DATA) A B 1 GROUP 1 Hours:Minutes 2 ...
September 22nd, 2008 01:20 AM
by JMB Go to last post
3 179
Finding Used time for Payroll by cmatera
I have a payroll sheet which consists of 14 days Sat-Fri and three columns: DATE Date ET | USED | BAL | ET | Used | Bal | First...
September 22nd, 2008 12:47 AM
by Sheeloo[_2_] Go to last post
1 134
Formula is correct, but result will not show by bryanchughes
I'm using Excel 2007. I have been using a spreadsheet for a basic accounting project and had the following basic formula: =5x+5y When I use the pull down...
September 22nd, 2008 12:02 AM
by Max Go to last post
5 135
xirr by Janven
The result of below XIRR calculation is very weired. Apr 5, 06 16328 Oct 2, 06 16096 Jul 3 07 11251 Nov 1 07 71414 Dec 3 07 79637 Jan 2 08 ...
September 21st, 2008 11:02 PM
by Fred Smith[_4_] Go to last post
3 229
Drop down tabs that can auto fill certain information? by Luke22
Hi! Im trying to set up an excel spread sheet with some drop down tabs. I want to be able to select a certain "item" from the drop down tab which will then...
September 21st, 2008 10:16 PM
by Luke22 Go to last post
3 142
Dynamic Time. by HARSHAWARDHAN. S .SHASTRI[_2_]
Is it possible in Excel to put "Live Time" in particular cell. ie cell should change its value every second. Thanks Harshawardhan Shastri India
September 21st, 2008 10:15 PM
by FSt1 Go to last post
1 151
Excel functions do not execute by Bill
I have an Excel spreadsheet and when I enter a function, for example =if(l2="", j2, l2) it enters the function text and does not execute the function. Also,...
September 21st, 2008 10:06 PM
by JMB Go to last post
4 125
tag Numbers by Lewis
Hi, I originally posted this in general question and Gary's Student knidly suggested i repost her. The examples below are a typical but not an exhaustive...
September 21st, 2008 09:58 PM
by Sheeloo[_2_] Go to last post
8 236
Negative numbers by Vercingetorix.XIII[_2_]
Is there a formula that will add a column but ignore the negative numbers???
September 21st, 2008 08:37 PM
by Sandy Mann Go to last post
4 142
Question about a formula for time .. by hrbsh97
I have a spreadsheet that calculates my in & out time at work .. I have that set up with a date, time in, time out .. my formula correctly adds my number of...
September 21st, 2008 08:23 PM
by Pete_UK Go to last post
3 105
ADDATION OF DEGREE / MINUTES/SECOND by HARSHAWARDHAN. S .SHASTRI[_2_]
WHAT I NEED IS ,A FORMULA WHICH CAN ADD SAY 90°30'42'' +30°54'40'' =------------- 121°25'22'' WAITING FOR URGENT REPLY. HARSHAWARDHAN SHASTRI
September 21st, 2008 06:32 PM
by David Biddulph Go to last post
4 154
RANDOM NUMBER GENERATION. by HARSHAWARDHAN. S .SHASTRI[_2_]
WHAT I NEED IS RANDOM NUMBERS SAY 1 TO 10 IN CELLS A1:A10 AND CONDITION IS THAT NO NUMBER SHOULD REPEAT. CAN ANY ONE GIVE ME SOLUTION. THANKS...
September 21st, 2008 06:01 PM
by Teethless mama Go to last post
4 135
Negative numbers by Vercingetorix.XIII[_2_]
Is there a way to make a number be a negative number when it is entered in? I need to add a total of figures and have it subtract from another total.
September 21st, 2008 05:50 PM
by Gord Dibben Go to last post
5 143
Locking a worksheet, but sill fill in informaiton by Munchkin
I just completed a worksheet I use as an application. It has drop down lists and text boxes for information to be placed by clients. How do I lock the...
September 21st, 2008 03:32 PM
by Reitanos Go to last post
1 137
MATCH() Function and Blanks by Gary''s Student
I have a column of values and am trying to identify where values appear in the column. For example, in A1 thru A5: cow mouse pig horse
(Multi-page thread 1 2)
September 21st, 2008 12:38 PM
by Gary''s Student Go to last post
17 247
Post New Thread


Display Options
Showing threads 20101 to 20120 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:40 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.