multiple functions in a single cell

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Worksheet
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Extract info from one sheet to another I am trying to pull data from worksheet to another. I would like to search for text found in one sheet and return a relative value from a different column . Here is an example Worksheet 1 contains a coumn of values: apple orange banana Worksheet 2 contains two columns: apples (red delicious) red apples (granny) red oranges (florida) orange banana yellow In Worksheet 1... If the string apple is found anywhere in Worksheet 2, column 1, I would like it to return the color from Worksheet 2, column 2 and place it column 2 of Worksheet 1. Any suggestions? Thanks! Tag: multiple functions in a single cell Tag: 497639
  - 2
    - Embedded Video This may not be the right forum, but I can't find one that seems to suit this Q. I am trying to embed a 1.2MB MPG into an Excel 2003 spreadsheet so that users of the spreadsheet can click on the icon and watch the video. It will not work. I am going to Insert, Object, Create From File, and once I chhose the file and click OK, Excel freezes. Any help? Thanks Tag: multiple functions in a single cell Tag: 497636
  - 3
    - Sumif with multiple columns in sum_range Hello, I have a set of data that has a label in column A the sales in column B, C & D: Column A Column B Column C Joel 500 677 Joel 575 752 Joel 650 827 Claudia 725 902 Tarzan 800 968 I'd like to run SUMIF where the "Range" is column A, the "Criteria" is Joel, and the "Sum_Range" is B:C but when I use SUMIF(A:A,"Joel",B:C) I only get the sum of column B which is 1,725. Can someone hook me up with a formula that can sum both column B & C in this situation. Thanks, in advance Daniel Tag: multiple functions in a single cell Tag: 497631
  - 4
    - SUMIF vs SUMPRODUCT I was using the SUMIF command as follows (=SUMIF('Active Data'!Z:Z,2,'Active Data'!AK:AK) ("Active Data" is the previous tab), and the formula works great!.... until the criteria for the calulation changed. Now I require 2 sets of criteria before I sum the AK:AK column. I changed the formula to(SUMPRODUCT(('Active Data'!Z2:Z1000=2)*('Active Data'!BE2:BE1000=1)*('Active Data'!AK2:AK1000)). The additional data is coming from column BE. Apparently the SUMPRODUCT doe not like my referencing the Active Data tab. This formula returns the ever popular #VALUE! answer. Column Z is the month code (Feb), column BE is a customer code (1,0 or -1), and column AK repersents the hours of service. The formula should result all the hours worked(AK) in Feb(Z) for all the customers with criteria "1" (BE). (in this case 408 hours worked.) Tag: multiple functions in a single cell Tag: 497624
  - 5
    - Formula for assigning distinct name to first instance in a list of I have a spreadsheet of 3000 contact names I am trying to assign these in the most "fair" fashion to account resps. My thought was to create a column called "account_rep" I then put account_rep_name1 account_rep_name2 account_rept_name3 In, colum1,Row 1 account_rep_name1 colum1,row 2 account_rep_name2 colum2,row 3 account_rept_name3 colum1,row 4 account_rep_name1 colum1,row 5 account_rep_name2 colum2,row 6 account_rept_name3 the pattern continues respectively through the list to row 3000. However, what has happened is that there may be more than one account rep assigned to an account. For example in the list I have. account_rep_name1 Suzie Queen ABC Company account_rep_name2 Suzie Queen ABC Company account_rept_name3 Suzie Queen ABC Company so, I want to assign unique rep to the account the first time his name hits the account down the list. What is the best way to do this? Thanks, Robert Tag: multiple functions in a single cell Tag: 497623
  - 6
    - formula required to return data from one column Hi, I have a query on some data i'm currently analysing and it's causing me a headache. I'm hoping there is a simple solution to this that doesn't involve macros. Any help much appreciated Sample data: this is what i have in one column of data at present. each name beneath a port represents people working at that particular port. However, what i want is in the column along side this data for it to show the port name that each employee works at. what i have at present is as follows; cell a1 port:rotterdam cell a2 richard cell a3 david cell a4 paul cell a5 port:south africa cell a6 james cell a7 sam cell a8 keith cell a9 duncan cell a10 port:port talbot cell a11 simon cell a12 rachel what i'd like to see is a formula in column B to return the relevant port for each individual (shown below) It is a large document with over 5000 rows so a formula is a must if possible. column A column B Port: rotterdam Richard rotterdam David rotterdam Paul rotterdam Port: south africa james south africa sam south africa keith south africa duncan south africa Port: port talbot simon port talbot rachel port talbot Tag: multiple functions in a single cell Tag: 497622
  - 7
    - formula for selecting cells in one table from values in another I have a table that I created in a GIS of tax parcel numbers that are in a specific zoning district. I have another table that was created in my tax assessing program of all tax parcels in town with parcel location address, owner, mailing address, etc. I'm trying to write a formula that will match the individual lots in the GIS table and select only those in the assessment table that match and returns the parcel #, Location , Owner and mailing address. GIS table 101-005-000-000 105-002-000-000 201-220-000-000 Assessing table 101-001-000-000 221 Lark Street Joe Blow PO Box 111 Belmont, NH 03220 101-002-000-000 222 Lark Street Jane Cool 221 Lark St Belmont....... 101-003-000-000 223 Lark ...... ..... .... ... 220-099-001-000 10 Downing St John Major 2244 Beacon St Boston ..... Tag: multiple functions in a single cell Tag: 497620
  - 8
    - Not sure how to write the formula I am fairly new to writing formulas. The formula I always use is F2-J2/I2. Pretty simple, except when I2 has no data or is zero then I get the #DIV. How do I either keep the #DIV from showing or write the formula in such a way that it basically says: If I2 is less than, equal to or has no data then leave blank, if not process the above formula. Tag: multiple functions in a single cell Tag: 497617
  - 9
    - select printer macro morning, i'm using Office 2007 on Vista, and i have the following event recorded in "thisworkbook" Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Purchase Order (Inventory)" Then Cancel = True Application.EnableEvents = False With ActiveSheet .PrintOut Call POInv End With Application.EnableEvents = True End If End Sub it works, but the problem is it sends the print job to the last used printer or the default printer. i want to beable to select the printer before it prints - maybe another macro gets called or something. any suggestions on getting the macro to select a printer. thank you, jat Tag: multiple functions in a single cell Tag: 497615
  - 10
    - Proper Formula is stuck and does not work Hello, I was wondering why my text formula of proper is not working. I have placed the formula =proper(f2) in column e2 All I get is the formula =proper(f2) and nothing else. It looks like it is stuck. When I try to copy down the whole column e has the same formula. I have tried formatting column F to text and General and the formula does not do anything. I have had this problem in the past with other formulas. Chris Tag: multiple functions in a single cell Tag: 497614
  - 11
    - If statement formulas I have two sheets in a workbook. One called Availability, and the other called schedule. The availability tells what time my employees are available to work and it look like this: A1 B1 C1 Name Start End Tom 6 AM 2 PM Jason 9 AM 5 PM John 1 PM 9 Pm Susan 8 AM 4 PM In the schedule sheet look similar to availability sheet accept it has one more column that will if I schedule an employee that will have a time conflict with availablity sheet. Look like this. A1 B1 C1 D1 E1 F1 Name Start End Jason 8AM 5 PM Not available before 9 am Susan 8 AM 6 PM Not Available after 4 pm John 6 Am 12 PM Only available from 1pm to 9 pm Tom 6 AM 2 PM Notice I added three more column. One tell a statement such as "Not Available Before", "Not Available After", and "Only Available From". The other two column tell if Column D has a statement such as "Not Available before", then column E specify the time that particular employee not available before what time. Similary, with "Not Available after" column E specify the time that particular employee not available after. Similary, if column D statement says the time is out of range or "Only Availbable From", specify the start time in E column and end time in F column. If time is within range then don't do anything or display blank. Notice the names of my employees in shedule sheet are not in order with the name of my employees in the availability sheet. I probably need vlookup formulas as well? What formulas do I put in cells of Column D, E, F the get the deserve effect from above? Thanks Tag: multiple functions in a single cell Tag: 497612
  - 12
    - look up and data extraction I am trying to verify that specific numbers are assigned to other specific locations (numbers or alpha characters). The numbers in question can be assigned up to 5 other numbers or alpha locations. Please see example: material assignment 001575-0393 0100 001575-0393 SIM 001681-0828 0100 001681-0828 0400 001681-0828 0401 001682-0828 0100 001682-0828 0400 001682-0828 0401 I want to check that 001575-0393 is assigned to 0100, SIM, and 0101. I would like to know when they are assigned to the required numbers, assigned to any other number not specified, or if the assigned number is not listed. In the example above, 001575-0393 is assigned to 0100 and SIM when it should be assigned to 0100, 0100, and 0400. I would like to display the assigned number and the locations that are incorrect. Any help would be greatly appreciated. Thank you, Robert Tag: multiple functions in a single cell Tag: 497608
  - 13
    - How do I stop the headings moving when I scroll down? What I want to do is set up a couple of my bohemoth spreadsheets so that when I scroll down to look at the values below the bottom of the sheet the headings don't disappear - basically I want to 'anchor' them somehow. Tag: multiple functions in a single cell Tag: 497606
  - 14
    - PLZ help me with MACROS Macros help I accidentally hit disable on my workbook then closed. Now when I try to open my workbook (that now has a xlms extention) I get This file is not a recognizable format, how do I get my work back to where it was? Tag: multiple functions in a single cell Tag: 497604
  - 15
    - Macros help I accidentally hit disable on my workbook then closed. Now when I try to open my workbook (that now has a xlms extention) I get This file is not a recognizable format, how do I get my work back to where it was? Tag: multiple functions in a single cell Tag: 497603
  - 16
    - sorting data from one sheet to another SHEET1 SHEET2 A B A B 1 JOBID MATERIAL 1 JOBID MATERIAL 2 8Job1 concrete 2 3 8Job2 drywall 3 4 8Job3 mason mix 4 5 8Job1 nails 5 6 8Job1 4x2 panels 6 7 7 8 8 #1) I need SHEET2 to gather & sort through data from sheet 1. I need to set it up so that when I enter a JOBID in SHEET2 A2, "ALL" materials from SHEET1 associated "ONLY" with the specified JOBID shows up in the Material column of SHEET2. #2) Data from SHEET1 will continuously be changing on a daily basis as new data (JOBID & MATERIAL) is added each day. I need to be able to set it up so that as data is entered in SHEET1, data is also being automatically updated in SHEET2. For example, if today I enter 8Job1 in SHEET2 A2; the words "concrete, nails, 4x2 panels" show in SHEET2 B2:4. Then, 5 additional materials with the 8Job1 are entered throughout the rest of the day. Tomorrow morning I would like to see those 5 new items in SHEET2. NOTE: both numbers and text will be used in data cells (i.e. 8Job1). NOTE: I am using EXCEL 2007. Is this possible? Can anyone help? Tag: multiple functions in a single cell Tag: 497602
  - 17
    - i want to learn MS OFFICE from micro soft from pakistan Tag: multiple functions in a single cell Tag: 497595
  - 18
    - copying cell links with fixed number in between In a column someone wants a reference to another cell. They want this for a large nr. of cells, with 15 in between =D15 =D30 =D45 =D60 and so on I can build a simple VBA module to get this done, but the whole in itself is variable (for some purposes 15, others 18, in another sheet it'll be a different column) and the user who needs to do this won't be able to change anything in the VBA stuff. They will also need this in more worksheets. I've checked 'paste special' but it doesn't seem to have any functionality for this. Any ideas? Tag: multiple functions in a single cell Tag: 497590
  - 19
    - Fresh pair of Eyes required Hi, with the help of some excellent feedback from the User Group I have created the following formula but I am not getting the expected results The formula works finre until I put the 2nd search for a particular word.. eg This works fine =SUMPRODUCT((('Grid data'!B2:B4557=A2)*(ISERROR(SEARCH("shine*",'Grid data'!D2:D4557)*((('Grid data'!F2:F4557="NS")+('Grid data'! F2:F4557="C")+(TRIM('Grid data'! F2:F4557)=""))))))) And counts correctly, ignoring anything with SHINE in column D and only including, blanks, C and NS values. The following formula I am not getting the right results. It appears to be ignoring the search for "NON" in column E. =SUMPRODUCT((('Grid data'!B2:B4557=A2)*(ISERROR(SEARCH("shine*",'Grid data'!D2:D4557)+(SEARCH( "non*",'Grid data'!E2:E4557))*((('Grid data'! F2:F4557="NS")+('Grid data'!F2:F4557="C")+(TRIM('Grid data'! F2:F4557)=""))))))) Paul Tag: multiple functions in a single cell Tag: 497586
  - 20
    - Sorting CF Color Hello and thanks ahead for your help. I have a row of data that is CF to turn red when true. Then I would like to sort this row to put uncolored cells to the bottom of the list. I have gone to Chip Pearsons sorting CF Colors Page and have tried ColorOfCF and ColorIndexOfCF and allways I get #NAME?. When I enter =ColorOfCF($A$1,FALSE) into theformula bar for B1, the Formula box pops up and shows all entries resuls correct (no errors) but at the bottom it shows "undefined" and the resuls show nothing (results= ), so when I click the OK Button the cell shows "#NAME?" I've placed the codes in my Sheet1 Code Box, this is the sheet I'm using to test these codes, Only A1 has a CF in it at this time.If I can get this to work I will enter data thru A10 and fill down B1 to B10 and there should be numbers in these B1:B10 cell if there is color in the corresponding cells. Right? What am I doing Wrong? Thanks again John Tag: multiple functions in a single cell Tag: 497580
  - 21
    - Button funtion maybe!! Im wondering if the following is at all possible in excel? I want to place a button on the worksheet that on enter (press) it would duplicate and insert a selected cell range (with formulas) at a set location below the selected cell range.? Tag: multiple functions in a single cell Tag: 497575
  - 22
    - Colour multiple cels using range.. I am aware of conditional formatting, but what I want to be able to do is colour multiple cells on a single row based on the 1st cell (being a date) equalling a date in another work sheet, as conditional formatting only allows the function to work on the worksheet that the function is placed in. Tag: multiple functions in a single cell Tag: 497574
  - 23
    - How to create primary/secon single click checkbox line autopopulat I want to create a checkbox type spreadsheet that will autofill line data to a total sheet. What do I use? Formulas? Which one, and how? Ex>>>Cell H63 will be filled in with the amount in F55 if I check G55. Then check a secondary, (G45), and H64 will will autofill with F45 F G 45 103 (X) checked second 55 87 (X) checked first 72 19 (X) checked last AKA...Applicant 87 (H63) first to populate Spouse 103 (H64) Second Child 19 (H65) next and so on Tag: multiple functions in a single cell Tag: 497573
  - 24
    - Excel copy and paste I did something dumb. When i copy and paste a formula, the correct formula copies but the original copied number is displayed. ie cell g4 (8) - cell g5 (4) = cell g6 is, g4-g5, displays 4.00 typical copy and paste ie cell h4 (25) - cell h5 (4) = cell h6 is, h4-h5, BUT displays 4.00 AGAIN !!! help please Tag: multiple functions in a single cell Tag: 497571
  - 25
    - VB routine to print to PDF? I'm trying to write a routine that will print a pdf page. I need to make this a routine because I have to loop through a large set of data and print a pdf page for each row of the data. My typical method for writing a routine is to record a macro and then modify the module I created. Unfortunately, when I print to pdf using acrobat distiller, the macro does not record all the steps. In particular is does not collect the filename or location. Here is the macro I created when I recorded my keystrokes: Sub pdfPrint() ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub I need to specify the filename and location in the macro (different for each row). Maybe I should be using another tool for creating the pdf files? Any help would be appreciated. Ecxel 2003/Acrobat Distiller 5 Tag: multiple functions in a single cell Tag: 497569
- Next
  - 1
    - Keep sheet from deleting contents Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100") Is there a way to keep the contents on the "Parts Sent to Assembly" sheet once the "Sent to Assembly" sheet contents are deleted. Thanks in advance. Tag: multiple functions in a single cell Tag: 497562
  - 2
    - Right clicking to summon Format Cells. In cells A1 I have Name-in cell B1 Location C1Title E1 Hire Date F1 Salary. I then have inserted A new Collumn D1 which is called Service. In cell E2 I have a Hire Date of 11/24/98 and in cell F2 Salary is $29,500. In the newly formed Collumn D in D2 I have a Formula =(Today()-E2)/365. I should be getting the Value 4.9, But I come up with 9.306849315. When right clicking on the Hire Date collumn to format cells and choosing the Number Tab and then clicking Date I need the sample area in the format dialog box to specifically say "Date" to correctly come to the right value. How could a beginner trouble shoot this problem in formatimg cells to come to the correct value? Tag: multiple functions in a single cell Tag: 497561
  - 3
    - Vlookup w/multiple lookups Value 1 Value 2 Value 3 1 1 A 1 2 B 2 1 C 2 2 D I want to lookup value 3, but I want use both value 1 & 2 before. What's the best way to accomplish this. Tag: multiple functions in a single cell Tag: 497555
  - 4
    - How stop Excel default display of pasted number as scientific equa How do I stop excel from displaying stings of numbers pasted or imported into excel as a scientific equation? Like 5.73E+08 when the real part number is 549575667. The data displayed in the formula bar is the correct full number but Excel displays the data with the decimal and "+", it does this with imported data from Monarch as well as just a cut and paste from another program. If it is one or two number s I can retype directly and it will not happen but I am pulling data lists with thousands of part numbers. This problems seems worse now that I have Office 2007. Any suggestions? Tag: multiple functions in a single cell Tag: 497549
  - 5
    - Vlookup referring to External Workbook or Spreadsheet I'm trying to use a vlookup formula and refer to a range name located in an external spreadsheet but it is not working. Formula is as follows: =IF(ISERROR(VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories.xls]fata',8,FALSE)),"",VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories.xls]fata',8,FALSE)) The formula is 1st checking to see if the text in cell B13 is within the "fata" range in the external spreadsheet. If the text in B13 is not found, there would be an error. If there is an error, my IF statement should return a blank cell indicated by the double quotes (""). If the formula finds the text in cell B13, the value should be picked up from column 8 within the "fata" range. Somehow this formula is not valid but I'm not sure where? I feel very stupid right now so any help would be great. Thanks Tag: multiple functions in a single cell Tag: 497542
  - 6
    - End Down goes to infinity If column 1 has data in each of the, say, first 100 rows, and Iinsert an adjacent column 2 and ensure that column 2 is empty, then I enter data in the first cell of column 2, then I try to copy the new cell down all the way down to the bottom of the row that is the same as the last row of column 1, how can I take advantage of column 1? I sort of would like to press copy A2 then move left to column 1, then do End Down, then move back to column 2, then press Enter. But I always end up down at infinity at the bottom of Excel. Any clues? Thanks. Tag: multiple functions in a single cell Tag: 497539
  - 7
    - Can you use multiple operators in a single formula? I am trying to write a formula that returns the results of 90 Days, 60 Days, 30 Days and Current based on outstanding invoices. I have an age of invoice cell that tells me the age of the invoice and i want to write a formula from that cell telling me from the current date which category they fall into. Any help would be appreciated. Tag: multiple functions in a single cell Tag: 497536
  - 8
    - Count a Range, but only those cells with Black font Q I have the formula below that counts the number of instances of the value held in A43 that appears in the range D9:AG35, but how could I also include the qualifier thatonly count the number of these values that are in Black font? Is this possible? =COUNTIF($D$9:$AG$35,A43) Tag: multiple functions in a single cell Tag: 497535
  - 9
    - Lookup formula I have 2 worsheets (sheet 1 & sheet 2). Column B of sheet 2 (Product Name) needs data from sheet 1. Data in Sheet 1 is column A=Vendor Name , column B = Product Name. I need to sort through sheet 1 to create a list in sheet 2 that specifies product name per vendor (i.e. all the products from Pepsi). I tried the following formula, but it only works if there is 1 product from Pepsi. The formula in B2 is =VLOOKUP(A1,Sheet1!B$2:C$1000,2,FALSE). What formula should I use to sort through sheet 1 to get all the products from Pepsi? Thank you in advance. Tag: multiple functions in a single cell Tag: 497531
  - 10
    - Modify Code I did some searching on the code I need and this one is close! Can anyone help me modify it. All I need for it to do is copy sheet2 entire row and send it to sheet1. Then when I delete the contents in sheet 2 it will remain in sheet1. Each time something is added to sheet2 copy that entire row to sheet1. Then move down to next row and so on. Thanks in advance! Dim MyRange, MyRange1 As Range Sheets("Sent to Assembly").Select LastRow = Sheets("Sent to Assembly").Range("C65536").End(xlUp).Row Set MyRange = Sheets("Sent to Assembly").Range("C1:C" & LastRow) For Each C In MyRange If C.Value <> 0 Then If MyRange1 Is Nothing Then Set MyRange1 = C.EntireRow Else Set MyRange1 = Union(MyRange1, C.EntireRow) End If End If Next MyRange1.Select Selection.Copy Sheets("Sheet1").Select Range("A3").Select ActiveSheet.Paste Tag: multiple functions in a single cell Tag: 497529
  - 11
    - Using Lookup Function based on Font Color Hello! I have several rows of data currently in which I would like to pull data from. I could very easily use the LOOKUP function to do this. However, both the lookup range and vector range are all numbers. I only want the LOOKUP function to search for LOOKUP Values that are in a certain font color (red). To my knowledge, the LOOKUP Value can only be a number, text, logical value, or name or reference to a cell. Font Color is not one of my options. Does anyone have any ideas? Am I missing an easy step? Thanks for your time! Tag: multiple functions in a single cell Tag: 497528
  - 12
    - How to multiply hours by a dollar amount Thanks to Biff for helping me get the first of my timesheet problems figured out. Now I am hoping to be able to take the amount of hours and multiply it by a dollar amount to get a total. So I want to take 25:30 (column a) and multiply that by $5 hour (column c) to get a grand total. So I put in: =a28*c28 and it gives me $3.92 which is obviously not right. Column a is formatted as [h:mm] and column c is formatted as currency which I think is where my problem is but don't know what I need to do to fix it. Thanks for any insight. Tag: multiple functions in a single cell Tag: 497520
  - 13
    - Grabbing data from a specific cell Hello all, Iâ??m trying to get Excel to grab data from a specific cell on an external spreadsheet through a pastlink and populate that data to 2nd spreadsheet that will be tag as a read-only document (for view purposes only). The data in the first sheet will change when new lines are inserted above or are placed at the original cell location. example: First spreadsheet cell A5 has the number 5 in it, that data is pastelinked to a second (read only) spreadsheet where it is displayed. Now at row A4 I insert 4 new rows to allow room for the new data that will be copied here. The new data in the same A5 cell is 10 and needs to display 10 on the second spreadsheet. How do I stop excel from following the first A5 and populating that data on the second external spreadsheet. I only want it too give me the data that will be in the A5 cell even after the lines are inserted above. I have tried using the =$A$5 but when the lines are adding the cell that carries the formula adjust to the new lines add and the calculated cell reads =$A$9. So is there away to lock-in on a specified cell and it not adjust to the new inserted lines. Thanks In need of help Tag: multiple functions in a single cell Tag: 497517
  - 14
    - Formula with sum/avg I have numbers in columns A1:A100 and B1:B100. I need the result for MAX(Ai / (Ai + Bi)). Is there a way to write a worksheet formula and avoid populating an intermediate column for Ai + Bi? Also, I'm trying to avoid writing a macro. Thank you. Tag: multiple functions in a single cell Tag: 497515
  - 15
    - HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET i like to create one worksheet which link to other 4 worksheet.after that i would like to change file name.i need your help.please my be you can. Tag: multiple functions in a single cell Tag: 497511
  - 16
    - Moving data from one worksheet to another I have one worksheets with multiple account codes listed in Col A, description in Col B and amounts listed in Col C, D, E & F. Each account code does not necessary have an amount assoicated with it, however some accounts have amounts in multiple columns. I would like to have a summary sheet which moves only lines with amounts and has a separate line for each amount. I'm not sure I'm explaining correctly, how do you enter a sample worksheet without the spacing going haywire so I can give a better example? Tag: multiple functions in a single cell Tag: 497506
  - 17
    - conditional formatting Thanks to Conan for answering my first similar question! I now have a follow-up question. Consider this data: Col A Col B Col C Col D Row 1 family_b bob family_b art Row 2 jim family_b bob Row 3 kirk family_d will Row 4 greg family_e sam 1) If "bob" in Col B is found in Col D AND "family_b" ($A$1 a constant) is NOT found in Col C, then "bob" in Col B turns blue. OR 2) If "bob" in Col B is found in Col D AND "family_b" ($A$1 a constant) IS found in Col C then "bob" in Col B turns red. I can accomplish either #1 or #2 separately. But i can't seem to put both together. ("bob" in Col B will turn red in above data. If I remove "family_b" from Col C then "bob" in Col B would turn blue. $A$1 will change with manual input to a different "family_x".) Thanks, casey Tag: multiple functions in a single cell Tag: 497503
  - 18
    - if then else if nested functions in excel I need code to give the following result: (I've tried and failed, tho I think I'm close) if A=0 then " " else if B="Y" then (H8-(H8*O8)) else if B="N" then H8 here's what I have now: =IF(H8=0," ",(IF D8="Y",(H8-(H8*O8)),(IF D8="N",H8))) Tag: multiple functions in a single cell Tag: 497501
  - 19
    - SPSS DATA FILE Does anyone know how to access or open a SPSS data file. Tag: multiple functions in a single cell Tag: 497500
  - 20
    - Managing columns How do I cause a certain column to be always to the right no matter what else may be entered in? Stated differently, can I set up a column to shift over to the right so that it is always the last one on the sheet? Tag: multiple functions in a single cell Tag: 497499
  - 21
    - Auto Refresh of Pivot Tables not working I've created a pivot table based on a worksheet that repopulates each time the file is opened in Excel. I've marked the Pivot Table to automatically refresh upon open. The underlying data refreshes just fine, the pivot table does not. Any suggestions? Excel 2003 Tag: multiple functions in a single cell Tag: 497495
  - 22
    - how do I stop scrolling from column to column ? Somehow (in Excel) I inadvertantly turned off the left-right, up-down directionals and started scrolling instead from column to column. How do I get back to the cells? Tag: multiple functions in a single cell Tag: 497494
  - 23
    - Conditional Formatting in ref to active cell I would like to apply conditional formatting in column B to highlight the cell in the same row as the active/selected cell. Is there a way to reference the active cell in a function/formula? I'm using 2003 pro. Tag: multiple functions in a single cell Tag: 497487
  - 24
    - Moving data from one worksheet to another I am trying to move data from one worksheet to another - Data Sheet CC Description M S O L 010000 Labor Summary 5,000 011700 Burden 1000 020000 Site Work 2000 3000 030000 Concrete 5000 500 040000 Masonry 160000 Electrical 10000 This is how I want the result to look - Summary Sheet Cost Code CT Description Amount 010000 L Labor Summary 5000 011700 O Burden 1000 020000 M Site Work 2000 020000 S Site Work 3000 030000 M Concrete 5000 030000 O Concrete 500 160000 S Electrical 10000 Basically it moves only lines with data (040000 Masonry does not have an amount on the data sheet so it does not move to the summary sheet). If a cost code (row) has multiple entries it moves to the summary sheet on two rows with the associated description (Site Work, Concrete). Hope I have explained my problem ok. This is my first post, I have looked at several posts and nothing quite fits what I need. Any help would be greatly appreciated. Tag: multiple functions in a single cell Tag: 497486
  - 25
    - Default Shading Darkness on Cells Selected is there a way to make the default shading darker when you CTRL click random cells. I can't see the cells that I've clicked on because the shade is so light. I hope I'm explaining this clearly. thanks, patryse Tag: multiple functions in a single cell Tag: 497484

Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!

Re: multiple functions in a single cell by Bernard

Bernard
Fri Mar 14 14:29:23 CDT 2008

=IF(G4=2,"Cathy's Check", if(G4=3,"John's Check" ,"")

This is display nothing if G4 is other than 2 or 3
If the list gets longer, a lookup function would be appropriate.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C." <John C.@discussions.microsoft.com> wrote in message
news:4A5EA553-8ECF-439E-9F7F-591AD723E2E5@microsoft.com...
> Example: I want to be able to display "Cathy's Check" in cell G4 by typing
> the number "2" in cell B4 but I also want to display "John's Check" in
> cell
> G4 by typing the number "3" in cell B4 as well. Can some one help me
> please!

RE: multiple functions in a single cell by GarysStudent

GarysStudent
Fri Mar 14 14:33:02 CDT 2008

Use an IF statement in G4:

=IF(B4=2,"Cathy's Check",IF(B4=3,"John'sCheck",""))
--
Gary''s Student - gsnu200773

"John C." wrote:

> Example: I want to be able to display "Cathy's Check" in cell G4 by typing
> the number "2" in cell B4 but I also want to display "John's Check" in cell
> G4 by typing the number "3" in cell B4 as well. Can some one help me please!

RE: multiple functions in a single cell by MikeH

MikeH
Fri Mar 14 14:35:00 CDT 2008

Try this in G4

=CHOOSE(B4,"","Cathy's Check","John's check")

Mike

"John C." wrote:

> Example: I want to be able to display "Cathy's Check" in cell G4 by typing
> the number "2" in cell B4 but I also want to display "John's Check" in cell
> G4 by typing the number "3" in cell B4 as well. Can some one help me please!