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
Merge Cells? by msnyc07
I need to remove duplicate cells but besides specifying which cells constitute a match I want to specify what to do with conflicting values in the...
February 9th, 2010 01:48 AM
by Ashish Mathur[_2_] Go to last post
2 110
Arrange Footer by MAX
I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I arrange this footer in all sheets to ABC 6/0. Thanks in advance.
February 9th, 2010 12:56 AM
by Gord Dibben Go to last post
2 140
Lookup a value that fits two (2) criterion by Carlos R
I need to find a value that is identified by 2 criterion. For example, I need to identify the profit of brand y in store 91 (7.0). A vlookup only considers...
February 8th, 2010 11:34 PM
by Lars-Åke Aspelin[_2_] Go to last post
4 103
Lookup columns (varying qty), then find MIN by NRath
I need to find the min value in each row for all columns with a heading of a specific format (TEMP 1, TEMP 2, TEMP 3, ...). It can't include other formats...
February 8th, 2010 10:58 PM
by Charabeuh[_5_] Go to last post
6 105
Index and Match by carl
I use this formula: =INDEX($B$6:$B$255,MATCH(1,--ISNUMBER(FIND(AE7,$C$6:$C$255)),0)) I appears to be returning the value in $B$6:$B$255 that corresponds to...
February 8th, 2010 10:09 PM
by Luke M Go to last post
2 100
insurance renewal formula flag needed by tmv
I need to flag a reminder for myself a couple weeks in advance to renew insurance policies. How do I set this up if: C1 D1 ...
February 8th, 2010 10:06 PM
by Luke M Go to last post
1 84
stop view and lock columns by Psychokitten
Hi, I need to hide two columns on my worksheet such that when I send it to a user, they cannot "unhide" the columns to see salary data. Is there a way to...
February 8th, 2010 10:05 PM
by Luke M Go to last post
2 76
FORMULA by attyshane
I have a hodge-podge list of numbers and letter-number combinations. I need excel to tell me when any of those values appear in collumns J-N . can this be...
February 8th, 2010 09:46 PM
by Don Guillett[_2_] Go to last post
6 79
Sum a column if two criteria are met by swestberry
I need a formula that sums column C for each "Loc" by "Item"? A B C LOC Item WA Txn Value 1241 R3331 595.20 1241 R3334 595.20...
February 8th, 2010 09:25 PM
by swest Go to last post
3 81
Conditional format on adjacent cells by Simon
Hi All, what am I doing wrong?? I want cells A1 to G1 to conditionally format (to red) if they are ALL empty, but if ANY one (or more) of them contain data...
February 8th, 2010 09:08 PM
by Simon Go to last post
4 108
General question by Rookie User
I want to have a master list I work from and then have parts of it transferred to different worksheets. I have been changing the data in 7 different tabs...
February 8th, 2010 08:34 PM
by trip_to_tokyo[_3_] Go to last post
2 83
excel 2007 set a row or column to not recalculate by jaz
excel 2007 can I set a row or column so as to not recalculate
February 8th, 2010 08:33 PM
by jaz Go to last post
0 88
How do I create formula to identify duplicate cells? by Kelly Lacey
Using Excel 2000, I need to identify rows that have matching cells. For example, B3=B4 and C3=C4. I have used the and/if function in the past and been able...
February 8th, 2010 07:33 PM
by Mirella Go to last post
7 329
Where was I??? by silver5
Last week I joined this site and asked for help because I opened a document in Excel and couldn't see it. A nice man answered me and it worked! I'm trying to...
February 8th, 2010 07:15 PM
by Paul C Go to last post
3 65
Hyperlink not working by sanket
Hi I am trying to create an hyperlink.It is getting created.When i am trying to click on the link a message is coming on screen: The operation has been...
February 8th, 2010 06:58 PM
by sanket Go to last post
2 79
Conditionally Formatting a Range by Anita
I want to use a variable cell (let's say cell H1) to format a range (let's say A1:c10). Example: If cell H1 = "block" then shade cells A1:C10 red.
February 8th, 2010 06:46 PM
by Andri Go to last post
1 88
symbol definition by Bill
what does the following symbol stand for ^
February 8th, 2010 06:06 PM
by Max Go to last post
2 65
data in single column split to multiple col's based on header by george
Hi All, I have data in three diff columns, e.g: column A column B column C 1 absman a 1 folklore b 2 internet c 2 absman d 3 folklore e 3 internet f
February 8th, 2010 05:55 PM
by Daryl S[_2_] Go to last post
2 108
count unique values in one column for a set value in another col. by Jean-Luc
I am trying to count how many unique values (text) I have in one column, for the row cases where a particular value exists in another column. Perhaps some...
February 8th, 2010 05:39 PM
by LizG Go to last post
2 77
Removal Date by Andri
Dear Experts, Please help for the following condition: 1. I have one sheet "A" which contain of database, the field structure as follows: Field A =...
February 8th, 2010 04:48 PM
by Andri Go to last post
3 82
Post New Thread


Display Options
Showing threads 3141 to 3160 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 10:58 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.