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 Reverse Sort Order Last Post Replies Views
COUNT formula need two conditions by DB Explorer
I have a database dump, which column B having different names of users, and column C having values either TRUE or FALSE...I want a count of all records, which...
December 8th, 2005 08:52 PM
by DB Explorer Go to last post
3 95
Add items in column 3 if column 1 and 2 conditions are met by DB16
This is what I am trying to do I am keeping track of my bank account using excel. I have it set up to were I enter a category in one column and I have columns...
August 16th, 2005 02:00 PM
by DB16 Go to last post
2 81
vlookup is returning a value one cell above the correct cell. by dbaker4
i have a simple vlookup formula in one worksheet referenceing values in another worksheet, ie ' =vlookup(B2,otherworksheet!A2:D37,3) ' the data has been...
April 20th, 2006 08:21 PM
by Matt Go to last post
4 86
multiple If's based on today's date by dballou
I need to have the value of a cell based on the number of days past from a date in another cell. i.e. A1 = 40 if A2 is =today()+365 or, A1=80 if A2 is...
March 24th, 2008 04:28 PM
by dballou Go to last post
5 99
formula for linear regression by DBane
I have a column of figures 20,30,40,50,60. when I select the range and put the + at the bottom and pull, the result shows 70. the same using chart wizard,...
(Multi-page thread 1 2)
September 1st, 2005 09:54 PM
by Ron Rosenfeld Go to last post
14 311
Running total formula by DBane
My cells look like this. in a:4 value is 6. In b:4 the value is 112. in a:5 value is 7. In b:5 the value is 125. in a:6 value is 6. in b:6 the value is 110. in...
June 2nd, 2006 07:38 PM
by DBane Go to last post
0 55
IF TODAY() by [email protected]
I'm trying to automatically fill some cells in a spreadsheet that's linked to a MS Project file. There are 5 cells - the first one is the cell linked to...
February 6th, 2009 02:36 PM
by [email protected] Go to last post
3 41
hide duplicate addresses in Excel by DbaseGuy
I manage a database for a school. when sending mailings home we often print two labels to the same home due to siblings in the same school. Is there a way to...
October 19th, 2006 03:46 PM
by Barb Reinhardt Go to last post
1 64
IF Function?? by DBassmaker
What can I do so that when I type a certain number in a column it will give me another number? For example I have a list of temperature correction factors...
September 9th, 2005 05:24 AM
by BenjieLop Go to last post
2 73
display and count the number of times a value appears by dbath
I am trying to count the number of times each zip code appears in an address list and have it display each zip code with the count beside it ie 11456 ...
June 24th, 2006 07:57 AM
by starguy Go to last post
8 110
Separate First Name MI and Last Name into three Cells by DBavirsha
I have a list of names in column A that contain the First Name, then a space, the Middle Initial then a space and the last name. Some cells in column A only...
July 14th, 2006 01:01 PM
by DBavirsha Go to last post
3 80
Help with complex VLOOKUP by [email protected]
Dear experts, I've inherited a very large set of spreadsheets. Daily, I get data from other spreadsheets, and paste it into this one. And, I run database...
November 15th, 2005 08:43 PM
by JakeyC Go to last post
3 74
Can surplus decimals be omitted when adding derived figures? by DBB9
I have a column of calculated figures, displayed to 2 decimals. When Excel 2003 adds this it includes concealed decimals, creating a rounding error in the...
December 29th, 2007 12:53 AM
by joeu2004 Go to last post
2 108
Changing groups of cells in Excel by DBB9
In Excel 2003 can I change a group of cells (e.g. a column) so their results all become negative or do I have to change each cell individually?
August 11th, 2008 01:23 PM
by Roger Govier[_3_] Go to last post
3 82
#DIV/0! ERROR by dbconn
I have a worksheet that has a number of rows in each of several different categories. Before any information is entered, each row shows a 0 sum. When...
January 18th, 2010 09:39 PM
by Gord Dibben Go to last post
2 167
year formula returning incorrect value by dbdewitt
As I understand it, the YEAR formula should return the year to which the formula relates. I have a date of 4/24/2008 in a cell (let's say it's in cell B2),...
September 25th, 2008 07:46 PM
by muddan madhu Go to last post
5 145
Replacing list title with list components - urgent! by DBenny
I apologize in advance for my naiveté.. I have a datalist in one worksheet that contains data associated with a list title. The list is contained in a 2nd...
April 23rd, 2007 02:06 PM
by DBenny Go to last post
2 62
Excel Formatting by dberger16
In my spreadsheet, I would like to find all the "and" words and then CAPITALIZE the very next letter or word in the same cell. Thanks! -- DaveB
September 21st, 2007 05:16 PM
by Gary''s Student Go to last post
5 66
Capitize first letter in sequence by dberger16
Hi, here is an example of data in my column: Lorena & james i simply want to capitize the J (james). Thanks for your assistance
April 20th, 2008 12:46 AM
by Max Go to last post
2 83
How do I copy subtotaled data without the underlying details? by DBergesen
I want to copy the subtotaled data to another part of the worksheet or a new worksheet without the underlying details. If I click and drag the area I want to...
December 15th, 2005 07:25 PM
by Ron Coderre Go to last post
1 104
Post New Thread


Display Options
Showing threads 20321 to 20340 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 09:34 AM.


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