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
FIND IF A CELL CONTAINS TEXT by Tree
We need to have a formula that can find a text in a cell and if text is in the cell, return that text, otherwise, leave the cell blank.
April 17th, 2009 04:41 PM
by Tree Go to last post
3 82
Apply Global Formula by Donna K.
I want to take a range of numbers in separate cells and divide them all by 2 and have the results replace the numbers listed. Is this possible in Excel?
April 17th, 2009 04:34 PM
by Pecoflyer[_294_] Go to last post
1 91
IF Formulas by Clara
I have a column for every month (12) and I have criteria that must be met all months in order for annual points to be awarded. How can I tell cell P5 that...
April 17th, 2009 04:32 PM
by Teethless mama Go to last post
2 69
Using Indirect with an Index Match Function by Mike
I have a number of worksheets January - December which I wiish to retrieve data from onto my Data worksheet using the INDEX MATCH function. How do I include...
April 17th, 2009 04:08 PM
by Mike Go to last post
3 93
entering a number and having a word appear in excel by kdill
Can anyone tell me, in microsoft excel, how do i type a number in a cell and have a word appear in that same cell instead of the number. Is this even...
April 17th, 2009 03:55 PM
by Glenn[_6_] Go to last post
4 90
Sumproduct Question by ShagNasty
I have a spreadsheet with 1-5k rows (and growing) with A-I columns -- Cols A-G text fields, Cols H-I number fields. H&I are YTD totals. Can SUMPRODUCT()...
April 17th, 2009 02:57 PM
by Glenn[_6_] Go to last post
2 78
Macro by Lois
Hi i have the following macro set up & linked to a customised button on my toolbar: Sub Ken_Full_Screen_View() ' ' Ken_View Macro ' Macro recorded 01/04/2009...
April 17th, 2009 01:54 PM
by Lois Go to last post
3 65
how do I substitute precedants in long excel formulas by ognavtra
i have generated long formulas (eg the sum of all variables in one column multiplied by the variables in another column). is there a way to 'find &...
April 17th, 2009 01:39 PM
by Gary''s Student Go to last post
1 77
Subtracting Military Time by Randy
I have a timesheet that I enter in and out times for workers. This is all in the same cell. Example: 1300-1515. In the next row i enter how many hours it...
April 17th, 2009 01:04 PM
by mubashir aziz[_6_] Go to last post
4 163
Format single character by alex
Hello All, Using Excel '07... Is there a way to use conditional formatting (or something else) to color a single character in a string. E.g., change the...
April 17th, 2009 12:50 PM
by Ron Rosenfeld Go to last post
4 84
normalize score by austuni
I work in exam department and there are several people who marks the same question. In order to be fair on the candidates, I would like to normalize the...
April 17th, 2009 12:30 PM
by mubashir aziz[_5_] Go to last post
1 88
matching Data by Hardeep kanwar
Hi! Experts I have 2 sheets in a workbook.Sheet1 is a master sheet with Customer code and there Sale.And Sheet2 is the sheet which has only Customer...
April 17th, 2009 07:59 AM
by Hardeep kanwar Go to last post
2 70
Errors encountered when using If & Vlookup formulas by nikko
Hi Need some help here.. Trying to have the formula to lookup J2 field in the Opp Summary spreadsheet and return Col I value. If Col I value is blank, then...
April 17th, 2009 04:15 AM
by nikko Go to last post
3 458
Pickup the content of Cells ( in formula) by Frank Situmorang[_3_]
Hello, My VBA below is to extract the information from each individual workbook and cosolidate it But now I want to take just the content of the cells (...
April 17th, 2009 04:00 AM
by Frank Situmorang[_3_] Go to last post
0 68
How to convert PDF tables into Excel?? by Pedro Sanchez IV
I have a HUGE PDF with many collums and rows of data that I want in Excel. Is there a way to convert this to XLS format? Software or setting? Thanks
April 17th, 2009 02:57 AM
by seapilot Go to last post
2 93
SUMIFS and dates by JLR-Mart
I have some data and wish to use the sumifs function to add up sums when a criteria is true and the date is less than a month ago. I have tried using date-30...
April 17th, 2009 01:59 AM
by Fred Smith[_4_] Go to last post
3 53
Advanced Criteria for SUMIF by Roberto Villa Real
I need to sum some values in Column C, but with 2 criterias (one criteria for column A and another criteria for column B). Exemple: I need the SUM of values...
April 17th, 2009 01:57 AM
by Hambo_NZ Go to last post
4 95
Slicing Data (Alternative to SUMIFS) by Marcelo[_2_]
I’m having some trouble with Excel. In essence, I’m trying to perform SUMIFS without using the formula (due to backwards incompatibility with 2003). Below I...
April 17th, 2009 12:59 AM
by Ashish Mathur[_2_] Go to last post
2 85
Method for creating formulas to reference different worksheets? by copticdred
What is the method for creating an Excel formula that references information on the first worksheet from a second worksheet?
April 17th, 2009 12:39 AM
by Gord Dibben Go to last post
3 81
Formula Help by CHerzog
Here is the function I am using. =IF(C3=0,NETWORKDAYS(A3,Holidays!A1,Holidays!A3:A30),NETWORKDAYS(A3,C3,Holidays!A3:A30)) I have two questions first is there a...
April 16th, 2009 11:05 PM
by T. Valko Go to last post
1 50
Post New Thread


Display Options
Showing threads 12041 to 12060 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:08 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.