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
Sorting and maintaining formula integrity by Ed[_13_]
I have an Excel Sorting question: I have the following Table: A B C D % Rank Cost Markup 13%...
September 16th, 2008 07:11 AM
by Max Go to last post
5 106
Text entry into excel by tobypitblado
Is it possible for me to set-up a spreadsheet for others to use but will limit the options of the data that they can enter (text only), so that they may only...
September 16th, 2008 05:38 AM
by Bob Bridges[_3_] Go to last post
1 98
Display a cell to the left with some changes by cmatera
Ok so here's another one. I have 3 cells that I'm concerned with: ET (A2), Used (B2), Balance (C2) If it's the begining of the month ET is filled with a...
September 16th, 2008 05:33 AM
by Bob Bridges[_3_] Go to last post
1 82
cross referencing by JockW
Hi guys, what would be the best way to cross reference a list of names in workbook1 with a huge list of names in workbook2. Ideally, if a name from w/b1 isn't...
September 16th, 2008 02:38 AM
by T. Valko Go to last post
4 77
Blocking/Disabling selected worksheet by DJ Ghale
I created an excel file for payroll purpose with each employee's pay info broke down in separate worksheets. Is there a way i can disable or hide other...
September 16th, 2008 01:19 AM
by Gord Dibben Go to last post
1 94
if questions by Mauro
Hello, i want to compare a cell between two number and return the sample quantity. I tried to do this using the IF and & functions, but it dosent works...
September 16th, 2008 12:05 AM
by Ashish Mathur[_2_] Go to last post
4 170
Need an Excel formula by Paul G
I need an excel formula that will calculate the total sum of a number when escalated by a fixed percentage rate over a variable number of years. My...
September 15th, 2008 10:52 PM
by Fred Smith[_4_] Go to last post
2 87
sum of info in a range based on dates by Real esate guru
I'm creating a spreadsheet that shows expiration dates of property as well as the square footage of each property. What I want to do is to find out the...
September 15th, 2008 10:28 PM
by Bob Phillips[_2_] Go to last post
4 83
Alphanumeric Sorting - numeric alpha numeric by Mike
I'm hoping someone can help me out. I've looked all over for a solution to my sorting in excel. I've seen sorting with alpha numeric where it starts with a...
September 15th, 2008 10:12 PM
by Mike Go to last post
2 75
IF Statement by KC_Cheer_Coach[_2_]
I am creating a spreadsheet with several conditional formulas. They all work except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES...
September 15th, 2008 10:08 PM
by T. Valko Go to last post
4 105
Adding up a column of percents by Trish
I need to know the formula for adding up a row of percents.... I am trying to find the total of 5 percetages - this is a sales increase on 5 different...
September 15th, 2008 08:59 PM
by Duke Carey Go to last post
3 82
some type of IF function by WHERE IS THE ANY KEY????
Could someone please help with the formula for having a seperate column return a value based on a drop down?? Column "B" is linked to column "K" with all...
September 15th, 2008 08:57 PM
by Spiky Go to last post
2 57
Paste Special Comments by elliobr
How do I paste value a cell without loosing the cell comment?
September 15th, 2008 08:37 PM
by Debra Dalgleish Go to last post
2 69
ASSIGN NUMBER SCORES TO LETTER GRADES by DOUG ECKERT[_2_]
I want to code scores "E" and "S" as passing and "U" as not passing. Scores are in a table of months arranged horizontally. Suggestions are welcome. DOUG
September 15th, 2008 08:31 PM
by [email protected] Go to last post
4 89
Combining MATCH & LOOKUP formulas by Txlonghorn76
I am trying to find a formula that matches the "Names" from my summary sheet to a separate worksheet and if the names match, bring back the most recent date...
September 15th, 2008 08:04 PM
by Txlonghorn76 Go to last post
7 87
Adding Cell to the left by cmatera
R57 may or may not contain a # If R57 contains a number I want to add the value of the cell to the left of R57 so Q57 to the value of anothercell..lets say...
September 15th, 2008 08:01 PM
by Andri Go to last post
3 69
Lookups??? by KevinUPS
I have two sheets of data that both have multiple columns and multiple rows. I am trying to populate the 1st sheet (one column / multiple rows) with data...
September 15th, 2008 07:50 PM
by Spiky Go to last post
2 73
Format Time as Text by bpc
I have a column of time values, (formatted for example as 14:50 or 6:15). I am flexible on the format of this column. In an adjacent column I need the time...
September 15th, 2008 07:50 PM
by Mike H Go to last post
9 65
Using SUMPRODUCT with a VLOOKUP by mae_bear22
Hi I have a spreadsheet that goes as follows. Column A is Salesperson's name and Column B is Achevied Sales Target (Yes or No). Column A gets it data...
September 15th, 2008 06:59 PM
by Mike H Go to last post
4 71
time tracking formula (trying again) by DebC
I am sorry to repost this question, but I have not received a response, and I cannot figure this one out. This forum has helped me previously and I know if...
September 15th, 2008 06:57 PM
by DebC Go to last post
9 94
Post New Thread


Display Options
Showing threads 20361 to 20380 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 11:23 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.