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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Issue with pivot table by varsha12
Hi, We have a report in which the data appears in a pivot table. After some time the pivot table is coverted to text. Is there a way to covert it back to...
April 16th, 2010 02:51 PM
by Jim Thomlinson Go to last post
1 233
conditional format by Jean-Paul
Hi, I want the color of the text in cell B1 to change depending on the value in cell A1 How can this be done? I know I can do it with conditionale...
April 16th, 2010 02:33 PM
by ck13 Go to last post
5 339
EXCEL by Giselle
I have two different workbook with different data in each one except for the social security that might be in both workbook. I want to order excel that...
April 16th, 2010 12:59 PM
by Dave Peterson Go to last post
2 279
Sort blocks of data by bushwood
Can you assign groups of columns to move together when sorting horizontally? I have 11 groups of columns each group with an amount column, ideally we have...
April 16th, 2010 12:57 PM
by Dave Peterson Go to last post
1 194
summing based on text conditions by Totteridge Ram[_2_]
Hi all I want to sum my "Value" column based on the text condition in my "Description" column. Whenever the description contains "CRDML" and does NOT...
April 16th, 2010 12:53 PM
by Mike H Go to last post
2 186
How to count the number of text? by Eric
There is a list of text from cell A1 to A100, I would like to count the number of "Mary" within this range, each cell may contain a senstance, such as Mary...
April 16th, 2010 11:39 AM
by Jacob Skaria Go to last post
4 190
kopirovanie bez zvysovania hodnoty by Toro
da sa niekde generalne nastavit aby pri kopirovani hodnoty v bunke (tahanim za pravy dolny roh bunky + mysou) sa tato nemenila bez nutnosti držania klavesy...
April 16th, 2010 11:36 AM
by Toro Go to last post
0 203
vlookup based on IP range by Deen
Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP...
April 16th, 2010 10:35 AM
by Deen Go to last post
2 203
April 16th, 2010 07:06 AM
by Rich Go to last post
0 177
How to tally a set of values according to month? by glitterjen
Hi everyone, I am currently working on a spreadsheet involving a list of dates, each with an assigned value. My wish is to add together the values for EACH...
April 16th, 2010 06:31 AM
by StephenAccountant Go to last post
3 214
Insert outlook mails as attachemnt without inserting as object by Radhakant Panigrahi
Hi i have a problm while inserting a outlook mail in excel sheet. every time i have to go to Insertoject and then brows the location where it is to be...
April 16th, 2010 05:36 AM
by Radhakant Panigrahi Go to last post
0 206
How to disable the pop up for enable auto update? by Eric
I have imported an external link in to excel, and set it auto update when it opens, but whenever I open this file, it pops up a window to confirm whether you...
April 16th, 2010 05:12 AM
by ozgrid.com Go to last post
2 261
How do I compare the stored data in micro by Help on formula[_2_]
Hi, I got four columns of stored list of addresses and dates (two for address and two for dates) which I want to match against each other. The formats of...
April 16th, 2010 04:55 AM
by Help on formula[_2_] Go to last post
3 200
Calculation Problem by Norm
I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the...
April 16th, 2010 04:37 AM
by Russell Dawson[_2_] Go to last post
5 274
XIRR range question by Brad
How can I "trick" excel to use non-continuous cell I would like to have =xirr(m3:m4 and n5,d3:d5) or =xirr(m3:m40 and n41,d3:d41) I realize that xirr...
(Multi-page thread 1 2)
April 16th, 2010 03:45 AM
by Ron Rosenfeld Go to last post
17 791
How to gernerate invoice numbers in EXCEL? by Ed
Have created an Invoice and am trying to generate a continous invoice number every time I type a new name.
April 16th, 2010 02:50 AM
by FSt1 Go to last post
2 212
What are the different methods of representing numerical data? by Excel Problem
Can someone answer my questions "What are the different methods of representing numerical data"?
April 16th, 2010 02:46 AM
by Joe User[_2_] Go to last post
1 217
Need help with below question by Prashant
I had this file with me. there were few hiddne formula. i found out one formula which was =c6*root!$g$3. My Question is whats is the use of this formula and...
April 16th, 2010 01:49 AM
by Pete_UK Go to last post
4 227
Excel - Expense tracking-multiple users by Hilli
Have 7 ppl sending me bi-monthly expense updates via Excel. Then I have to take all their "new" updated data and incorporate into a Master .xls, which the 7...
April 16th, 2010 12:02 AM
by Don Guillett[_2_] Go to last post
1 164
Trying to delete blank rows after file save by pm
In a spreadsheet I pull specific data out and copy into another spreadsheet. Then, if there are any blank rows I would like to delete them and save the file...
April 15th, 2010 11:58 PM
by Don Guillett[_2_] Go to last post
2 220
Post New Thread


Display Options
Showing threads 2201 to 2220 of 139764
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 07:14 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.