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
When refreshed, some Pivot Table columns retain formatting, some d by Josel
I have not had trouble with retaining column widths and column heading formats (font size, word wrap, alignment) in Pivot Tabl. When refreshed, they retain...
April 22nd, 2010 05:50 PM
by Josel Go to last post
0 224
Charting the Sum of Two, or More, Series of Data by MJ
I know there must be a relatively simple solution to my challenge, short of creating a new series od data which is the sum of desired series. Let's say that...
April 22nd, 2010 05:06 PM
by Jon Peltier[_2_] Go to last post
6 458
Centreing Text In Excel Cells by Alan
I am send data to an Excel Spreadsheet, which includes some numeric data and some text data. I want to have the text in all columns in the centre of the...
April 22nd, 2010 04:01 PM
by Duke Carey Go to last post
1 224
copy paste value by Tomwireless
I have a colum of vlookup numeric data and want to add it up, but each cell may not return a value depending on how many items are needed. I belive I will...
April 22nd, 2010 03:58 PM
by Duke Carey Go to last post
1 236
identify the numbers cancelling by amounts by Radhakant Panigrahi
Hi, can anybody help in the below query i have the below data with...
April 22nd, 2010 03:44 PM
by Radhakant Panigrahi Go to last post
0 179
I want to compare two coloumn particular text, then count total by Ashraf C.H.
I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i...
April 22nd, 2010 01:55 PM
by Dave Peterson Go to last post
3 252
How to get repeatable Excel RAND sequence? by Joe User[_2_]
Is there any way to seed (initialize) the Excel 2003 RAND function so that subsequent calls to RAND result in a repeatable sequence? I have tried seeding the...
(Multi-page thread 1 2)
April 22nd, 2010 01:50 PM
by Hans Terkelsen Go to last post
12 721
Columns labeled with numbers not letters by plumeria54
My spreadsheets suddenly show numbers for the columns instead of letters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now...
April 22nd, 2010 01:40 PM
by John Go to last post
9 620
Conditional more than one iif by JoeM
I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = “1” and the value in column M is “30”...
April 22nd, 2010 01:22 PM
by JoeM Go to last post
7 395
Formatting question with Round by DaveOfArkansas
I have a Proposal, in the proposal there is a sheet that gathers the the facility upgrade cost, production man hours, by building and other info. One thing...
April 22nd, 2010 01:19 PM
by Duke Carey Go to last post
3 360
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, .. by M.Mahesh
i want to use if Command in which 19 times If Function to be used for Example of the Function is =IF(A2="Bongaigaon", B2*40, IF(A2="Dhemaji", B2*100,...
April 22nd, 2010 01:13 PM
by Pete_UK Go to last post
2 179
combine multiple spreadsheets into one workbook by Jen
i have approx 800 individual excel files. i want to put them all into one excel workbook - creating one workbook with 800 worksheet tabs. Is this possible...
April 22nd, 2010 01:12 PM
by Duke Carey Go to last post
1 260
Logic Formula using colors in the formula? by Danny Boy
Hi: I am using Office (Excel) 2007, and for some reason I thought that a change was made in this version of Excel, that allows for formulas which take into...
April 22nd, 2010 01:01 PM
by Danny Boy Go to last post
2 334
vlookup with two recors by siva_vlookup
Hi, while performing vlookup, if the lookup value has two records in a column, how to identify the first and second one.
April 22nd, 2010 12:27 PM
by Mike H Go to last post
1 171
Reference different lines in the same cell by Panos
Hi all, I have an excel sheet were in some cells there are multiple lines created by pressing "Alt + Enter". Is it possible to reference each individual line...
April 22nd, 2010 11:44 AM
by Stefi Go to last post
1 188
How do I search for the second largest value in the array? by Golf
How do I search for the second (or third and so on) largest value in the array either in column or row?
April 22nd, 2010 09:33 AM
by Ms-Exl-Learner Go to last post
2 161
Excel 2003 make 1 date cell automatically change another date cell by Scotty
I am using Excel 2003 and within a new spread sheet that I am creating I have 2 cells with dates in them. 1 cell is the date that the equipment was inspected...
April 22nd, 2010 09:01 AM
by David Biddulph Go to last post
4 269
Which formula combination will solve my anticipation by Amin
Sheets in workbook 1) First page 2) Inventory 3) Lookuptbable 4) Summary I have a column in the first page that takes codes and bringing in to the second...
April 22nd, 2010 08:38 AM
by Amin Go to last post
0 188
Conditional format will not work without $ (removed to allow copyi by CW
Hi, I have conditional formatting set-up where a range of cells will change colour based on values in another couple of cells. The rule was along the lines...
April 22nd, 2010 08:35 AM
by CW Go to last post
2 246
How do I get the formula icon back on my toolbar? by Andrea confused
I seem to have lost the formula icon off my toolbar and don't know how to get it back so that I can do quick sums in my spreadsheet. How do I do this please?
April 22nd, 2010 06:32 AM
by FSt1 Go to last post
1 201
Post New Thread


Display Options
Showing threads 1081 to 1100 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:55 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.