Topic profile page for Formulas.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Formulas.
Topic "Formulas" was discussed 70,456 times on 3,965 sites in last 3 months
Started 12 hours, 21 minutes ago (2009-11-27 01:30:00)
by Jon Johny
Making all Formulas in a range Absolute Refrences - Is this possible? Is there any way to make all formuals in certain range absolute refrences? I want to do this becasue I want to use the sort function in a table, and if the formuals are not absolute refreces and I perform a sort the values change.
Started 17 hours, 29 minutes ago (2009-11-26 20:22:00)
by Jon Johny
Excel 2003 and array formulas -is it not supported? Im using Excel 2007 and recently had to save the file as 2003. There was a problem with the array formulas. Does Excel 2003 not support array formulas? Here is my formula: {=SUM(IF(FREQUENCY(IF(LEN(Reps)> 0,MATCH(Reps,Reps,0),""), IF(LEN(Reps)> 0,MATCH(Reps,Reps,0),""))> 0...
Started 1 day, 10 hours ago (2009-11-26 03:43:00)
by user5457484
Hi, Seeded Integrator "CWB Worksheet Integrator" in Compensation Workbench module have embedded formulas in the excel sheet. When the document is created, the downloaded sheet has embedded formulas in it. If anyone has any information regarding this, Kindly pinpoint this to me. I am in need for this for our urgent customer requirement. Thanks ...
Started 1 day, 18 hours ago (2009-11-25 19:05:00)
by amj2764
Autofilling formulas Is there a way to get the formulas from one row to automatically copy down into an inserted row without me having to fill down everytime I insert a new row?
Started 1 day, 18 hours ago (2009-11-25 19:00:00)
by Alteran
VBA Code insert new line & Formulas I am trying to make this code insert a new line from a user sheet, and add some formulas for me, however for some reason it keeps adding a line not on the LastRow as I specify It over wrights the whole first row. I am not sure where I am going wrong, and could use an extra set of eyes to look to ...
Started 1 day, 21 hours ago (2009-11-25 16:32:00)
by leonard
I have goolged and binged, but I can't find the actual, exact formulas that are used for cross testing New comparability profit sharing plans. Can anyone point me to a source for the exact formulas and testing methodologies for crosstesting a New comparability plan? Reason: I am working on setting up a new comparability plan w/ a safe harbor 401k for my current employer and need to set up...
Started 1 week ago (2009-11-20 04:38:00)
by Ks1102
Counts formulas Experts please helps Do any formulas can help me to count number of whichs on Col C hows number greater then 12:00??? Col C = > 12:00 Col D is Blank Ks thanks
Started 6 days, 22 hours ago (2009-11-20 14:55:00)
by CarolinaGirl61
Removing Formulas from Entire Workbook consisting of multiple sheets I have multiple sheets in a workbook that all contain formulas. I need to remove ALL formulas on a regular basis and email to various users. Is there a way to automate this process so that I'm not copy/paste values on each worksheet?
Started 6 days, 1 hour ago (2009-11-21 12:00:00)
by Ks1102
looking help formulas. Looking for help Its might sumproduct formulas but, trying overs a day it not be work! Does any one have idea? col A = amount col B = Bill's col c = o or 1 how do i sum the total amount of the Bill if col c = 1 ??
Started 4 days, 9 hours ago (2009-11-23 04:32:00)
by HimThruMe
VBA Code to make all formulas update? I have a workbook with multiple sheets that have formulas on them that all rely on one sheet being updated manually... im noticing that for some reason the formulas dont always update... i have to actually click on the formula bar and click the green checkmark for it to update with the correct ...
Started 5 days, 1 hour ago (2009-11-22 12:15:00)
by Legal Beagle
Poker spreadsheet - help with formulas needed!! Hi there, am new to the board - very glad I found it though - what a great resource! Anyway, I need some help with formulas for my poker spreadsheet (see screenshot below) which I set up to track mine and my friends winnings/losses who I play poker with once or twice a month. So I have...
Started 4 days, 3 hours ago (2009-11-23 10:26:00)
by Ks1102
formulas check pleased Thanks all's Anyone have idea whats I made wrong as I wanted count the piece base the time range? The formulas was retuned inaccuracy =SUMPRODUCT(WallData!$G$2:$G$8000,--(WallData!I2:I 8000> =TIME(12,1,0)),--(WallData!J2:J8000
Started 3 days, 7 hours ago (2009-11-24 05:54:00)
by ceabastion
insert formulas into variable columns Hello everyone, I suspect there is a fairly easy solution to my problem. I would like to have a macro insert a series of formulas into variable columns. But am not sure how to make the column address variable. Ex: Private Sub example_click() i = 1 Do While i < 5 ...
Started 6 days, 19 hours ago (2009-11-20 18:46:00)
by realized
Please Register to Remove these Ads Every week i put together a new excel file, the first few columns change but after that the next few are all formulas and they are all static. for example Colum A, B, C, and D change weekly. But E is ALWAYS: "=D2*65%" (applied down each row so next one is =D3, etc." Row F is always "=ROUNDUP(E2,0)-0.01" Row G is ...
Please Register to Remove these Ads I have a template work book that has several worksheets with numerous formulas thorughout. For example; =SUMPRODUCT(--ISNUMBER(SEARCH("MCSH",P9:P218)),--I SNUMBER(SEARCH("HWD",G9:G218))). When I set up another template for a different crew I manually have to go through the entire work book and change the crew identifier (MCSH) in...
Started 2 days, 2 hours ago (2009-11-25 10:58:00)
by ZeeAndOliver
I take it your not in the uk lol We have different brands here. Ollies on follow on milk and usually use Hipp organic..but on the odd occasion have used SMA and cow and gate. Like you say, I think they are all the same but I suppose some people find that one particular milk 'agrees' with baby more than another. But I don't think its a bad thing..if anything I like to change every so...
Started 1 week, 1 day ago (2009-11-19 03:23:00)
by Ks1102
Formulas help............Pleased Hi all Looking help pleased, Do any way as I wanted to looked up the numbers of which products distribution by time segment, as sample below, Sheet1 COL C 3 to down = products Sheet1 COL I 3 to down = time and format is 00:00 Sheet2 Range A1 = time 12:00(Which is the ...
