-
Have a table of data and I need to interpolate a value. The row names are A,B,C,D and the column names have 0.5, 0.6, 0.7, 0.8 etc. If I want to look up in that table under row B for a column value 0.67, how would I accomplish that? Any ideas!?? Thanks!
-
I have a workbook that uses formulas such as =MATCH(ref,INDIRECT(ref2),0) where ref2 refers to whole columns or whole rows on another open workbook (such as "[test.xls]Sheet1!A:A" or "[test.xls]Sheet1!1:1"). These work perfectly well in Excel2003 but seem to produce error values in...
-
Hi all With the data below :- how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2
-
I have lost the use of the Workday and Networkdays functions. I am using Excel 2003. How do I restore the use of these functions?
-
Hi, I came, I saw, I joined because I have a problem. I am now off to ferret in the site to see the skills you members have and the fun involved in taking part here. First, though, my Problem....... The error message #NUM! comes up using the Rate % formula when getting a 6-month rate in the series below...
-
Hi everyone, I am trying to create a spreadsheet in excel that will count the number of "ticked" tick boxes in order to allow me to see at a glance how many samples have been tested. Don't know that much about excel apart from the basics, any help would be apprechated. Thanks in advance
-
Hello everyone, I've always found Excel to be the most flexible and easiest program to use. I'm trying to build a spreadsheet, and I need it do several specific functions. I've done a lot of experimenting, but have not got it all. I'm hoping someone here can assist me, or at the very...
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"High Tower Text"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable;...
-
Dear forum users, I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product. We have pre-defined max coverage and min coverage. On this picture you can see in red the max, in blue the min and in green the actual (projected) coverage. http://docs...
-
I am wondering if anybody can help me. I was always under the impression that it was not possible to convert formulas in excel into another language, but now I have found a website ( http://www.mytongue.biz ) that has a downloadable add-in which they claim will allow chinese excel users to use a thing...