-
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...
-
I am hoping someone can help. I need the formula to do the following: Column A Column B Column Ctext text number (acct ID) I want to match the text in ENTIRE Colimn B to ENTIRE Colimn A (named account name), when there is a match by account name, write the ACCOUNT ID FROM COULMN C tHANKS!
-
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!
-
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...
-
Ok I have a file with 2 sheets basically. Sheet 1 is basically a database of agents with their addresses, tel, details... With this database I created a table so I can move around easily. In Sheet 2 I created a standard contract for these agents. So I basically need to create 1 contract per agents and...
-
Hi, I need formula for comparing two columns. For Eg, Column A, Column B has datas, for Eg, In Column A has Names and Column B has E-mail Ids, If Both Name and Email Id repeates in the next row Column C should show its Duplicate Entry. Kindly Advice, Ram | ram@gmail.com | Unique Kumar | kumar@yahoo.com...