Threads Replies Last Post 837 Pages: 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  26  27  28  29  30  >>   Conditional sum matching two columns and a row I have a program that exports data to excel arranged like the following: Property 1 Property 2 Property 3 Person1 Code1 10 (Hours) Code2 Code2_OT Code3_OT Person2 Code2 40 ... 10 26.09.2006 18:28:36 VLookup or Something Else? Hello- I have 2 spreadsheets. Spreadsheet "A" I have Raw Data with a unique ID code in column A. I have made a pivot table with this data which is in column D on the Pivot Table. Spreadsheet "B" has a TON of stuff in it - including the unique ID in column Q. I want to find, match, lookup the ID in column Q and get the data from column G to put in my pivot table in spreadsheet "A... 2 26.09.2006 17:50:13 pasted column splits at spaces I have a single column in SQL query analyzer data. I copy the one column to a single column into Excel and it creates a new column for ever space... so "client without insurance" become A Client, B Without, C insurance. It didn't used to do this.... 2 26.09.2006 17:34:03 count text strings in an entire workbook I'm having a problem which led to another problem. I'll tell you about both because either solution would get me to where I wasnt to be. 1. I created an excel workbook which is serving as a template. In its base case version there are four tabs with the titles: bond 1 present, bond 2 present, etc. An additional tab called "pointers" is up front with input info for each case 1-4, or ... 2 26.09.2006 17:29:02 formula to auto populate zip when city is typed in Excel I have a data base with multiple small cities, they each have only one zip code, and I would like it if there is a formula that would auto populate the zip i.e. If C4=Montrose then C5=84070. Thanks for the help... 4 26.09.2006 17:05:07 COUNTIF with two criteria's Hi, I am trying to add one more criteria to the below formula and cannot figure it out. Need to locate how many "C" with "GTS". Both are in different rows. This is what I did..but it doesn't work and have been working on this for the past couple of days. Pls help..thank you =countif('2006 PMR Schedule'!D5:D7,"C")+('2006 PMR Schedule'!E5:E7,"GTS")... 5 26.09.2006 17:01:02 Selecting different multiple columns Hi, I have a spreadsheet, which uses the colour of the first cell in a column, to indicate the team that the column belongs to. I would like to be able to select multiple columns (between B and AB) based on the colorindex of this first cell. For example, if the colorindex of Columns B, D, J and Z is 10, I would like to hide all columns in the range ("B:AB") and then unhide columns B, D,... 2 26.09.2006 16:58:36 Protect a worksheet with a password I have 20+ worksheets in a single workbook - I want to protect only one of those worksheets with a password. (I don't want anyone to be able to view that specific worksheet unless they have the password.) How can I do this?... 3 26.09.2006 16:51:25 How to save my VBA-code Hello, I made a small code in VBA. But when my colleague open the spreadsheet he can´t use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance ... 5 26.09.2006 16:46:43 lookup data I have a spreadsheet with a column that must have a specific code inserted. I have a separate spreadsheet with the code and correlated info. How can I created a lookup field in that one column that allows me to choose from the codes in the second spreadsheet as well as see the correlated info for each code?... 2 26.09.2006 16:44:03 Whatsthe formula which retrieves a # from a multiplication table I have a table that is similar to a multiplication table. I would like to write a formula in a single cell (example A3) that retrieves data from a table by matching values typed in cells A1 and A2 (Example1: A1 has the number 5 typed in and A2 has the number 10 typed in). A3 should result with a 50.) (Example2: A1 has the number 6 typed in and A2 has the number 3 typed in). A3 shou... 5 26.09.2006 16:28:02 Lookup text then copy over to new cell I have a spreadsheet setup and in one cell there are address details but in between the address details there is a square symbol. In some of the cells there are up to 6 different address lines with some only have 1 or 2 address lines in there. What I would like it to do is take the text from Initially before the first symbol and bring that text into an address line 1 cell and then fro... 4 26.09.2006 15:52:02 Pasting Excel data into Word doc. Hi, I would like to paste the contents of an Excel cell, that is the last entry in a range, onto a specific location of a Word document. Any help would be greatly appreciated. Mike ... 1 26.09.2006 15:38:46 formula to lookup value and return value from cell at left of target Can someone help with a formula to return a value from this lookup. I have created an example of the lookup I need. The target range is a range of (say) three columns. I want to lookup a value from the third column and return the value from the first cell in the corresponding row. eg three columns (A, B, C) 4 rows (1,2,3,4) Description Qty Code Desc A 3 1 Desc B 4 2 Desc C 2 3 ... 13 26.09.2006 15:38:43 user cannot access his share workbook on network drive. I've created a shared workbook which is used by 15 users. They are in a network domain and access the shared workbook by accessing it through a path to a network drive I have created for this department. One user can access the network drive where the shared workbook is located, but he cannot open the shared workbook spreadsheet. He is the only one experiencing this problem, and I a... 1 26.09.2006 15:30:02 Consolidate data from multiple sheets Let me apoligize for the vagueness of this questions ahead of time... I was handed a spreadsheet belonging to my CFO made up of about 40 tabs. Each tab represents a transaction and is similar although not identical in layout; The top portion is essentially a form that calculates income. The bottom portion converts the calculations into Journal entries. The journal entries may pertai... 1 26.09.2006 15:25:01 vLookup with multiple lookup value in table array Hi, I'm trying to use a vLookup and running into trouble. On the table array that I'm looking in there are multiple instances of the lookup value. Does anyone have any recomendations for a quick/easy way to got the totals of the multiple lookup values? Thanks! ... 3 26.09.2006 15:12:46 present value formula I need a simple formula to get the result says, 48,000 (pmt) in 4 years time to 44,678 (present value) See below example Pmt 5% PV Year 0 (12,000) 1 (12,000.00) 1 (12,000) 0.952380952 (11,428.57) 2 (12,000) 0.907029478 (10,884.35) 3 (12,000) 0.863837599 (10,366.05) 4 (48,000) 3.723248029 (44,678.97) Please help... 3 26.09.2006 14:28:30 HOW TO CHANGE BETWEEN THE SHEETS AND ONE MENU AS THE SAME WAY THAT WE CHANGE THE WINDOWS IN THE EXPLORER WITH ALT+TAB HOW CAN WE CHANGE BETWEEN THE MENU OF FIND AND THE SHEETS TO USE ONLY THE KEYBOARD, THANKS A LOT... 2 26.09.2006 14:14:02 IF VLOOKUP Nested function I have a formula that returns a lookup value =VLOOKUP(A10,VarietyLookUpTable!$A$2:$C$56,2,FALSE) but when I try to make it so that there is no value in the cell if the reference cell is blank =IF(A12,VLOOKUP(A12,VarietyLookUpTable!$A$2:$C$56,2,FALSE),"") It only works if the cell is blank, if there is a value in the cell which is formatted as text I get the #VALUE! instead of the usual res... 6 26.09.2006 13:49:03 How to open a workbook on a specific worksheet. Can anyone show me how to have a multiple page workbook always open to the same worksheet. (Splash Page) Thanks Kevin... 3 26.09.2006 13:21:02 Counting data over multiple worksheets Hi all, I have run into the need to be able to count data over a large number of worksheets that all have an identical format (so cell D4 has the same type of data in it on every page). I want to be able to count the number of occurances that cell D4="Division" and N12>0.6 I currently use a combination of sumproduct, countif, and indirect, but I can't figure out how to get it to count bas... 2 26.09.2006 12:53:35 How do I use the IF formula to flag dates 21 days prior to deadlin I am trying to set up a spreadsheet that will flag me 21 days from the date I send out documents. So that I can follow up on those documents.... 2 26.09.2006 12:29:02 SumIf two axes How can I sum cells in range B2:F10 based on two criteria: * A2:A10 = "XXX" * B1:F1 = "YYY" Thanks, Oscar.... 4 26.09.2006 11:59:11 CHANGE SHEET I WOULD LIKE TO CHANGE FROM ONE SHEET TO ANOTHER WITH A COMBINATION KEY AND NOT HAVE TO USE THE MOUSE EACH TIME THAT I HAVE DO IT. THANKS A LOT ... 3 26.09.2006 11:55:02 837 Pages: 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  26  27  28  29  30  >>