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
Need help with a function for a golf match spreadsheet by Bodman34
I am a High School golf coach and I would like to be able to rank 12 scores from 2 different columns and assign a point value based on their finish. Since...
April 21st, 2009 06:43 PM
by T. Valko Go to last post
1 158
Countifs by CD27
I am having problems with a formula. I have a worksheet with 9 columns (A thur I) that contain various numbers. I need to create a formula that if any cell...
April 21st, 2009 06:36 PM
by CD27 Go to last post
2 73
Random Sample with multiple data points by Jeremy
I have a list of people with a large number of lines per person. I need to randomly select two lines for each person. The report is preformatted and...
April 21st, 2009 06:18 PM
by Gary''s Student Go to last post
1 71
Math Functions Not Working Properly by Harby
I've just noticed that none of my functions are working properly. For instance, if i insert the numbers 1(cell A1) and 10(cell B1) in adjacent cells and...
April 21st, 2009 06:17 PM
by David Biddulph Go to last post
3 77
April 21st, 2009 05:39 PM
by CD27 Go to last post
1 90
Vlookup Using a Reference as a Table Array by EmJa
I want to use a cells value as my Table Array since the file that I am using for the lookup varies. For example, I put the Table Array value in column C,...
April 21st, 2009 04:58 PM
by Domenic[_2_] Go to last post
1 63
Count if unique by Gareth.Evans
Hi all, thank you in advance for your help ,and help in past. I am trying to count the number of "yes" in column C if Column A has a unique value, see...
(Multi-page thread 1 2)
April 21st, 2009 04:48 PM
by Jarek Kujawa[_2_] Go to last post
13 162
Excel: graduating fees based on account value by DM
I am creating a fee schedule for an account. The fees will decrease as the account value raises. What formula(s) are best to use to make this work?
April 21st, 2009 04:20 PM
by Pete_UK Go to last post
1 108
Excel Formula by markillas44
I want to create/use a formula where if a value in column (K) is DEAD (term used in a drop-down menu in the column) the value in the corresponding (I) column...
April 21st, 2009 04:17 PM
by Pete_UK Go to last post
1 75
Protect cell but allow copy command? by Cindy
Do you know of a way to protect the cell of a worksheet but allow user to input data? We need to find a way to allow user to input their own data but not...
April 21st, 2009 03:16 PM
by Staffan Cronstrom[_2_] Go to last post
7 163
Running Total by open a adobe file from a command button
I have a spreadsheet that has 2 columns, column A grows, column B shrinks, when column B gets to 0 or a negative number I want column A to be blank. Thank...
April 21st, 2009 02:16 PM
by Fred Smith[_4_] Go to last post
7 103
Need a function to match up jobs by Lynda
I have a master sheet with about 50 different job descriptions, then I have about 20 more worksheets that could have between 20 and maybe 40 job descriptions...
April 21st, 2009 01:59 PM
by Lynda Go to last post
2 111
how do i filter records with greater number across rows by Scouvy
I have a worksheet with 9 columns and 1883 rows. My main focus is on column b and c. Column b has file numbers and column c has the file revision numbers. I...
April 21st, 2009 01:06 PM
by Eduardo Go to last post
1 72
Validation I Hope by MarsBars
Data entry project - keeps changing & I am not as up to speed in Excel 2007 Select Data for Major Category - i.e. Appliances, Furniture Sub Category -...
April 21st, 2009 09:22 AM
by JLatham Go to last post
1 75
how to add date and time to a single cell in MS Excel 2007 by Anil123
Hi, Iam trying to add date column ( 01.03.2009) and time column (23:30:00) to a single cell to get the result as 2/28/2009 23:30 using the formula...
April 21st, 2009 07:24 AM
by Anil123 Go to last post
5 114
Excel Conditional Formatting (Compare Vals in 2 Columns) by [email protected]
I want to use Conditional Formatting to highlight numeric cells in one column that are less than the value of cells in lower records and an adjacent column. I...
April 21st, 2009 04:25 AM
by T. Valko Go to last post
3 98
A UNIQUE FORMULA by FLATRATE
EXAMPLE: I want to multiply one cell with a dollar amount in it, by a cell that has a quantity of employees in it. I want the dollar amount to remain the...
April 21st, 2009 02:37 AM
by FLATRATE Go to last post
5 63
Copying Conditional Formatting rule by Hartmut \(Harry\) Kloppert
Hi, I'm using XL2007. I'm applying the rule that if =A$1"" the cells A1;A3 should get colored. Works fine. Now I have to copy this rule to 40 other places...
April 21st, 2009 02:28 AM
by Sheeloo Go to last post
1 72
Accumulated percentage calculation by Terence C
Dear all, I have a pivot table that showing the following data: Sum of Sold Qty Shop A Shop B Item A ...
April 21st, 2009 01:12 AM
by Herbert Seidenberg Go to last post
2 71
add another subtotal row to an expense column? by 947tefi
How can I add another subtotal row to one column? I know how to add a subtotal row but I need to add another one for a specific column that is on the same...
April 21st, 2009 12:36 AM
by 947tefi Go to last post
0 105
Post New Thread


Display Options
Showing threads 11941 to 11960 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 01:28 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.