-
Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
-
Excel 2003. We are capturing grades for site reviews based on the scale listed below. On the report we need to indicate how the current grade compares to the grade from the previous period. Score Grade 1 F 60 D- 64 D 67 D+ 70 C- 74 C 77 C+ 80 B- 84 B 87 B+ 90 A- 94 A 97 A+ If the grade improves or declines...
-
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;...