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
Pivot table to calculate variance showing budget and actual. by YY san.[_2_]
Hi, I know this is rather simple, but I just could not get it right. I have this data: Expenese Type Amt Scenario Staff cost 200 ...
April 22nd, 2010 05:15 AM
by Ashish Mathur[_2_] Go to last post
2 140
Counting values in an array where value in one column is not null by CW
Hi, I am collating project details from multiple sources and need to report back how many projects are active in specific phases based on data such as in the...
April 22nd, 2010 04:06 AM
by Ashish Mathur[_2_] Go to last post
5 365
logical (if a1=specific word, can c1 = value entered in a2?) by mel
I am trying to make a payroll sheet so that if someone enters the word "Stat" into field a1, and then manually enters the number of hours worked into a2,...
April 22nd, 2010 03:29 AM
by Fred Smith[_4_] Go to last post
2 147
April 22nd, 2010 03:23 AM
by Matt Geare[_2_] Go to last post
2 108
Text to values by Nadine
I need to convert cells of data to values. The data is the result of the following formula: =LEFT(D2,SEARCH(" ",D2)-1). Example of data results: 1099r,...
April 22nd, 2010 02:11 AM
by Nadine Go to last post
4 146
how do i create a repeating student certificate using excel by maroo
i have a database of my class and i want to make a repeating student certificate using excel is their any way to do this in a simple way ??
April 22nd, 2010 01:56 AM
by Billy Liddel Go to last post
2 203
excel - horizont line above font X by jafre
hi, i need consul, how make horizont line above/whereupon font X or V, i need for my work. THX
April 22nd, 2010 01:50 AM
by T. Valko Go to last post
3 136
GETPIVOTDATA and Date-type field (Excel 2007) by [email protected]
Data Sample *************** Trip 0346210980 Statement Date 3/24/2010 Description STARBUCKS Date ...
April 21st, 2010 10:59 PM
by [email protected] Go to last post
0 110
Id'ing tabs that contain #REF!'s by Steve
I have a workbook with quite a few sheets, many having formulas that refer to other sheets. Sometimes when I make changes to some of the cells in certain...
(Multi-page thread 1 2)
April 21st, 2010 09:00 PM
by Steve Go to last post
14 185
How do I update links from .xls sheets to .xlms sheets by June
I have thousands of links to many consolidated spreadsheets created in Excel 2003. Now that I use Excel 2007, how do I convert the links without breaking...
April 21st, 2010 08:57 PM
by Duke Carey Go to last post
2 103
Vlookup + sumif , but how???? by Jessejames
this is my database (ROW and column A52 IS description) A B C D E F G ...
April 21st, 2010 06:41 PM
by Roger Govier[_8_] Go to last post
4 104
Display formula Excel uses for internal functions (STDEV...) by RexDn
How to Display formula Excel uses for internal functions such as (STDEV, STDEVp, STDEVpa ...) It would be useful to see what formula Excel us using at any...
April 21st, 2010 05:29 PM
by Mike H Go to last post
1 124
Pulling/Collating Data from Workbooks by chrisk
Hi, I have a workbook with 31 sheets a diary called April for this month AX to FX is the info I want relating to the employee's initials in the G column of...
April 21st, 2010 05:27 PM
by Roger Govier[_8_] Go to last post
6 103
Conditional Formatting Question with 'OR' by Steve Stad
Is "OR" operator allowed in Excel conditional formatting? If so is there something wrong with this formula - it does not seem to be working? ...
April 21st, 2010 04:56 PM
by Duke Carey Go to last post
2 101
Combine two sets of overlapping Date/Time data into 3 columns. by Tom Langley
I have two sets of data with Date/Time. One set has a fixed interval, the second is more sporadic. I am trying to combine into these sets into one table...
April 21st, 2010 04:44 PM
by Tom Langley[_2_] Go to last post
3 99
Reorder $String1, $String2 to $String1 $String2? by msnyc07
I've been able to do this for any specific word e.g. Manager, Department Manager, Regional with a basic function but it requires me to re-do for each...
April 21st, 2010 04:24 PM
by Duke Carey Go to last post
1 110
Excel 2007 on Vista by Mary Hitt
avoid this? When I minimise my excel 2007 worksheet I lose the ribbon. How can I
April 21st, 2010 03:55 PM
by Gord Dibben Go to last post
1 113
Text to Date by PAL
I have been given a database dump (thousands of rows) that put the dates in a text format like this: Aug/11/2009 Is there any way to put this into a date...
April 21st, 2010 03:18 PM
by Glenn[_6_] Go to last post
8 83
If then by PAL
I have a multi column (10), multi row(1000s) table. I am trying the following formula, with if two conditions are...
April 21st, 2010 03:13 PM
by Glenn[_6_] Go to last post
8 156
Excel 2007 Page Break Adjustments causes a page break each cell by BKaufman
Win 7, Excel 2007. When we look at a document in page break view and then drag the page breaks to make the doucment fit on a page, the document will put a...
April 21st, 2010 02:59 PM
by Duke Carey Go to last post
1 122
Post New Thread


Display Options
Showing threads 1101 to 1120 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:51 AM.


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