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
How to set the default format on excel? by Eric
Does anyone have any suggestions on how to set the default format on excel 2003? such as font, size, center align, whenever I open, it is all set. Thanks in...
June 4th, 2010 11:51 PM
by Gord Dibben Go to last post
3 349
Consolidating data by BDT
Hi, I need to consolidate some lines of data in a 19K line spreadsheet and then change its basic format. I have 3 columns of data: ID# | date |...
June 4th, 2010 11:21 PM
by Don Guillett[_2_] Go to last post
1 289
Separate AM/PM from time. by cuartetto
In column B I have 1000 time entries with the following format. 9:30AM, 10:30PM. I would like to move the AM or Pm into a new column. I've tried "fixed...
June 4th, 2010 11:19 PM
by Dave Peterson Go to last post
2 335
Macro/VB coding question by melExcel2007
I want a macro to work for a worksheet name which will always be the same directory and file name but the data inside worksheet will periodically change -...
June 4th, 2010 11:16 PM
by Dave Peterson Go to last post
3 311
Set row height, but allow wrap text by KMM
I want to set the row height of me spreadsheet to allow a little "buffer" between rows. But I have a couple rows in which there is a greater amount of data...
June 4th, 2010 11:01 PM
by KMM Go to last post
0 300
SUMIFS by RAK
My SUMIFS formula was "accepted" but the result is 0.0 even though there are numbers to add. What can the problem be? The formula is...
(Multi-page thread 1 2)
June 4th, 2010 10:28 PM
by Ron Rosenfeld[_2_] Go to last post
10 434
Is there a way to insert a copied row into all aother tabbed table by Greg
I have a file with about 100 tabs along the bottom for other tables. I have a row that I need to copy and insert into each one of those (at the top, first...
June 4th, 2010 10:22 PM
by David Biddulph Go to last post
1 382
Printing in Color by Fill Colour for Different data
Ever since my printer has been networked by the cells in my excel if filled with color do not print in color. The print preview displays the various colors...
June 4th, 2010 10:03 PM
by Fill Colour for Different data Go to last post
0 286
Pull value from another sheet by laughlinl
I have multiple sheets in my workbook. On the first sheet, I am pulling data from all the other sheets for a comparison. I need to pull in a commission level...
June 4th, 2010 09:56 PM
by laughlinl Go to last post
2 322
Macro to affect all sheets by REMB
I want to select all sheets in a workbook, insert a column, and put a formula in that column. It works fine when doing it manually, but if I try to have a...
June 4th, 2010 09:45 PM
by njmikec Go to last post
3 260
Underline? Bottom border? or any suggestions? by Schnaka-paka
Hello! We have a form that we use quite often and I am attempting to put it on Excel so that someone can just tab through it and type in their responses. ...
June 4th, 2010 09:18 PM
by marysully Go to last post
1 217
data conversion by Candida
Please advise how I can convert a number that comes over as '40593 from our Italian firm. How do I take the ' off of the number. I have 3000 rows of numbers...
(Multi-page thread 1 2)
June 4th, 2010 09:10 PM
by BlackBayou Go to last post
11 384
Sumproduct;3 criteria by GregL
Hello, I need a formula that will sum the dollar value of a column if the entries meet 3 seperate criteria. The current formula I have (that returns a #NUM...
June 4th, 2010 09:04 PM
by Don Guillett[_2_] Go to last post
5 493
Keep Font format when importing excel into Access by garvic82
We have an excel spreadsheet that is updated by changing select text to red and highlighting in a text cell. So there are only certain strings where the...
June 4th, 2010 08:46 PM
by Chad_Oglesbay[_2_] Go to last post
1 431
Conditonal Format based on two different criteria by Chad_Oglesbay
Hi all. In column A I have a list of a bunch of different test names. In column D we have times associate with each test. I would like to make a conditional...
June 4th, 2010 08:33 PM
by Luke M[_4_] Go to last post
1 341
How do I look at two worksheets in one Excel workbook at same time by PeoriaJean
I know how to arrange windows to look at multiple workbooks. But I want to have two worksheets displayed at the same time from the same workbook. Is there...
June 4th, 2010 08:23 PM
by מיכאל (מיקי) אבידן Go to last post
2 377
nested formulas in excel using iserror and if by Vicki
Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am...
June 4th, 2010 08:13 PM
by Vicki Go to last post
2 444
Text Parsing with uneven lengths by dks345
I have cells that contain data such as: General Motors 22779 United States of America 1449 Carlsbad 712 Under 21 Children 12 I would like to parse the...
June 4th, 2010 07:57 PM
by מיכאל (מיקי) אבידן Go to last post
2 389
Pivot Table by KTR
I have a pivot table based on an excel worksheet with five columns - Date, Call From (Names), To, Time, and Type. In the pivot table, i am using From for the...
June 4th, 2010 07:28 PM
by Herbert Seidenberg Go to last post
1 304
How to merge 2 + contiguous cells without lossing data? by Patti
I need to merge two or more contiguous cells without lossing the data. Also I have cells that I copied & pasted into cells and I am unable to add data to...
June 4th, 2010 07:25 PM
by John Go to last post
2 355
Post New Thread


Display Options
Showing threads 61 to 80 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 03:55 PM.


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