Functions
in [Excel]
|
Copying Certain Worksheets depending on certain criterion I have an excel file that contains multiple templates that I need to copy depending on certain criterion. I have set up two columns for this purpose. The first column contains the names of the worksheet to be made and the second column will be which template to copy. I have been trying to figure out a way but stuck... 24 May 2010 23:27
Countif Formulas I have two worksheets. I want to feed data from one to the next to tally occurrences of key words in two columns according to month in another column Worksheet 1 A B C 01/15/2009 Keyword Keyword 01/05/2009 Keyword Keyword 02/12/2009 Keyword Keyword Worksheet 2 A ... 27 May 2010 18:11
Question About Importing Columns From A Datasheet to A Workshe Thank you Naftoli, Will the data change and update on all sheets when I edit the datasheet? I'm not sure it will. "Naftoli" wrote: Copy worksheet (right click on bottom tab) and delete or re-arrange columns. -- Naftoli "M.J.Goode" wrote: I am asking for any help you can give me r... 28 May 2010 15:59
month name There is a function to show the number of the 1-12. Is there a way to show the name? ... 24 May 2010 21:17
Partial Text Match then enter desired result into appropriate colu I have a list of company names in Column A. On a separate tab I have a list of keywords. What I'd like to do is to have a search done on the names in column A and if any of the keywords on the separate tab match for it to then put in the company type into column B. Example of a company name in column A: ... 24 May 2010 19:04
Two Condition - search I am trying to pull value when two conditions are met. want to count column "B" when it = "ETARC" and when column "J" is = "0" or a negative number. I have tried =COUNTIF(B11:B26,"=ETARC")+COUNTIF(J8:J24,""<>0) the formula is only pulling the column "B" infor and the same number for column "J". My answer ... 24 May 2010 15:44
Count number of rows with specific text I am using this formula to count the number of rows in Column C with text. =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500))) I need, instead, for this formula to count the number of rows in Column C with specific text i.e. the text “PUSH”. Can you help? ... 24 May 2010 16:50
Embedded lookup Can a lookup be embedded in another lookup? A file has separate sheets for each month with identical formats. A file has 13 sheets, one for each month and a YTD sheet. Each sheet has P&L data for multiple companies and the YTD sheet has a data entry field to identify the current month. Based on the value in ... 25 May 2010 05:52
Question About Importing Columns From A Datasheet to A Worksheet I am asking for any help you can give me regarding the best way to import columns from a datasheet into another worksheet. I have many worksheets to construct but I will need to include only a few select columns from the datasheet on each worksheet. Each worksheet will include a different assortment of columns... 25 May 2010 05:52 |