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
How to use OFFSET to determine DUPLICATES in a list? by myk[_2_]
Hello, I have a list of names in column A (a4:a14). In column B I would like to indicate if the name in column A is a duplicate. Column A is sorted. Below...
September 19th, 2008 04:25 AM
by myk[_2_] Go to last post
3 180
Unprotecting worksheet/workbook in Excel 2007 by Steve
I protected the worksheets and the workbook. Now I need to unprotect them for some changes, but on the review tab, unprotect sheet and unprotect workbook are...
September 19th, 2008 04:00 AM
by Steve Go to last post
2 122
Help in color index function by [email protected]
Hello, I want to give conditional formatting for a cell, based on background color of another cell without using VBA? I know far sure using VBA we can do it,...
September 19th, 2008 03:52 AM
by igorek Go to last post
2 152
"COUNTU" function in Excel to count unique entries in a range by WayneL
In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)...
(Multi-page thread 1 2 3)
September 19th, 2008 03:50 AM
by T. Valko Go to last post
20 999
add 1 count to a column of numbers by JeriSys
If I have a column of numbers and I want to increase each number in that column by 1, how do I do that? THANX!!
September 19th, 2008 01:31 AM
by Sunrich Go to last post
5 178
'SUM' isn't working - what would cause this ? by scott
This is a little strange. I have exported data from one of our applications into Excel. I'm trying to total a range of numbers but it's just giving me...
September 19th, 2008 01:15 AM
by Harlan Grove[_2_] Go to last post
5 138
Combining Text from 2 Columns into 1 then Deleting the 2 Columns by sleepindogg
I am attempting to merge text from two different columns ie. C2 and D2 into one column. Once I have the data from the two columns in my new column, I would...
September 19th, 2008 12:36 AM
by wtdrm Go to last post
5 190
Conditional Data Validation by evoxfan
I have a column (D) to enter a dollar amount of a transaction. All transactions are classifed in column A as either cost or revenue. I want to make sure...
September 19th, 2008 12:13 AM
by Gord Dibben Go to last post
4 111
MS OFFICE EDITION 2003 by Bill
Using EXCEL, I want to color code a cell if its value is "x" times another cell's value. Any answers?
September 19th, 2008 12:09 AM
by Gord Dibben Go to last post
2 119
Recording changes in cell value by CDC
Hi, I want to record any change in value of cell A in B; i.e. if I have a number in cell a which is increase by 2 I want 2 recorded in cell B and...
September 19th, 2008 12:01 AM
by Gord Dibben Go to last post
2 129
Extract all text without spaces and special characters by Alfredo_CPA
I have an ugly vendor database (around 50,000 rows) from different sources and the names of the vendors look like this example: ABC Company A B C...
September 18th, 2008 11:39 PM
by Gord Dibben Go to last post
4 116
Splitting Worksheet by Harvey Gersin[_2_]
How do you split a worksheet in Excel 2007 so that a separate sheet appears above and current sheet appears below the split line? I need to see a section of...
September 18th, 2008 11:35 PM
by Gord Dibben Go to last post
2 142
How can I set up a series with letters and numbers together? by Nommer
I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a...
September 18th, 2008 11:29 PM
by Gord Dibben Go to last post
6 127
$ symbol in a formula by RAB2685
Is there a way to highlight a bunch of formula's and automatically have the $ sign added before the column identifier and the row identifier versus going...
September 18th, 2008 10:44 PM
by Gord Dibben Go to last post
4 118
How do I use feet and inches (including fractions of inches) by MRZ
I would like to calculate using feet inches and fractions. such as sum ect.
September 18th, 2008 10:35 PM
by Gord Dibben Go to last post
2 162
cell indicator flag by jtaiariol
does anybody know how to turn off the green triangle flag that indicates a formula in the cell? thanks.
September 18th, 2008 10:32 PM
by Gord Dibben Go to last post
2 102
Formula w/two columns to add the greater number by Saul
Hello, If I have two columns with different number and I want to choose the bigger number of both columns, how can I do it. -- Thank you.
September 18th, 2008 09:32 PM
by T. Valko Go to last post
2 115
Top Ten Lists with a twist (or three). by Bigfoot17
I don't ever seem to ask the obvious. I have a table made up in part of the following: Col A - Area (there are 8 areas so I am trying to get a top ten for...
September 18th, 2008 08:48 PM
by Bigfoot17 Go to last post
0 128
If(AND) Statement by KalliKay
Project Completion % in Cell Q5 might be 0%, 50%, or 100% Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a...
September 18th, 2008 08:22 PM
by JP[_5_] Go to last post
5 133
lookup a category for a part that contains a start and end value by winnie123
Can anyone help? I have a worksheet containing part numbers and I want to search another workbook which contains a product category. The trouble is the...
September 18th, 2008 08:22 PM
by Pete_UK Go to last post
6 144
Post New Thread


Display Options
Showing threads 20201 to 20220 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 07:31 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.