formula as cell reference

Hi all, In my worksheet the user will type a column letter or letters (such as 'GD') In another cell I want to calculate teh difference between the column number of the cell letter given by the user and start column (F, whcih will be 6) I tried this: =CELL("col",cell("contents",G23)) but get...

For Inventory, manufacturers barcodes are being imported or scanned into Excel, problem is that Euro barcodes bring in sometimes "=" as a prefix to the numerical value skewing what Excel reads, converting the number sequence into a "formula". I want to understand and convey to Excel that it is...

So i have a formula which reads like this =IF(((INDEX(RSheet1!A$4:$H$108,MATCH(Sheet1!BL$6,Sheet1!$A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))=0,forecast($C$6:$BK$6,$C$21:$BK$21,BL6),((INDEX(Sheet1!A$4:$H$108,MATCH(Sheet1!L$6,Sheet1!A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))...

Hello! I'm new here so bare with me. I recently started working for a company that uses a production date along with the normal date system. It is easy to understand while viewing the calendar but it basically works by week numbers, starting from the beginning of the year, then the individual...

I am looking to place a formula which will look like this: =min("A2:?2"), where ? depends on "number of columns". If number of columns is 4, then it should be D, E or Z. Number of columns is specified as an integer in range("B2"). I do not want to do it in a macro, want to do it in the...

Hi everyone i need help with creating a formula in the following instance..:confused: If value of cell in the range of E2 through to E17 is between 100 and 139 then +1 in K2 but i also need the '1' in K2 to remain even after the values in E2-E17 have been deleted and if another value in the...

What formula can I drag down for as many rows as I need that will take what is in the first two columns below and display the 3rd column below? Thanks for your help!!!! <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256><COLGROUP><COL...

I am using Win7, MS Xcel 2007. I currently have a template for doing cost calculations for products. I am trying to have one summary Xcel file with multiple embedded Xcel files, the embedded files being the calculator mentioned above. My goal is: A summary file would contain multiple...

This seems like it would be simple...I'm trying to find a way to use a the results of a function as a cell reference in a range. For instance, if I have a column of 25 numbers, say B1:B25, and I want to select a range from B1 to a row specified by another function--let's say the result from...