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
Conditional Sum by claude jerry
I have a Excel File Saved on this below Link http://www.savefile.com/files/1923737 A B C D E F G Name Type Sun ...
December 10th, 2008 08:33 AM
by claude jerry Go to last post
1 296
Median continued by Bony Pony[_2_]
OK then. I'm going in circles on this. I want to conditionally format the cell that contains the Median or closest thereto. I have a row of cells in...
(Multi-page thread 1 2)
December 10th, 2008 07:53 AM
by T. Valko Go to last post
12 209
COUNTIF by Barry Lennox
I am having trouble with 'COUNTIF'. If I have the criteria as a single cell reference all is well. If I enter "" or "" either alone or as a range I get 0...
December 10th, 2008 07:40 AM
by Barry Lennox[_2_] Go to last post
2 114
Sumif based on two variable by Memphus01
i am trying to get the sum of data from column S that meets criteria from column b and d- I have been able to get a count using the following...
December 10th, 2008 05:36 AM
by Max Go to last post
4 160
Outline/group 2 columns- what puts the control on the left vs righ by frustrated
I'm using Excel 2007 (with its HORRIBLE GUI) on Vista (which crashes a ton). I made a sheet, copied it to another sheet. Now I'm adding outline groups. On...
December 10th, 2008 04:59 AM
by frustrated Go to last post
0 114
Creating sequential text string of fixed length by dhstein
Hi - I need a formula that will generate text strings in rows like row 1 0001 row 2 0002 row 3 0003 .. .. .. row 9999 9999
December 10th, 2008 04:52 AM
by Max Go to last post
7 189
Return First Line from a group of files by willwonka[_2_]
I have a folder with about 150 text files. I would like a macro that would return the first line of each of those files into a spreadsheet. The files do...
December 10th, 2008 03:46 AM
by willwonka[_2_] Go to last post
3 123
Extract values based on searchable reference by D Reg
Basically I have all my data for each record contained in one cell, this obviously is a no go. I need to pull data between two specific words: "Address" &...
December 10th, 2008 03:27 AM
by Ron Rosenfeld Go to last post
5 112
record dozens and singles in same cell and sum them? by Calculating Dozens
I would like to record dozens and single units in single cells with a view to using them in calculations. E.G. stock sheet - 12,4 in one cell added to 10,2...
December 10th, 2008 03:25 AM
by dhstein Go to last post
2 102
Pivot table questions by Francesco
2 questions: 1)I created a custom pivot table format, but I am unable to use it for other documents than the one I created it into. Any idea on how to do it?...
December 10th, 2008 02:55 AM
by Debra Dalgleish Go to last post
1 119
How to keep duplicate cells by pwillissr
I have a file with over 11,000 ASINS on there a lot of which are duplicated. I would like to know how to I extract those duplicate ones and keep those only....
December 10th, 2008 02:42 AM
by JLatham Go to last post
1 87
Adding a cell or column to be included in a sum formula by lindan8r
Cell A1 is my "Total" column, with the formula of =sum(B1:X1). When I try to add a new cell/column to the left of B1 (which then becomes B1, and B1 becomes...
December 10th, 2008 02:40 AM
by Max Go to last post
5 110
excel 2007 compatability mode by joebrennan
how do I open a new spreadsheet that is not in compatability mode. I need to import data that has more rows than the 65xxx allowed by earlier versions.
December 10th, 2008 02:27 AM
by JLatham Go to last post
1 122
Multiple IF formulas by sriddle
Can I put more than on IF formula in a cell?
December 10th, 2008 01:25 AM
by Pete_UK Go to last post
3 99
Hellp Me Excel Help!!!! pt 2 by headbanging_Fe[_2_]
i done the previous problem and thank you to everyone. i have to make a discount on if attendance is 5 days then they get 15% and if the attendance is 4 days...
December 10th, 2008 01:23 AM
by headbanging_Fe[_2_] Go to last post
2 119
When tracking changes in excel shared workbooks, do all users see by bdmedlin
When tracking changes in excel shared workbooks, do all users see all changes? Such as when I enter the Who, When etc.
December 10th, 2008 01:15 AM
by bdmedlin Go to last post
0 115
Lock specific cell by Lisa
I cannot get the lock specific cell function below to work: 1. Select entire worksheet by clicking the Select All button 2. Click Cells on the format menu,...
December 10th, 2008 01:02 AM
by Dave Peterson Go to last post
1 113
Conditional Formatting A Whole Column by varsityfresh
In my first column I have a list of supplies that are already in my possesion. In subsequent columns I have listed other supplies that I need. Is it possible...
December 10th, 2008 01:01 AM
by Sheeloo Go to last post
1 109
Incomplete text wrap within a single cell by Ken
I am having a problem that I have never encountered before. I am entering data in individual cells that I have copied and pasted from e-mails. The...
December 10th, 2008 12:34 AM
by BDT Go to last post
1 127
Updating worksheet by sriddle
I have a spreadsheet that I use to enter information to print labels. The worksheet is not saved, only printed. I need some of the information to...
December 9th, 2008 11:56 PM
by Gary''s Student Go to last post
1 83
Post New Thread


Display Options
Showing threads 29961 to 29980 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 05:32 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.