- Subscribe to this page:
- RSS
- Email Alert
formula
(247 results)-
Q&A
formula to find numbers in a range?
March 19, 2013 7:24am PDT
formula to find numbers in a range? in col b i have zip code 11557 and in col c i have zip code 11582 what i am looking for is to list the zip codes in between - like this: 11578 11579 11580...
1 Latest comment by joeodc
-
Q&A
How to sum up data with dynamic selection using formula in Excel?
October 15, 2012 1:28am PDT
How to sum up data with dynamic selection using formula in Excel? Hello all, How to sum up the data with dynamic selection using formula in Excel? For example: In row 1, I wanted sum up...
1 Latest comment by Stephen Lam
-
Q&A
Excel find and replace formula
October 7, 2012 8:35am PDT
Excel find and replace formula Hi everybody. I am forex and options trader. Options contracts look like this: 'GOOG 121005C770" or "GOOG 121005P770". I need to have a formula that can lookup the...
3 Latest comment by eilli
-
Q&A
blank formula bar
October 2, 2012 2:45pm PDT
blank formula bar After some editing, I noticed that the formula bar in an Excel 2010 workbook no longer displays the formula, although I can still access the formulas by clicking on the cell. Any...
3 Latest comment by bgrehan@...
-
-
Q&A
formula in excel that can find the last occurrence of each item in a list
September 20, 2012 9:54pm PDT
formula in excel that can find the last occurrence of each item in a list I need a formula that can find the last occurrence of each item in a list. Scenario: Column A(Products) Column B(Date of...
4 Latest comment by Ding_gi
-
Q&A
Crystal reports, using a summary field in a formula
July 16, 2012 4:48pm PDT
Crystal reports, using a summary field in a formula I wish to use summary data (min and max values) from a single database field within a formula that sets the value of a new calculated field. I...
-
Q&A
How can you create and maintain a column of historical peak scores in Excel
May 15, 2012 8:51am PDT
How can you create and maintain a column of historical peak scores in Excel I have a spreadsheet in the form of a matrix. Each row represents a client and each column represents a different...
2 Started by martin.peirson@... | Latest comment by Al Kostiuk
-
Q&A
Conditional Formatting of Specific Formulas
May 10, 2012 11:36am PDT
Conditional Formatting of Specific Formulas I have a conditional format for formulas but I need a conditional format that will evaluate a formula like =100+2000+225. We have situations where we...
1 Latest comment by Dukkman145
-
Q&A
Excel formula help
April 27, 2012 8:40pm PDT
Excel formula help Hello all, I'm in need of some excel formula help. In my free time (yeah right...) I like to fly and I've made a log book using excel to help me keep track of my flight time....
4 Latest comment by H60Driver
-
Q&A
How to cut an paste values within brackets in Excel
April 23, 2012 4:57am PDT
How to cut an paste values within brackets in Excel Hello Experts A1: Bahamas(21) My question, how can I cut and paste the value with brackets in B1?? which shud finally look as follows: A1:...
10 Latest comment by tanoyroy@...
-
Q&A
Excel 2010 Table Auto Format
April 20, 2012 8:46am PDT
Excel 2010 Table Auto Format I have a large Excel table where rows of data are entered daily. I have auto format turned on so that formulas and formats automatically copy to new rows - love this!...
1 Latest comment by ps2057
-
Q&A
How do i sum a formula field in crystal that won't allow me to?
March 26, 2012 10:12pm PDT
How do i sum a formula field in crystal that won't allow me to? I am new to crystal reports. I can't seem to sumarise a field and i think it has something to do with it being a formula. How do...
1 Latest comment by DanSym
-
Q&A
Ipad Office Applications
March 20, 2012 8:01am PDT
Ipad Office Applications Will any one of the Ipad office apps that you wrote about handle excel 2007 spreadsheets with a variety of complex formulas in it, I have a lot of vlookup formulas and...
1 Latest comment by innprofit
-
Q&A
excel 2007
March 1, 2012 4:23am PST
excel 2007 hi i want to compare sheets in one excel 2007 file for duplicate names to see if there are any, how do i do this anyone??? try a formula what you can do within a worksheet is to first...
4 Started by sallydj | Latest comment by Al Kostiuk
-
Q&A
How to type in numbers and formulae into MS exel document?
February 25, 2012 2:46pm PST
How to type in numbers and formulae into MS exel document? I have tried to type in numbers and formulae into MS exel document using the tablet (android) on-screen typewriter, but it does not work....
2 Started by malikhan@... | Latest comment by pcrx_greg@...
-
Q&A
working with 2 excel workbooks with changing worksheets?
February 24, 2012 12:57pm PST
working with 2 excel workbooks with changing worksheets? I have a workbook that contains a column that gets its information from cells from a different workbook. I am currenntly using the...
2 Started by scontiu@... | Latest comment by pttonka
-
Q&A
What formula in excel do i need?
January 25, 2012 1:24am PST
What formula in excel do i need? Hello I am stuck! When i type something in a cell eg. 1c, i need it to look at a block of cells, find the 1c in that block and then return the corrisponding...
2 Started by wolf24359 | Latest comment by Working IT
-
Q&A
Excel 2010 - blank cell but data show in formula bar
January 16, 2012 9:20pm PST
Excel 2010 - blank cell but data show in formula bar Hi there, i am now facing this issue INTERMITTENT. Half way using excel certain cells of my sheet will go white. when i point to formula bar i...
3 Latest comment by jamesmondtan@...
-
Q&A
How can I autofill a find duplicates formula?
December 12, 2011 2:37pm PST
How can I autofill a find duplicates formula? Formula is: =IF(COUNTIF(D$2:D$2,D2)>1,"Duplicated","") =IF(COUNTIF(D$2:D$3,D2)>1,"Duplicated","") =IF(COUNTIF(D$2:D$4,D2)>1,"Duplicated","") finding...
3 Started by robys@... | Latest comment by datta4office
