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
Formula (not adv. filter) to list unique values from list by Brian[_16_]
Howdy all, I have a list of names which appear multiple times in a column with about 20,000 entries. I want to create a list of the unique names on a new...
May 12th, 2009 04:33 AM
by Brian[_16_] Go to last post
3 97
IF Statement, multiple criteria by chickalina
Hello, I need to write an IF statement for the following sales commission calculation: If 1000 then *.05 If 1000 but 3999 then *.1 If 4000 then...
May 12th, 2009 03:04 AM
by Jacob Skaria Go to last post
2 76
i want to count how many times an entry occurs in an array by JCB
i am trying to count how many times a number has occured in the last 52 draws of the lotto ( 6 numbrs + two supplementry numbers
May 12th, 2009 02:59 AM
by Jacob Skaria Go to last post
1 103
HELP! Need to divide all columns by same number to get sell price by twoods403
I have a net cost sheet. I want to divide each of the 7 columns (which each have different values) by one number to get my sell price. When I looked at the...
May 12th, 2009 02:56 AM
by Jacob Skaria Go to last post
1 77
Calculation of Quarter by kashish
All year divided in 4 quarter as given below 1st quarter is from 28/12/08 to 28/03/09 (13 week) 2nd quarter is from 29/03/09 to 27/06/09 (13 week) 3rd...
May 12th, 2009 02:45 AM
by Ron Rosenfeld Go to last post
8 114
Nesting the roundup Function in a larger formula by boxarox
=((((PI()*E22)*1.3)*0.377))*((H22/J20))*TotalCaisson This is a formula for calculating the total weight of #3 rebar ties on a caisson Where E22=Caisson...
May 12th, 2009 12:21 AM
by Rick Rothstein[_2_] Go to last post
8 182
CountIf on Date / Time by RoadKill
Okay, so I have a new CountIf dilema. Will it work for a time field? My date/time field looks like this: 5/6/2009 12:01:00 AM. Is there any way to count the...
(Multi-page thread 1 2)
May 11th, 2009 11:10 PM
by T. Valko Go to last post
11 129
Excel Office 2007 by pjsicon
I have a spreadsheet I downloaded. On a select range of cells, when my cursor is placed within this range, it displays a box with some text. I want to delete...
May 11th, 2009 10:37 PM
by Ken Wright Go to last post
3 80
Find the Date of the Next Friday by Thomas M.
Excel 2007 This is driving me nuts, primarily because I know that I've done this before, but I just can't seem to zero in on the solution today, and I...
(Multi-page thread 1 2)
May 11th, 2009 10:05 PM
by Thomas M. Go to last post
12 122
Multiple criteria in 2 different columns for a sum in a 3rd column by Cyn
Trying to write a formula to fit this all info is on a different sheet in the same workbook. Masterdata(sheet name)( Column for 1st critera)...
May 11th, 2009 10:02 PM
by Cyn Go to last post
3 171
Drop Down List Question by NBragg
How do I edit a drop down list attached to a cell? We have a master template I need to revise and a former employee set it up.
May 11th, 2009 09:47 PM
by FSt1 Go to last post
1 73
Creating an if then function to manage deductions from different c by Michael Cook
I am trying to build a worksheet that deducts a value from each cell in a column in a row until the column equals zero and then begins deducting from another...
May 11th, 2009 09:42 PM
by Michael Cook[_2_] Go to last post
2 89
How to display result of 3 possible outcomes by Simony32567
I have created a spreadsheet for staff scheduling and want to display a result in a cell that could have 3 possible outcomes. Firstly if there is a value in...
May 11th, 2009 09:20 PM
by Simony32567 Go to last post
2 59
Conditional Formatting, multiple conditions by Wanda
Help! I'm using Excel 2007. I'm comparing old rates and tiers on a type of account to the new rates and tiers. Part of my worksheet is as below: A...
May 11th, 2009 08:35 PM
by Wanda Go to last post
2 82
How to paste phase and seperate into another cell by a symbol of. by Heather 0123
I want to be able to paste this into to excel and have it seperate in the next cell where the = sign is. WEOkToContact04 = yes As in A1 will show...
May 11th, 2009 08:30 PM
by Rick Rothstein[_2_] Go to last post
1 81
Conditional Formula by L in Cincy
I need help creating a multiple conditional formula. IF(A2=A1, and (P2 and p10, A, T)) Note: A1 and A2 are alpha - P1 and P2 are numeric.
May 11th, 2009 07:55 PM
by Eduardo Go to last post
1 81
forecast using a four parameter logistic equation by Laura
I need to find x-values according to a four parameter logistic equation ( y = (a-d)/+d How can I do this? I am not very familiar with solver. I have used...
May 11th, 2009 07:17 PM
by Bernard Liengme[_2_] Go to last post
1 136
Print first column on each page by texan-in-colorado[_2_]
I wondered if there is a way I can print column A on several pages? It's my training matix so there are names and dates tests are taken in the other colmns...
May 11th, 2009 06:44 PM
by Jacob Skaria Go to last post
1 70
why does excel 2007 subtract 2009 from 2015 = 1900? by Penny32
have tried different formats for the dates, always comes up the same. have formated in date/time format,...
May 11th, 2009 06:19 PM
by Harlan Grove[_2_] Go to last post
7 90
VLOOKUP results is duplicating first value by RaeW
Hello, I read thru the posts but didn't seem to find my exact issue, so can someone help me? I'm using a partnumber in one sheet that is missing the supplier...
May 11th, 2009 05:42 PM
by T. Valko Go to last post
2 75
Post New Thread


Display Options
Showing threads 11201 to 11220 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:25 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.